➨ 2 ❶㻌 䝕䞊䝍䝧䞊䝇䜈䛾᥋⥆ 䕔 ᶵ⬟㻌 䝕䞊䝍䝥䝻䝞䜲䝎䞊䛿䚸䝕䞊䝍䝧䞊䝇᥋⥆䚸䜽䜶䝸ᐇ⾜䚸⤖ᯝ䛾ྲྀᚓ䛸䛔䛳䛯䚸䝕䞊䝍䝧䞊䝇᧯స䛾 ᶵ⬟䜢ᥦ౪䛧䜎䛩䚹 䛣䜜䜙䛾ᶵ⬟䛿䚸」ᩘ䛾䜸䝤䝆䜵䜽䝖䛸䛧䛶ᥦ౪䛥䜜䛶䛔䜎䛩䚹䛯䛸䛘䜀䚸䝕䞊䝍䝧䞊䝇䛸䛾᥋⥆䛿 Connection 䜸䝤䝆䜵䜽䝖䜢⏝䛔䛶䚸䜽䜶䝸䛾ᐇ⾜䛿 Command 䜸䝤䝆䜵䜽䝖䜢⏝䛔䜎䛩䚹䜎䛯䚸䜽䜶䝸 䛻䜘䛳䛶㏉䛥䜜䜛⤖ᯝ䛿䚸DataReader 䜸䝤䝆䜵䜽䝖䛷ㄞ䜏ྲྀ䜚䜎䛩䚹 䕔 ≉ᚩ㻌 䝕䞊䝍䝥䝻䝞䜲䝎䞊䛜ᥦ౪䛩䜛 DataReader 䜸䝤䝆䜵䜽䝖䛿䚸䜽䜶䝸䛾ᐇ⾜⤖ᯝ䛻ᑐ䛧䛶㧗㏿䛻ㄞ䜏 ྲྀ䜚ᑓ⏝䛾䜰䜽䝉䝇䛜䛷䛝䜛䛯䜑䚸䝕䞊䝍䝧䞊䝇䛾᳨⣴⤖ᯝ䜢⾲♧䛩䜛䛾䛻㐺䛧䛶䛔䜎䛩䚹 䜎䛯䚸DataReader 䜸䝤䝆䜵䜽䝖䛿䚸᳨⣴⤖ᯝ䜢 1 ⾜䛪䛴ฎ⌮䛩䜛䛾䛷䚸䝯䝰䝸䛻䛿ᖖ䛻 1 ௳ศ䛾 䝕䞊䝍䛧䛛Ꮡᅾ䛧䜎䛫䜣䚹䛭䛾䛯䜑䚸㑅ᢥ䜽䜶䝸䛾ᐇ⾜䛻䜘䛳䛶㔞䛾䝕䞊䝍䛜᳨⣴䛥䜜䛶䜒䚸⏝䛥 䜜䜛䝯䝰䝸䛿᭱ᑠ㝈䛷䛩䜏䜎䛩䚹 12 ➨ 2 ❶㻌 䝕䞊䝍䝧䞊䝇䜈䛾᥋⥆ 䝕䞊䝍䝥䝻䝞䜲䝎䞊䛿䚸䝕䞊䝍䝋䞊䝇䛸䛾䜲䞁䝍䞊䝣䜵䜲䝇䛷䛒䜛䛯䜑䚸䝕䞊䝍䝋䞊䝇䛤䛸䛻⏝ព䛩䜛 ᚲせ䛜䛒䜚䜎䛩䚹.NET Framework 2.0 䛻䛿䚸௨ୗ䛾 4 䛴䛾䝕䞊䝍䝥䝻䝞䜲䝎䞊䛜ྵ䜎䜜䛶䛔䜎䛩䚹 䕔 㻿㻽㻸㻌 㻿㼑㼞㼢㼑㼞㻌 䝕䞊䝍䝥䝻䝞䜲䝎䞊㻌 SQL Server 7.0 ௨㝆䛾䛯䜑䛻㛤Ⓨ䛥䜜䛯䝕䞊䝍䝥䝻䝞䜲䝎䞊䛷䛩䚹䜰䞁䝬䝛䞊䝆䝁䞊䝗䜢⏝䛧䛺 䛔䛯䜑䚸OLE DB 䝕䞊䝍䝥䝻䝞䜲䝎䞊䜢⏝䛩䜛䜘䜚䜒㧗㏿䛷䛩䚹 䕔 㻻㼞㼍㼏㼘㼑䝕䞊䝍䝥䝻䝞䜲䝎䞊㻌 Oracle DB 䛾䛯䜑䛻㛤Ⓨ䛥䜜䛯䝕䞊䝍䝥䝻䝞䜲䝎䞊䛷䛩䚹.NET Framework 4.5 ௨㝆䛷䛿䝃䝫䞊䝖 䛥䜜䜎䛫䜣䛾䛷䚸Oracle ♫䛜ᥦ౪䛧䛶䛔䜛 ODP.NET䠄Oracle Data Provider for .NET䠅䜢⏝䛧䜎 䛩䚹 䕔 㻻㻸㻱㻌 㻰㻮㻌 䝕䞊䝍䝥䝻䝞䜲䝎䞊㻌 OLE DB 䝥䝻䝞䜲䝎䛜ᥦ౪䛥䜜䛶䛔䜛䝕䞊䝍䝋䞊䝇⏝䛾䝕䞊䝍䝥䝻䝞䜲䝎䞊䛷䛩䚹OLE DB 䝥䝻䝞䜲 䝎䜢⏝䛩䜛䛯䜑䚸䝬䝛䞊䝆䝁䞊䝗䛸䜰䞁䝬䝛䞊䝆䝁䞊䝗䛾ቃ⏺㉺䛘䛾䜸䞊䝞䞊䝦䝑䝗䛜䛒䜚䜎䛩䚹 13 ➨ 2 ❶㻌 䝕䞊䝍䝧䞊䝇䜈䛾᥋⥆ 䕔 㻻㻰㻮㻯㻌 䝕䞊䝍䝥䝻䜲䝎㻌 ODBC 䝗䝷䜲䝞䛜ᥦ౪䛥䜜䛶䛔䜛䝕䞊䝍䝋䞊䝇⏝䛾䝕䞊䝍䝥䝻䝞䜲䝎䞊䛷䛩䚹ODBC 䝗䝷䜲䝞䜢⏝ 䛩䜛䛯䜑䚸䝬䝛䞊䝆䛸䜰䞁䝬䝛䞊䝆䝁䞊䝗䛾ቃ⏺㉺䛘䛾䜸䞊䝞䞊䝦䝑䝗䛜䛒䜚䜎䛩䚹 䛣䜜䜙䛾.NET 䝥䝻䝞䜲䝎௨እ䛻䜒䚸䛥䜎䛦䜎䛺䝧䞁䝎䞊䜔䝃䞊䝗䝟䞊䝔䜱䛛䜙䚸䝕䞊䝍䝥䝻䝞䜲䝎䞊 䛜ᥦ౪䛥䜜䛶䛔䜎䛩䚹 䝫䜲䞁䝖䟿䠖䝕䞊䝍䝥䝻䝞䜲䝎䞊䛾ྛ䜽䝷䝇ྡ䛻䛿䚸䝥䝻䝞䜲䝎䞊ẖ䛾䝥䝸䝣䜱䝑䜽䝇䛜䛴䛔䛶䛔䜎䛩䚹 䛯䛸䛘䜀䚸Connection 䜸䝤䝆䜵䜽䝖䛾䜽䝷䝇ྡ䛿䚸௨ୗ䛾䜘䛖䛻䛺䜚䜎䛩䚹 䝕䞊䝍䝥䝻䝞䜲䝎䞊䛾✀㢮 Connection 䛾䜽䝷䝇ྡ SQL Server 䝕䞊䝍䝥䝻䝞䜲䝎䞊 SqlConnection Oracle 䝕䞊䝍䝥䝻䝞䜲䝎䞊 OracleConnection OLE DB 䝕䞊䝍䝥䝻䝞䜲䝎䞊 OleDbConnection ODBC 䝕䞊䝍䝥䝻䝞䜲䝎䞊 OdbcConnection 㻌 䝫䜲䞁䝖䟿䠖SQL Server 䜔 Oracle 䜢⏝䛔䜛ሙྜ䚸OLE DB䚸ODBC 䝕䞊䝍䝥䝻䝞䜲䝎䞊䜢⏝䛩䜛䛣 䛸䜒䛷䛝䜎䛩䚹䛯䛰䛧䚸䛣䜜䜙䛾䝕䞊䝍䝥䝻䝞䜲䝎䞊䛿䚸OLE DB 䝗䝷䜲䝞䜔 ODBC 䝗䝷䜲䝞䛺䛹 䛾䜰䞁䝬䝛䞊䝆䝁䞊䝗䜢⏝䛩䜛䛯䜑䚸䜰䞁䝬䝛䞊䝆䛸䝬䝛䞊䝆䛾ቃ⏺㉺䛘䛜㉳䛣䜚䚸䜸䞊䝞䞊 䝦䝑䝗䛜⏕䛨䜎䛩䚹䛭䛾䛯䜑䚸ᑓ⏝䛾䝕䞊䝍䝥䝻䝞䜲䝎䞊䛜ᥦ౪䛥䜜䛶䛔䜛ሙྜ䛿䚸ᑓ⏝䝕䞊䝍 䝥䝻䝞䜲䝎䞊䜢⏝䛩䜛䛣䛸䛻䜘䜚䝟䝣䜷䞊䝬䞁䝇䛜ྥୖ䛧䜎䛩䚹 14 ➨ 2 ❶㻌 䝕䞊䝍䝧䞊䝇䜈䛾᥋⥆ Oracle Data Provider for .NET䠄ODP.NET䠅䛸䛿䚸Oracle ♫䛜ᥦ౪䛩䜛 ADO.NET 䛻‽ᣐ䛧䛯 Oracle 䝕䞊䝍䝧䞊䝇⏝䛾䝕䞊䝍䝥䝻䝞䜲䝎䞊䛷䛩䚹 䛣䜜䛻䜘䜚䚸Oracle 䝕䞊䝍䝧䞊䝇䜈䛾䝛䜲䝔䜱䝤᥋⥆䜔 Oracle 䝕䞊䝍䝧䞊䝇ᅛ᭷ᶵ⬟䛾⏝䛺䛹䛜 ྍ⬟䛻䛺䜚䜎䛩䚹䛚䜒䛺≉ᚩ䛿ḟ䛾䛸䛚䜚䛷䛩䚹 • PL/SQL 䛾䝃䝫䞊䝖 • Oracle 䝕䞊䝍ᆺ䛾䝃䝫䞊䝖 • 䝥䝻䜻䝅䞉䝴䞊䝄䞊ㄆドᶵ⬟ • ㏱㐣ⓗ䜰䝥䝸䜿䞊䝅䝵䞁䞉䝣䜵䜲䝹䜸䞊䝞䞊䠄TAF䠅䜈䛾ᑐᛂ 䛯䛰䛧䚸.NET Framework 䛺䜙䜃䛻 Visual Studio 䛻䛿 ODP.NET 䛿ῧ䛥䜜䛶䛔䛺䛔䛾䛷䚸ู㏵ Oracle ♫䜘䜚ධᡭ䞉䜲䞁䝇䝖䞊䝹䛩䜛ᚲせ䛜䛒䜚䜎䛩䚹 䜎䛯 Oracle ♫䛛䜙䛿 ODT.NET䠄Oracle Developer Tools for Visual Studio .NET䠅䜒ᥦ౪䛥䜜䛶䛔 䜎䛩䚹䛣䜜䜢⏝䛔䜛䛣䛸䛻䜘䜚䚸Visual Studio 䛻䝕䝄䜲䝘䞊䚸䝁䞊䝗⮬ື⏕ᡂ䚸PL/SQL 䜶䝕䜱䝍䛺䛹䛾 㛤Ⓨᨭᶵ⬟䜢㏣ຍ䛩䜛䛣䛸䛜䛷䛝䜎䛩䚹 15 ➨ 2 ❶㻌 䝕䞊䝍䝧䞊䝇䜈䛾᥋⥆ Visual Studio 䛾⤫ྜ㛤Ⓨ⎔ቃ䛷䛿䝥䝻䜾䝷䝮సᡂᨭᶵ⬟䛜㇏ᐩ䛻ᥦ౪䛥䜜䛶䛔䜎䛩䚹䛭䛾୰䛻 䛿䚸ADO.NET ྥ䛡䛾ᶵ⬟䜒䛒䜚䜎䛩䚹䛚䜒䛺䜒䛾䛿ḟ䛾䛸䛚䜚䛷䛩䚹 䕔 䝁䞁䝖䝻䞊䝹㻌 Windows 䜰䝥䝸䜿䞊䝅䝵䞁䜔 Web 䜰䝥䝸䜿䞊䝅䝵䞁䜢సᡂ䛩䜛䛯䜑䛾䝁䞁䝖䝻䞊䝹䛜ᥦ౪䛥䜜䛶䛚䜚䚸 䛣䜜䜙䜢⏝䛔䜛䛣䛸䛻䜘䜚䜰䝥䝸䜿䞊䝅䝵䞁సᡂ䛾䝁䞊䝕䜱䞁䜾㔞䜢ᖜ䛻๐ῶ䛩䜛䛣䛸䛜䛷䛝䜎䛩䚹 䕔 䝃䞊䝞䞊䜶䜽䝇䝥䝻䞊䝷䞊㻌 䝃䞊䝞䞊䜶䜽䝇䝥䝻䞊䝷䞊䜢⏝䛔䜛䛣䛸䛻䜘䛳䛶䚸Oracle 䝕䞊䝍䝧䞊䝇ୖ䛾䜸䝤䝆䜵䜽䝖䛾⟶⌮䜢䛚 䛣䛺䛖䛣䛸䛜䛷䛝䜎䛩䚹 16 ➨ 2 ❶㻌 䝕䞊䝍䝧䞊䝇䜈䛾᥋⥆ 䝒䞊䝹䝪䝑䜽䝇䛜⾲♧䛥䜜䛶䛔䛺䛔ሙྜ䛿䚸䛂⾲♧䛃䝯䝙䝳䞊䊻䛂䝒䞊䝹䝪䝑䜽䝇䛃䜢䜽䝸䝑䜽䛧䛶䚸䝒䞊 䝹䝪䝑䜽䝇䜢⾲♧䛧䜎䛩䚹 ADO.NET 㛵㐃䛾䝁䞁䝖䝻䞊䝹䛿䝒䞊䝹䝪䝑䜽䝇䛾䛂䝕䞊䝍䛃䝍䝤䛻⾲♧䛥䜜䜎䛩䚹 䝫䜲䞁䝖䟿䠖Visual Studio 䛾ึᮇ≧ែ䛷䛿䚸Oracle 㛵㐃䛾䝁䞁䝖䝻䞊䝹䛿㏣ຍ䛥䜜䛶䛔䜎䛫䜣䚹ḟ䛾 ᧯స䜢䛚䛣䛺䛖䛣䛸䛻䜘䜚䚸Oracle 㛵㐃䛾䝁䞁䝖䝻䞊䝹䜢㏣ຍ䛩䜛䛣䛸䛜䛷䛝䜎䛩䚹 䐟 䝒䞊䝹䝪䝑䜽䝇ୖ䛷䝬䜴䝇ྑ䝪䝍䞁䜢䜽䝸䝑䜽䛧䛶䛂䜰䜲䝔䝮䛾㑅ᢥ䛃䜢䜽䝸䝑䜽䛧䜎䛩䚹 䜽䝸䝑䜽 㻌 㻌 㻌 17 ➨ 2 ❶㻌 䝕䞊䝍䝧䞊䝇䜈䛾᥋⥆ 䐠 ⾲♧䛥䜜䛯䛂䝒䞊䝹䝪䝑䜽䝇䜰䜲䝔䝮䛾㑅ᢥ䛃䜴䜱䞁䝗䜴䛾䛂.NET Framework 䝁䞁䝫䞊䝛䞁䝖䛃䝍 䝤䛛䜙㏣ຍ䛩䜛䝁䞁䝫䞊䝛䞁䝖䜢㑅ᢥ䛧䜎䛩䚹 䝏䜵䝑䜽 㻌 䛣䛣䛷䛿ḟ䛾䝁䞁䝫䞊䝛䞁䝖䜢㑅ᢥ䛧䜎䛩䚹 ྡ๓ ྡ๓✵㛫 䜰䝉䞁䝤䝸ྡ OracleCommand Oracle.DataAccess.Client Oracle.DataAccess OracleCommandBuilder Oracle.DataAccess.Client Oracle.DataAccess OracleConnection Oracle.DataAccess.Client Oracle.DataAccess OracleDataAdapter Oracle.DataAccess.Client Oracle.DataAccess 䛣䜜䛻䜘䜚䚸䝒䞊䝹䝪䝑䜽䝇䛻䝁䞁䝖䝻䞊䝹䛜㏣ຍ䛥䜜䜎䛩䚹 㻌 18 ➨ 2 ❶㻌 䝕䞊䝍䝧䞊䝇䜈䛾᥋⥆ ODT.NET 䜢䜲䞁䝇䝖䞊䝹䛩䜛䛣䛸䛷䚸䝃䞊䝞䞊䜶䜽䝇䝥䝻䞊䝷䞊䛻 Oracle 䝕䞊䝍䝧䞊䝇ୖ䛾䝸䝋䞊 䝇䜢⟶⌮䛩䜛ᶵ⬟䜢㏣ຍ䛩䜛䛣䛸䛜䛷䛝䜎䛩䚹䝃䞊䝞䞊䜶䜽䝇䝥䝻䞊䝷䞊䛷䛿⾲䜔䝡䝳䞊䚸䝟䝑䜿䞊䝆 䛺䛹䛾䜸䝤䝆䜵䜽䝖䜢⟶⌮䛩䜛䛣䛸䛜䛷䛝䜎䛩䚹 䝃䞊䝞䞊䜶䜽䝇䝥䝻䞊䝷䞊䜢⏝䛩䜛䛯䜑䛻䛿䚸ODT.NET 䜢䜲䞁䝇䝖䞊䝹ᚋ䚸ḟ䛾ᡭ㡰䛷タᐃ䜢⾜ 䛔䜎䛩䚹 䐟 䛂䝒䞊䝹䛃䝯䝙䝳䞊䊻䛂䝕䞊䝍䝧䞊䝇䜈䛾᥋⥆䛃䜢䜽䝸䝑䜽䛧䜎䛩䚹 㻌 19 ➨ 2 ❶㻌 䝕䞊䝍䝧䞊䝇䜈䛾᥋⥆ 䐟 䛂᥋⥆䛾㏣ຍ䛃⏬㠃䛜⾲♧䛥䜜䜛䛾䛷䚸᥋⥆䛩䜛䝕䞊䝍䝋䞊䝇ྡ䚸䝴䞊䝄䞊ྡ䚸䝟䝇䝽䞊䝗䛺䛹 䜢ධຊ䛧䜎䛩䚹 㻌 䛣䛣䛷䛿䚸ḟ䛾䜘䛖䛻タᐃ䛧䜎䛩䚹 䝃䞊䝞䞊ྡ䠖ORCL 䝴䞊䝄䞊ྡ䠖COFFEE 䝟䝇䝽䞊䝗䠖SHOP 䝟䝇䝽䞊䝗䛾ಖᏑ䠖䝏䜵䝑䜽 䐠 ௨ୖ䛾タᐃ䛻䜘䜚䚸䛂䝃䞊䝞䞊䜶䜽䝇䝥䝻䞊䝷䞊䛃⏬㠃ୖ䛻᥋⥆ሗ䛜⾲♧䛥䜜䜎䛩䚹 㻌 㻌 20 ➨ 2 ❶㻌 䝕䞊䝍䝧䞊䝇䜈䛾᥋⥆ 䐡 ᥋⥆ሗ䛻䛿䚸Oracle 䝕䞊䝍䝧䞊䝇୰䛾䜸䝤䝆䜵䜽䝖䛺䛹䛻㛵䛩䜛ሗ䛜⾲♧䛥䜜䜎䛩䚹 㻌 䐢 䛣䜜䛻䜘䛳䛶䚸⾲♧䛥䜜䛶䛔䜛䜸䝤䝆䜵䜽䝖䛾⟶⌮䜢䛚䛣䛺䛖䛣䛸䛜䛷䛝䜎䛩䚹 䝬䜴䝇䛂ྑ䝪䝍䞁䛃䜽䝸䝑䜽 㻌 21
© Copyright 2024 ExpyDoc
