https://wiki.itcollege.ee/index.php?action=history&feed=atom&title=Praktikum8%3A_T%C3%B6%C3%B6_andmeallikatega%28II%29 2026-05-01T09:32:04Z Revision history for this page on the wiki MediaWiki 1.45.1 https://wiki.itcollege.ee/index.php?title=Praktikum8:_T%C3%B6%C3%B6_andmeallikatega(II)&diff=94394&oldid=prev 2015-10-22T08:15:24Z

<p><span class="autocomment">Eelinfo</span></p> <table style="background-color: #fff; color: #202122;" data-mw="interface"> <col class="diff-marker" /> <col class="diff-content" /> <col class="diff-marker" /> <col class="diff-content" /> <tr class="diff-title" lang="en"> <td colspan="2" style="background-color: #fff; color: #202122; text-align: center;">← Older revision</td> <td colspan="2" style="background-color: #fff; color: #202122; text-align: center;">Revision as of 11:15, 22 October 2015</td> </tr><tr><td colspan="2" class="diff-lineno" id="mw-diff-left-l6">Line 6:</td> <td colspan="2" class="diff-lineno">Line 6:</td></tr> <tr><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>**Nüüd peaks töötama. Kui aga kirjutati mingi muu nimi, siis lihtsalt asenda see ja kirjuta (localdb)\nimimisolijutumärkide vahel</div></td><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>**Nüüd peaks töötama. Kui aga kirjutati mingi muu nimi, siis lihtsalt asenda see ja kirjuta (localdb)\nimimisolijutumärkide vahel</div></td></tr> <tr><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><br></td><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><br></td></tr> <tr><td class="diff-marker" data-marker="−"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #ffe49c; vertical-align: top; white-space: pre-wrap;"><div>'''Loengus tehtud näited asuvad [http://enos.itcollege.ee/~mposka/CSharp2015/Paevaope/Loengud/Loeng07/ siin]''' &lt;br/&gt;</div></td><td class="diff-marker" data-marker="+"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div>'''Loengus tehtud <ins style="font-weight: bold; text-decoration: none;">AB </ins>näited asuvad [http://enos.itcollege.ee/~mposka/CSharp2015/Paevaope/Loengud/Loeng07/ siin]''' &lt;br/&gt;</div></td></tr> <tr><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>&#039;&#039;&#039;Loengus tehtud Service&#039;ite ja BOde näide asub [http://enos.itcollege.ee/~mposka/CSharp2015/Paevaope/Loengud/Loeng08/ siin]&#039;&#039;&#039; See tuleks võtta rakenduse realiseerimisel aluseks</div></td><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>&#039;&#039;&#039;Loengus tehtud Service&#039;ite ja BOde näide asub [http://enos.itcollege.ee/~mposka/CSharp2015/Paevaope/Loengud/Loeng08/ siin]&#039;&#039;&#039; See tuleks võtta rakenduse realiseerimisel aluseks</div></td></tr> <tr><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><br></td><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><br></td></tr> </table>

Mposka https://wiki.itcollege.ee/index.php?title=Praktikum8:_T%C3%B6%C3%B6_andmeallikatega(II)&diff=94393&oldid=prev 2015-10-22T08:15:12Z

<p></p> <table style="background-color: #fff; color: #202122;" data-mw="interface"> <col class="diff-marker" /> <col class="diff-content" /> <col class="diff-marker" /> <col class="diff-content" /> <tr class="diff-title" lang="en"> <td colspan="2" style="background-color: #fff; color: #202122; text-align: center;">← Older revision</td> <td colspan="2" style="background-color: #fff; color: #202122; text-align: center;">Revision as of 11:15, 22 October 2015</td> </tr><tr><td colspan="2" class="diff-lineno" id="mw-diff-left-l6">Line 6:</td> <td colspan="2" class="diff-lineno">Line 6:</td></tr> <tr><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>**Nüüd peaks töötama. Kui aga kirjutati mingi muu nimi, siis lihtsalt asenda see ja kirjuta (localdb)\nimimisolijutumärkide vahel</div></td><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>**Nüüd peaks töötama. Kui aga kirjutati mingi muu nimi, siis lihtsalt asenda see ja kirjuta (localdb)\nimimisolijutumärkide vahel</div></td></tr> <tr><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><br></td><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><br></td></tr> <tr><td class="diff-marker" data-marker="−"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #ffe49c; vertical-align: top; white-space: pre-wrap;"><div>'''Loengus tehtud näited asuvad [http://enos.itcollege.ee/~mposka/CSharp2015/Paevaope/Loengud/Loeng07/ siin]'''</div></td><td class="diff-marker" data-marker="+"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div>'''Loengus tehtud näited asuvad [http://enos.itcollege.ee/~mposka/CSharp2015/Paevaope/Loengud/Loeng07/ siin]''' <ins style="font-weight: bold; text-decoration: none;">&lt;br/&gt;</ins></div></td></tr> <tr><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>&#039;&#039;&#039;Loengus tehtud Service&#039;ite ja BOde näide asub [http://enos.itcollege.ee/~mposka/CSharp2015/Paevaope/Loengud/Loeng08/ siin]&#039;&#039;&#039; See tuleks võtta rakenduse realiseerimisel aluseks</div></td><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>&#039;&#039;&#039;Loengus tehtud Service&#039;ite ja BOde näide asub [http://enos.itcollege.ee/~mposka/CSharp2015/Paevaope/Loengud/Loeng08/ siin]&#039;&#039;&#039; See tuleks võtta rakenduse realiseerimisel aluseks</div></td></tr> <tr><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><br></td><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><br></td></tr> </table>

Mposka https://wiki.itcollege.ee/index.php?title=Praktikum8:_T%C3%B6%C3%B6_andmeallikatega(II)&diff=94392&oldid=prev 2015-10-22T08:14:59Z

<p><span class="autocomment">Eelinfo</span></p> <table style="background-color: #fff; color: #202122;" data-mw="interface"> <col class="diff-marker" /> <col class="diff-content" /> <col class="diff-marker" /> <col class="diff-content" /> <tr class="diff-title" lang="en"> <td colspan="2" style="background-color: #fff; color: #202122; text-align: center;">← Older revision</td> <td colspan="2" style="background-color: #fff; color: #202122; text-align: center;">Revision as of 11:14, 22 October 2015</td> </tr><tr><td colspan="2" class="diff-lineno" id="mw-diff-left-l7">Line 7:</td> <td colspan="2" class="diff-lineno">Line 7:</td></tr> <tr><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><br></td><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><br></td></tr> <tr><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>&#039;&#039;&#039;Loengus tehtud näited asuvad [http://enos.itcollege.ee/~mposka/CSharp2015/Paevaope/Loengud/Loeng07/ siin]&#039;&#039;&#039;</div></td><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>&#039;&#039;&#039;Loengus tehtud näited asuvad [http://enos.itcollege.ee/~mposka/CSharp2015/Paevaope/Loengud/Loeng07/ siin]&#039;&#039;&#039;</div></td></tr> <tr><td colspan="2" class="diff-side-deleted"></td><td class="diff-marker" data-marker="+"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div><ins style="font-weight: bold; text-decoration: none;">'''Loengus tehtud Service'ite ja BOde näide asub [http://enos.itcollege.ee/~mposka/CSharp2015/Paevaope/Loengud/Loeng08/ siin]''' See tuleks võtta rakenduse realiseerimisel aluseks</ins></div></td></tr> <tr><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><br></td><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><br></td></tr> <tr><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>NB! Peale SQL Server Management Studio eemalda linnuke valiku &quot;Prevent saving changes that require table re-creation&quot;</div></td><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>NB! Peale SQL Server Management Studio eemalda linnuke valiku &quot;Prevent saving changes that require table re-creation&quot;</div></td></tr> </table>

Mposka https://wiki.itcollege.ee/index.php?title=Praktikum8:_T%C3%B6%C3%B6_andmeallikatega(II)&diff=92944&oldid=prev 2015-10-19T14:20:34Z

<p><span class="autocomment">Käsi_hoitud_tegevus</span></p> <table style="background-color: #fff; color: #202122;" data-mw="interface"> <col class="diff-marker" /> <col class="diff-content" /> <col class="diff-marker" /> <col class="diff-content" /> <tr class="diff-title" lang="en"> <td colspan="2" style="background-color: #fff; color: #202122; text-align: center;">← Older revision</td> <td colspan="2" style="background-color: #fff; color: #202122; text-align: center;">Revision as of 17:20, 19 October 2015</td> </tr><tr><td colspan="2" class="diff-lineno" id="mw-diff-left-l17">Line 17:</td> <td colspan="2" class="diff-lineno">Line 17:</td></tr> <tr><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><br></td><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><br></td></tr> <tr><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>=Käsi_hoitud_tegevus=</div></td><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>=Käsi_hoitud_tegevus=</div></td></tr> <tr><td colspan="2" class="diff-side-deleted"></td><td class="diff-marker" data-marker="+"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div><ins style="font-weight: bold; text-decoration: none;">Käsi hoitud tegevuse iseseisvalt realiseerimine annab 2 boonuspunkti. </ins></div></td></tr> <tr><td colspan="2" class="diff-side-deleted"></td><td class="diff-marker" data-marker="+"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div><ins style="font-weight: bold; text-decoration: none;"></ins></div></td></tr> <tr><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>*Loo Kontaktid.DAL ja genereeri sinna Entity Frameworki poolt loodud mudelid</div></td><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>*Loo Kontaktid.DAL ja genereeri sinna Entity Frameworki poolt loodud mudelid</div></td></tr> <tr><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>*Testimise jaos kirjuta konsoolirakendusse kolm meetodit</div></td><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>*Testimise jaos kirjuta konsoolirakendusse kolm meetodit</div></td></tr> <tr><td colspan="2" class="diff-lineno" id="mw-diff-left-l30">Line 30:</td> <td colspan="2" class="diff-lineno">Line 32:</td></tr> <tr><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>*otsiNimeJargi - tagastab kõik inimesed, kelle eesnimi või perenimi sisaldab kaas antud otsitavat fraasi  </div></td><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>*otsiNimeJargi - tagastab kõik inimesed, kelle eesnimi või perenimi sisaldab kaas antud otsitavat fraasi  </div></td></tr> <tr><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>*annaKontaktidInimeseIdJargi - annab ühe inimese kõik kontaktandmed</div></td><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>*annaKontaktidInimeseIdJargi - annab ühe inimese kõik kontaktandmed</div></td></tr> <tr><td class="diff-marker" data-marker="−"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #ffe49c; vertical-align: top; white-space: pre-wrap;"><div>*leiaInimeneKontaktiJargi - <del style="font-weight: bold; text-decoration: none;">annab vastavalt </del>meetodiele <del style="font-weight: bold; text-decoration: none;">etteantud </del></div></td><td class="diff-marker" data-marker="+"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div>*leiaInimeneKontaktiJargi - meetodiele <ins style="font-weight: bold; text-decoration: none;">antakse kaasa fraas a'la 556 või peeter.pakiraam ning selle järgi proovitakse leida inimene/inimesed, kes omavad selliseid kontaktandmeid.</ins></div></td></tr> <tr><td class="diff-marker" data-marker="−"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #ffe49c; vertical-align: top; white-space: pre-wrap;"><div><del style="font-weight: bold; text-decoration: none;"> </del></div></td><td class="diff-marker" data-marker="+"></td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div> </div></td></tr> <tr><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>=Käsi_mittehoitud_tegevus=</div></td><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>=Käsi_mittehoitud_tegevus=</div></td></tr> <tr><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><br></td><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><br></td></tr> <tr><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>=Mul_on_igav_teeks_ka_midagi_tegevus=</div></td><td class="diff-marker"></td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>=Mul_on_igav_teeks_ka_midagi_tegevus=</div></td></tr> <!-- diff cache key ico_mediawiki-ITK_:diff:1.41:old-92943:rev-92944:php=table --> </table>

Mposka https://wiki.itcollege.ee/index.php?title=Praktikum8:_T%C3%B6%C3%B6_andmeallikatega(II)&diff=92943&oldid=prev 2015-10-19T14:17:59Z

<p>Created page with &quot;=Eelinfo= SQL Server Management Studioga ühendades proovi SQL server name&#039;ina: *(localdb)\v11.0 (kui see ei tööta, proovi järgmist) *(localdb)\MSSQLLocalDB **Kui see ka ei...&quot;</p> <p><b>New page</b></p><div>=Eelinfo=<br /> SQL Server Management Studioga ühendades proovi SQL server name&#039;ina:<br /> *(localdb)\v11.0 (kui see ei tööta, proovi järgmist)<br /> *(localdb)\MSSQLLocalDB<br /> **Kui see ka ei tööta, siis ava Command Prompt ning kirjuta: &#039;&#039;sqllocaldb start&#039;&#039; Alla peaks tulema teade: &#039;&#039;LocalDB instance &quot;MSSQLLocalDB&quot; started.&#039;&#039; <br /> **Nüüd peaks töötama. Kui aga kirjutati mingi muu nimi, siis lihtsalt asenda see ja kirjuta (localdb)\nimimisolijutumärkide vahel<br /> <br /> &#039;&#039;&#039;Loengus tehtud näited asuvad [http://enos.itcollege.ee/~mposka/CSharp2015/Paevaope/Loengud/Loeng07/ siin]&#039;&#039;&#039;<br /> <br /> NB! Peale SQL Server Management Studio eemalda linnuke valiku &quot;Prevent saving changes that require table re-creation&quot;<br /> *Selle leiad, kui avada SQL Server Management Studiost Tools -&gt; Options -&gt; Designer <br /> <br /> Jaga rakendus kihtidesse.Vajalikud on Kontaktid.DAL ja Kontaktid.BLL <br /> <br /> *Kontaktid.DAL sisaldab endas Entity Frameworki poolt loodud mudelit. Selle tegemist saab vaadata 7ndast ja 8ndast loengust ning ka 7ndast praktikumist<br /> *Kontaktid.BLL kihti tuleb rakenduse äriloogika ning BO mudelid(vt. 8ndat loengut)<br /> <br /> =Käsi_hoitud_tegevus=<br /> *Loo Kontaktid.DAL ja genereeri sinna Entity Frameworki poolt loodud mudelid<br /> *Testimise jaos kirjuta konsoolirakendusse kolm meetodit<br /> **Esimene võimaldab lisada inimese<br /> **Teine võimaldab lisada uue kontaktiliigi<br /> **Kolmas võimaldab lisada uue kontakti<br /> <br /> *Lisa Visual Studio Solutionisse veel üks projekt(näiteks Console Application) ning anna selle nimeks Kontaktid.BLL<br /> **Loo eraldi kaust, kuhu tulevad BO&#039;d<br /> **Loo eraldi kaust, kuhu tulevad Service&#039;id.<br /> BLL kihis realiseeri jägnevad meetodid:<br /> *annaInimesed - tagastab kõik inimesed, kes on andmebaasis märgitud kui aktiivsed ning sorteerib perekonnanime järgi<br /> *otsiNimeJargi - tagastab kõik inimesed, kelle eesnimi või perenimi sisaldab kaas antud otsitavat fraasi <br /> *annaKontaktidInimeseIdJargi - annab ühe inimese kõik kontaktandmed<br /> *leiaInimeneKontaktiJargi - annab vastavalt meetodiele etteantud <br /> <br /> =Käsi_mittehoitud_tegevus=<br /> <br /> =Mul_on_igav_teeks_ka_midagi_tegevus=</div>

Mposka