{"id":1445,"date":"2021-03-14T18:37:36","date_gmt":"2021-03-14T09:37:36","guid":{"rendered":"https:\/\/extralab.org\/wp\/?p=1445"},"modified":"2021-03-14T18:37:36","modified_gmt":"2021-03-14T09:37:36","slug":"csharp-oracle-xe-db-controlclass-create","status":"publish","type":"post","link":"https:\/\/extralab.org\/wp\/blog\/2021\/03\/14\/csharp-oracle-xe-db-controlclass-create\/","title":{"rendered":"\u3010C#&#038;OracleDB\u63a5\u7d9a\u3011Database\u63a5\u7d9a\u30af\u30e9\u30b9\u4f5c\u6210\u3057\u3066\u7ba1\u7406\u304c\u5bb9\u6613\u3067\u958b\u767a\u52b9\u7387UP"},"content":{"rendered":"<h1>\u3010C#&amp;OracleDB\u63a5\u7d9a\u3011Database\u63a5\u7d9a\u30af\u30e9\u30b9\u4f5c\u6210\u3057\u3066\u7ba1\u7406\u304c\u5bb9\u6613\u3067\u958b\u767a\u52b9\u7387UP<\/h1>\n<h2>oracle<\/h2>\n<p>\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u3067\u6709\u540d\u306a\u306e\u304coracle\u3067\u3059\u306d\u3002<\/p>\n<p>\u4eca\u56de\u306f\u3001<a href=\"https:\/\/www.oracle.com\/jp\/database\/technologies\/xe-prior-releases.html\"><em>Oracle<\/em>\u00a0Database\u00a0<\/a><em>Express Edition 11gr2\u306e\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u3092\u4f7f\u7528\u3057\u307e\u3059\u3002<\/em><\/p>\n<p>\u7121\u511f\u3067\u5546\u7528\u5229\u7528\u53ef\u306a\u306e\u3067\u826f\u3044\u306e\u3067\u3059\u304c\u3001\u5236\u9650\u304c\u3042\u308a\u307e\u3059\u306e\u3067\u3001\u8a73\u7d30\u306f\u30b0\u30b0\u3063\u3066\u4e0b\u3055\u3044\u3002<\/p>\n<p>\u6700\u8fd1\u306fOracleDB18c XE\u7248\u3082\u51fa\u305f\u307f\u305f\u3044\u3067\u3059\u306d\u3002<\/p>\n<p>18c\u304b\u3089DB\u69cb\u9020\u304c\u5909\u308f\u3063\u3066\u308b\u306e\u3067\u3054\u6ce8\u610f\u3092\u3002<\/p>\n<p>GUI\u3067\u7ba1\u7406\u3057\u305f\u3044\u65b9\u306f\u3001\u300c<a href=\"https:\/\/www.oracle.com\/jp\/technical-resources\/\">Oracle SQL Developer<\/a>\u300d\u3092\u30c0\u30a6\u30f3\u30ed\u30fc\u30c9\u3057\u3066\u4e0b\u3055\u3044\u3002<\/p>\n<h2>\u30c6\u30fc\u30d6\u30eb\u4f5c\u6210<\/h2>\n<p>\u4eca\u56de\u306e\u30b5\u30f3\u30d7\u30eb\u3067\u306f\u4e0b\u8a18\u306e\u901a\u308a\u306e\u30c6\u30fc\u30d6\u30eb\u5b9a\u7fa9\u3092\u4f5c\u6210\u3057\u307e\u3057\u305f\u3002<\/p>\n<img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-1449\" src=\"https:\/\/extralab.org\/wp\/wp-content\/uploads\/2021\/03\/oracle_db_table_create.jpg\" alt=\"oracle_db_table_create\" width=\"786\" height=\"593\" srcset=\"https:\/\/extralab.org\/wp\/wp-content\/uploads\/2021\/03\/oracle_db_table_create.jpg 786w, https:\/\/extralab.org\/wp\/wp-content\/uploads\/2021\/03\/oracle_db_table_create-300x226.jpg 300w, https:\/\/extralab.org\/wp\/wp-content\/uploads\/2021\/03\/oracle_db_table_create-768x579.jpg 768w\" sizes=\"auto, (max-width: 786px) 100vw, 786px\" \/>\n<p>\u30c6\u30fc\u30d6\u30eb\u540d\uff1asample<\/p>\n<p>\u30ab\u30e9\u30e03\u3064\u306f\u3001ID,NAME,REMARKS\u3067\u3059\u3002<\/p>\n<p>ID\u306b\u5217\u30b7\u30fc\u30b1\u30f3\u30b9\u8a2d\u5b9a\u3057\u307e\u3059\u3002(\u81ea\u52d5\u30a4\u30f3\u30af\u30ea\u30e1\u30f3\u30c8\u8a2d\u5b9a)<\/p>\n<h2>C#-DataAccess.dll\u8ffd\u52a0<\/h2>\n<p>\u4eca\u56de\u306f\u3001\uff23\uff03\u3067\u306e.NETFramework4.8\u3067windowsform\u958b\u767a\u3092\u884c\u3044\u307e\u3059\u3002<\/p>\n<p>\u30d7\u30ed\u30b8\u30a7\u30af\u30c8\u3092\u4f5c\u6210\u3057\u305f\u3089\u3001\u53c2\u7167\u306e\u8ffd\u52a0\u304b\u3089\u3001Oracle\u304c\u30a4\u30f3\u30b9\u30c8\u30fc\u30eb\u3055\u308c\u3066\u3044\u308b\u30c7\u30a3\u30ec\u30af\u30c8\u30ea\u3092\u63a2\u3059\u3068\u3001Oracle.DataAccess.dll\u304c\u3042\u308b\u306e\u3067\u305d\u308c\u3092\u8ffd\u52a0\u3057\u307e\u3059\u3002<\/p>\n<img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-1450\" src=\"https:\/\/extralab.org\/wp\/wp-content\/uploads\/2021\/03\/oracle_db_dll_add.jpg\" alt=\"oracle_db_dll_add\" width=\"645\" height=\"200\" srcset=\"https:\/\/extralab.org\/wp\/wp-content\/uploads\/2021\/03\/oracle_db_dll_add.jpg 645w, https:\/\/extralab.org\/wp\/wp-content\/uploads\/2021\/03\/oracle_db_dll_add-300x93.jpg 300w\" sizes=\"auto, (max-width: 645px) 100vw, 645px\" \/>\n<h2>C#-\u753b\u9762\u8a2d\u8a08<\/h2>\n<p>\u3067\u306f\u3001\u4eca\u56de\u306e\u30d7\u30ed\u30b0\u30e9\u30e0\u306e\u753b\u9762\u8a2d\u8a08\u306f\u3068\u3044\u3046\u3068\u3001<\/p>\n<img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-1451\" src=\"https:\/\/extralab.org\/wp\/wp-content\/uploads\/2021\/03\/oracle_db_screen_prod.jpg\" alt=\"oracle_db_screen_prod\" width=\"488\" height=\"383\" srcset=\"https:\/\/extralab.org\/wp\/wp-content\/uploads\/2021\/03\/oracle_db_screen_prod.jpg 488w, https:\/\/extralab.org\/wp\/wp-content\/uploads\/2021\/03\/oracle_db_screen_prod-300x235.jpg 300w\" sizes=\"auto, (max-width: 488px) 100vw, 488px\" \/>\n<p>\u30dc\u30bf\u30f3\u30923\u3064\u914d\u7f6e\u3001label\u3092\u914d\u7f6e\u3001DataGridView\u3092\u914d\u7f6e\u3057\u307e\u3057\u305f\u3002<\/p>\n<h2>C#-DB\u5236\u5fa1\u30af\u30e9\u30b9\u4f5c\u6210<\/h2>\n<p>\u3067\u306f\u3001Oracle.DataAccess.dll\u3092\u8ffd\u52a0\u3057\u305f\u3089\u3001<\/p>\n<p>\u30af\u30e9\u30b9\u3092\u4f5c\u6210\u3057\u307e\u3059\u3002<\/p>\n<img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-1452\" src=\"https:\/\/extralab.org\/wp\/wp-content\/uploads\/2021\/03\/sqlite_class_name_add-2.jpg\" alt=\"oracle_class_name_add\" width=\"784\" height=\"446\" srcset=\"https:\/\/extralab.org\/wp\/wp-content\/uploads\/2021\/03\/sqlite_class_name_add-2.jpg 784w, https:\/\/extralab.org\/wp\/wp-content\/uploads\/2021\/03\/sqlite_class_name_add-2-300x171.jpg 300w, https:\/\/extralab.org\/wp\/wp-content\/uploads\/2021\/03\/sqlite_class_name_add-2-768x437.jpg 768w\" sizes=\"auto, (max-width: 784px) 100vw, 784px\" \/>\n<p>\u7a7a\u306e\u30af\u30e9\u30b9\u3067\u540d\u524d\u306f\u4efb\u610f\u3002\u4eca\u56de\u306f\u3001Dbctl.cs\u3092\u4f5c\u6210\u3057\u307e\u3059\u3002<\/p>\n<p>\u30af\u30e9\u30b9\u5185\u5bb9\u306e\u30bd\u30fc\u30b9\u30b3\u30fc\u30c9\u306f\u4e0b\u8a18\u306e\u901a\u308a\u3067\u3059\u3002<\/p>\n<pre class=\"lang:c# decode:true\" title=\"oracle_db_control_class\">using Oracle.DataAccess.Client;\r\n\r\nnamespace OracleSQL\r\n{\r\n    class Dbctl\r\n    {\r\n        private readonly OracleConnection conn;\r\n\r\n        public Dbctl(string dbUser, string dbPass)\r\n        {\r\n            string conn_str = \"User Id=\" + dbUser + \"; \" + \"Password=\" + dbPass + \";\";\r\n\r\n            conn = new OracleConnection(conn_str);\r\n\r\n            conn.Open();\r\n        }\r\n\r\n        \/\/\u63a5\u7d9a\u5b50\u3092\u8a2d\u5b9a\r\n        public void Close()\r\n        {\r\n            conn.Close();\r\n            conn.Dispose();\r\n        }\r\n\r\n        public void ExecuteNonQuery(string sql)\r\n        {\r\n            OracleCommand sqlCom = new OracleCommand(sql, conn);\r\n            sqlCom.ExecuteNonQuery();\r\n        }\r\n\r\n        public OracleDataAdapter ExecuteQueryAdapter(string sql)\r\n        {\r\n            OracleDataAdapter Adapter = new OracleDataAdapter(sql, conn);\r\n            return Adapter;\r\n        }\r\n\r\n        public OracleDataReader ExecuteQueryReader(string sql)\r\n        {\r\n            OracleCommand sqlCom = new OracleCommand(sql, conn);\r\n            OracleDataReader reader = sqlCom.ExecuteReader();\r\n\r\n            return reader;\r\n        }\r\n\r\n    }\r\n}\r\n<\/pre>\n<p>using Oracle.DataAccess.Client;\u3092\u53c2\u7167\u8ffd\u52a0\u3057\u307e\u3059\u3002<\/p>\n<ul>\n<li>OracleConnection\u00a0 \u00a0&#8212;DB\u63a5\u7d9a<\/li>\n<li>OracleCommand\u00a0 \u00a0&#8211;SQL\u6587\u4f5c\u6210<\/li>\n<li>OracleDataAdapter\u00a0 &#8211;\u30c7\u30fc\u30bf\u53d6\u5f97\u683c\u7d0d(\u4e00\u62ec\u53d6\u5f97) -&gt;\u30c7\u30fc\u30bf\u30b0\u30ea\u30c3\u30c9\u30d3\u30e5\u30fc\u306b\u8868\u793a\u3055\u305b\u308b\u306a\u3069\u3002<\/li>\n<li>OracleDataReader\u00a0 &#8211;\u30c7\u30fc\u30bf\u53d6\u5f97<\/li>\n<\/ul>\n<p>\u3053\u308c\u3089\u3092\u4e3b\u306b\u4f7f\u3063\u3066\u3001SQL\u6587\u3092\u5b9f\u884c\u3057\u3066\u3044\u304d\u307e\u3059\u3002<\/p>\n<h2>C#-\u30e1\u30a4\u30f3\u51e6\u7406<\/h2>\n<p>\u4eca\u56de\u306f\u3001\u30c6\u30fc\u30d6\u30eb\u30c7\u30fc\u30bf\u3092\u8868\u793a\u3055\u305b\u308b\u3053\u3068\u3068\u3001\u30c7\u30fc\u30bf\u633f\u5165\u3001\u30c7\u30fc\u30bf\u53d6\u5f97\u3092\u3059\u308b\u30d7\u30ed\u30b0\u30e9\u30e0\u3092\u4f5c\u6210\u3057\u307e\u3057\u305f\u3002<\/p>\n<pre class=\"lang:c# decode:true\" title=\"oracle_DB_mein_class\">using Oracle.DataAccess.Client;\r\nusing System;\r\nusing System.Data;\r\nusing System.Windows.Forms;\r\n\r\nnamespace OracleSQL\r\n{\r\n    public partial class Form1 : Form\r\n    {\r\n        public Form1()\r\n        {\r\n            InitializeComponent();\r\n        }\r\n\r\n        \/\/\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u63a5\u7d9a\u60c5\u5831\r\n        private const string DATABASE_USER = \"testuser\";\r\n        private const string DATABASE_PASSWORD = \"extralab\";\r\n\r\n        \/\/\/ &lt;summary&gt;\r\n        \/\/\/ Form\u8d77\u52d5\u6642\u51e6\u7406\r\n        \/\/\/ &lt;\/summary&gt;\r\n        \/\/\/ &lt;param name=\"sender\"&gt;&lt;\/param&gt;\r\n        \/\/\/ &lt;param name=\"e\"&gt;&lt;\/param&gt;\r\n        private void Form1_Load(object sender, EventArgs e)\r\n        {\r\n            OraTableSelect_class();\r\n        }\r\n\r\n\r\n        public void OraTableSelect_class()\r\n        {\r\n\r\n            \/\/DB\u5236\u5fa1class\r\n            Dbctl dbctl = new Dbctl(DATABASE_USER, DATABASE_PASSWORD);\r\n\r\n            try\r\n            {\r\n                string strSQL = \"SELECT * From SAMPLE\";\r\n\r\n                OracleDataAdapter Adapter = dbctl.ExecuteQueryAdapter(strSQL);\r\n\r\n\r\n                DataSet Ds = new DataSet();      \/\/\u30c7\u30fc\u30bf\u30bb\u30c3\u30c8\u30a4\u30f3\u30b9\u30bf\u30f3\u30b9\u4f5c\u6210\r\n                DataTable dt = new DataTable();  \/\/\u30c7\u30fc\u30bf\u30c6\u30fc\u30d6\u30eb\u30a4\u30f3\u30b9\u30bf\u30f3\u30b9\u4f5c\u6210\r\n                Adapter.Fill(dt);   \/\/\u30c7\u30fc\u30bf\u30c6\u30fc\u30d6\u30eb\u306b\u4ee3\u5165\r\n                Ds.Tables.Add(dt);  \/\/\u30c7\u30fc\u30bf\u30bb\u30c3\u30c8\u306b\u8ffd\u52a0\r\n\r\n                dataGridView1.DataSource = Ds.Tables[0]; \/\/\u30b0\u30ea\u30c3\u30c9\u30d3\u30e5\u30fc\u306b\u30c7\u30fc\u30bf\u8868\u793a\r\n\r\n            }\r\n            catch (Exception exception)\r\n            {\r\n                MessageBox.Show(\"DB_select_table_view:\\n\" + exception.Message, \"Error\");\r\n            }\r\n            finally\r\n            {\r\n                dbctl.Close();\r\n            }\r\n\r\n        }\r\n\r\n        \/\/\/ &lt;summary&gt;\r\n        \/\/\/ Select_View\r\n        \/\/\/ &lt;\/summary&gt;\r\n        \/\/\/ &lt;param name=\"sender\"&gt;&lt;\/param&gt;\r\n        \/\/\/ &lt;param name=\"e\"&gt;&lt;\/param&gt;\r\n        private void button1_Click(object sender, EventArgs e)\r\n        {\r\n            OraTableSelect_class();\r\n        }\r\n\r\n        \/\/\/ &lt;summary&gt;\r\n        \/\/\/ Insert\r\n        \/\/\/ &lt;\/summary&gt;\r\n        \/\/\/ &lt;param name=\"sender\"&gt;&lt;\/param&gt;\r\n        \/\/\/ &lt;param name=\"e\"&gt;&lt;\/param&gt;\r\n        private void button2_Click(object sender, EventArgs e)\r\n        {\r\n            string cmd_str1 = \"INSERT INTO SAMPLE (name, remarks) VALUES('DDD', '04')\";\r\n            string cmd_str2 = \"INSERT INTO SAMPLE (name, remarks) VALUES('EEE', '05')\";\r\n            string cmd_str3 = \"INSERT INTO SAMPLE (name, remarks) VALUES('FFF', '06')\";\r\n            Ora_insert(cmd_str1);\r\n            Ora_insert(cmd_str2);\r\n            Ora_insert(cmd_str3);\r\n        }\r\n\r\n        \/\/\/ &lt;summary&gt;\r\n        \/\/\/ Insert\r\n        \/\/\/ &lt;\/summary&gt;\r\n        \/\/\/ &lt;param name=\"cmd_str\"&gt;&lt;\/param&gt;\r\n        public void Ora_insert(string cmd_str)\r\n        {\r\n            \/\/DB\u5236\u5fa1class\r\n            Dbctl dbctl = new Dbctl(DATABASE_USER, DATABASE_PASSWORD);\r\n\r\n            try\r\n            {\r\n                dbctl.ExecuteNonQuery(cmd_str);\r\n            }\r\n            catch (Exception e)\r\n            {\r\n                MessageBox.Show(e.Message);\r\n            }\r\n            finally\r\n            {\r\n                dbctl.Close();\r\n            }\r\n        }\r\n\r\n        \/\/\/ &lt;summary&gt;\r\n        \/\/\/ Select_count\r\n        \/\/\/ &lt;\/summary&gt;\r\n        \/\/\/ &lt;param name=\"sender\"&gt;&lt;\/param&gt;\r\n        \/\/\/ &lt;param name=\"e\"&gt;&lt;\/param&gt;\r\n        private void button3_Click(object sender, EventArgs e)\r\n        {\r\n            Ora_select();\r\n        }\r\n\r\n        \/\/\/ &lt;summary&gt;\r\n        \/\/\/ Select_count\r\n        \/\/\/ &lt;\/summary&gt;\r\n        public void Ora_select()\r\n        {\r\n            \/\/DB\u5236\u5fa1class\r\n            Dbctl dbctl = new Dbctl(DATABASE_USER, DATABASE_PASSWORD);\r\n\r\n            try\r\n            {\r\n                string cmd_str = \"SELECT Count(*) FROM sample\";\r\n\r\n                OracleDataReader reader = dbctl.ExecuteQueryReader(cmd_str);\r\n\r\n                while (reader.Read())\r\n                {\r\n                    label1.Text = reader[0].ToString();  \/\/\u5168\u4ef6\u6570\u691c\u7d22\u7d50\u679c\u8868\u793a\r\n                }\r\n            }\r\n            catch (Exception e)\r\n            {\r\n                MessageBox.Show(e.Message);\r\n            }\r\n            finally\r\n            {\r\n                dbctl.Close();\r\n            }\r\n        }\r\n    }\r\n}\r\n<\/pre>\n<p>using Oracle.DataAccess.Client;\u3092\u8ffd\u52a0\u3057\u3066\u3044\u307e\u3059\u3002<\/p>\n<h2>\u7d50\u679c<\/h2>\n<p>\u30d7\u30ed\u30b0\u30e9\u30e0\u3092\u5b9f\u884c\u3059\u308b\u524d\u306b\u3001\u30d3\u30eb\u30c9\u8a2d\u5b9a\u3067\u5bfe\u8c61\u30d7\u30e9\u30c3\u30c8\u30d5\u30a9\u30fc\u30e0\u3092x64\u306b\u8a2d\u5b9a\u3057\u3066\u304a\u3044\u3066\u4e0b\u3055\u3044\u3002<\/p>\n<img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-1456\" src=\"https:\/\/extralab.org\/wp\/wp-content\/uploads\/2021\/03\/oracle_x64_select.jpg\" alt=\"oracle_x64_select\" width=\"525\" height=\"392\" srcset=\"https:\/\/extralab.org\/wp\/wp-content\/uploads\/2021\/03\/oracle_x64_select.jpg 525w, https:\/\/extralab.org\/wp\/wp-content\/uploads\/2021\/03\/oracle_x64_select-300x224.jpg 300w\" sizes=\"auto, (max-width: 525px) 100vw, 525px\" \/>\n<p>\u30d7\u30ed\u30b0\u30e9\u30e0\u3092\u5b9f\u884c\u3059\u308b\u3068\u3001\u30c6\u30fc\u30d6\u30eb\u5185\u5bb9\u304cDatagridView\u306b\u8868\u793a\u3055\u308c\u307e\u3059\u3002\u6700\u521d\u306b3\u3064\u30c7\u30fc\u30bf\u3092\u5165\u308c\u3066\u304a\u304d\u307e\u3057\u305f\u3002<\/p>\n<p>Select_count\u30dc\u30bf\u30f3\u3092\u62bc\u4e0b\u3059\u308b\u3068\u3001\u300c3\u300d\u3068\u30ec\u30b3\u30fc\u30c9\u4ef6\u6570\u304c\u8868\u793a\u3055\u308c\u307e\u3059\u3002<\/p>\n<img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-1454\" src=\"https:\/\/extralab.org\/wp\/wp-content\/uploads\/2021\/03\/oracle_db_before_screen.jpg\" alt=\"oracle_db_before_screen\" width=\"476\" height=\"380\" srcset=\"https:\/\/extralab.org\/wp\/wp-content\/uploads\/2021\/03\/oracle_db_before_screen.jpg 476w, https:\/\/extralab.org\/wp\/wp-content\/uploads\/2021\/03\/oracle_db_before_screen-300x239.jpg 300w\" sizes=\"auto, (max-width: 476px) 100vw, 476px\" \/>\n<p>\u6b21\u306b\u3001Insert\u30dc\u30bf\u30f3\u62bc\u4e0b\u21d2Select_View\u30dc\u30bf\u30f3\u62bc\u4e0b\u21d2Select_count\u30dc\u30bf\u30f3\u62bc\u4e0b\u3092\u884c\u3063\u305f\u7d50\u679c\u304c\u4e0b\u8a18\u306e\u901a\u308a\u3067\u3059\u3002<\/p>\n<img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-1455\" src=\"https:\/\/extralab.org\/wp\/wp-content\/uploads\/2021\/03\/oracle_db_after_screen.jpg\" alt=\"oracle_db_after_screen\" width=\"476\" height=\"380\" srcset=\"https:\/\/extralab.org\/wp\/wp-content\/uploads\/2021\/03\/oracle_db_after_screen.jpg 476w, https:\/\/extralab.org\/wp\/wp-content\/uploads\/2021\/03\/oracle_db_after_screen-300x239.jpg 300w\" sizes=\"auto, (max-width: 476px) 100vw, 476px\" \/>\n<p>\u30d7\u30ed\u30b0\u30e9\u30e0\u901a\u308a\u306b3\u3064\u306e\u30ec\u30b3\u30fc\u30c9\u304c\u633f\u5165\u3055\u308c\u305f\u7d50\u679c\u304c\u8868\u793a\u3055\u308c\u307e\u3057\u305f\u3002<\/p>\n<p>\u30c6\u30fc\u30d6\u30eb\u5b9a\u7fa9\u8a2d\u5b9a\u3067ID\u30ab\u30e9\u30e0\u5217\u306f\u3001\u30b7\u30fc\u30b1\u30f3\u30b9\u8a2d\u5b9a\u3057\u3066\u3042\u308a\u307e\u3057\u305f\u306e\u3067\u3001\u81ea\u52d5\u30a4\u30f3\u30af\u30ea\u30e1\u30f3\u30c8\u3055\u308c\u3066\u3044\u307e\u3059\u3002<\/p>\n<h2>\u305d\u306e\u4ed6<\/h2>\n<p>\u4ed6\u306e\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u3067\u3082\u540c\u69d8\u306a\u611f\u3058\u3067DB\u5236\u5fa1\u30af\u30e9\u30b9\u3092\u4f5c\u6210\u3057\u3066\u3042\u3052\u308c\u3070\u3001\u7ba1\u7406\u304c\u5bb9\u6613\u306b\u306a\u308a\u3001\u958b\u767a\u52b9\u7387\u3082\u4e0a\u304c\u308a\u3001\u30b3\u30fc\u30c9\u3082\u898b\u3084\u3059\u304f\u3001\u8aad\u307f\u3084\u3059\u304f\u306a\u308a\u307e\u3059\u3002<\/p>\n<h3>SQLite<\/h3>\n<blockquote class=\"wp-embedded-content\" data-secret=\"KUgIXo6Suq\"><p><a href=\"https:\/\/extralab.org\/wp\/csharp-sqlite-db-class-create\/\">\u3010C#\u304b\u3089SQLite\u63a5\u7d9a\u3011Database\u63a5\u7d9a\u306e\u30af\u30e9\u30b9\u3092\u4f5c\u6210\u3057\u305f\u306e\u3067\u7ba1\u7406\u304c\u5bb9\u6613\u306b\u306a\u3063\u305f<\/a><\/p><\/blockquote>\n<p><iframe loading=\"lazy\" class=\"wp-embedded-content\" sandbox=\"allow-scripts\" security=\"restricted\" style=\"position: absolute; clip: rect(1px, 1px, 1px, 1px);\" title=\"&#8220;\u3010C#\u304b\u3089SQLite\u63a5\u7d9a\u3011Database\u63a5\u7d9a\u306e\u30af\u30e9\u30b9\u3092\u4f5c\u6210\u3057\u305f\u306e\u3067\u7ba1\u7406\u304c\u5bb9\u6613\u306b\u306a\u3063\u305f&#8221; &#8212; Extra-Lab\" src=\"https:\/\/extralab.org\/wp\/csharp-sqlite-db-class-create\/embed\/#?secret=KUgIXo6Suq\" data-secret=\"KUgIXo6Suq\" width=\"600\" height=\"338\" frameborder=\"0\" marginwidth=\"0\" marginheight=\"0\" scrolling=\"no\"><\/iframe><\/p>\n<h3>PostgreSQL<\/h3>\n<blockquote class=\"wp-embedded-content\" data-secret=\"FA7ktJoXyV\"><p><a href=\"https:\/\/extralab.org\/wp\/csharp-postgresql-db-class-create\/\">\u3010C#&#038;PostgreSQL\u63a5\u7d9a\u3011Database-control\u30af\u30e9\u30b9\u4f5c\u6210\u3067\u7ba1\u7406\u5bb9\u6613<\/a><\/p><\/blockquote>\n<p><iframe loading=\"lazy\" class=\"wp-embedded-content\" sandbox=\"allow-scripts\" security=\"restricted\" style=\"position: absolute; clip: rect(1px, 1px, 1px, 1px);\" title=\"&#8220;\u3010C#&#038;PostgreSQL\u63a5\u7d9a\u3011Database-control\u30af\u30e9\u30b9\u4f5c\u6210\u3067\u7ba1\u7406\u5bb9\u6613&#8221; &#8212; Extra-Lab\" src=\"https:\/\/extralab.org\/wp\/csharp-postgresql-db-class-create\/embed\/#?secret=FA7ktJoXyV\" data-secret=\"FA7ktJoXyV\" width=\"600\" height=\"338\" frameborder=\"0\" marginwidth=\"0\" marginheight=\"0\" scrolling=\"no\"><\/iframe><\/p>\n<p>&nbsp;<\/p>\n<p>&nbsp;<\/p>\n","protected":false},"excerpt":{"rendered":"<p>\u3010C#&amp;OracleDB\u63a5\u7d9a\u3011Database\u63a5\u7d9a\u30af\u30e9\u30b9\u4f5c\u6210\u3057\u3066\u7ba1\u7406\u304c\u5bb9\u6613\u3067\u958b\u767a\u52b9\u7387UP oracle \u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u3067\u6709\u540d\u306a\u306e\u304coracle\u3067\u3059\u306d\u3002 \u4eca\u56de\u306f\u3001Oracle\u00a0Database\u00a0Express Edi&#8230;<\/p>\n","protected":false},"author":1,"featured_media":1446,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"om_disable_all_campaigns":false,"_monsterinsights_skip_tracking":false,"_monsterinsights_sitenote_active":false,"_monsterinsights_sitenote_note":"","_monsterinsights_sitenote_category":0,"_uf_show_specific_survey":0,"_uf_disable_surveys":false,"footnotes":""},"categories":[54,55,44],"tags":[293,61,226,284,285,286,206,292,289,235,64],"class_list":{"0":"post-1445","1":"post","2":"type-post","3":"status-publish","4":"format-standard","5":"has-post-thumbnail","7":"category-csharp","8":"category-windowsform","9":"category-programing","10":"tag-netframework","11":"tag-csharp","12":"tag-database","13":"tag-datagrid","14":"tag-dataguridview","15":"tag-dataview","16":"tag-oracle","17":"tag-oracledb","18":"tag-postgresql","19":"tag-sqlite","20":"tag-windowsform","21":"article cf"},"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.2 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>\u3010C#&amp;OracleDB\u63a5\u7d9a\u3011Database\u63a5\u7d9a\u30af\u30e9\u30b9\u4f5c\u6210\u3057\u3066\u7ba1\u7406\u304c\u5bb9\u6613\u3067\u958b\u767a\u52b9\u7387UP - Extra-Lab<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/extralab.org\/wp\/blog\/2021\/03\/14\/csharp-oracle-xe-db-controlclass-create\/\" \/>\n<meta property=\"og:locale\" content=\"ja_JP\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"\u3010C#&amp;OracleDB\u63a5\u7d9a\u3011Database\u63a5\u7d9a\u30af\u30e9\u30b9\u4f5c\u6210\u3057\u3066\u7ba1\u7406\u304c\u5bb9\u6613\u3067\u958b\u767a\u52b9\u7387UP - Extra-Lab\" \/>\n<meta property=\"og:description\" content=\"\u3010C#&amp;OracleDB\u63a5\u7d9a\u3011Database\u63a5\u7d9a\u30af\u30e9\u30b9\u4f5c\u6210\u3057\u3066\u7ba1\u7406\u304c\u5bb9\u6613\u3067\u958b\u767a\u52b9\u7387UP oracle \u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u3067\u6709\u540d\u306a\u306e\u304coracle\u3067\u3059\u306d\u3002 \u4eca\u56de\u306f\u3001Oracle\u00a0Database\u00a0Express Edi...\" \/>\n<meta property=\"og:url\" content=\"https:\/\/extralab.org\/wp\/blog\/2021\/03\/14\/csharp-oracle-xe-db-controlclass-create\/\" \/>\n<meta property=\"og:site_name\" content=\"Extra-Lab\" \/>\n<meta property=\"article:published_time\" content=\"2021-03-14T09:37:36+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/extralab.org\/wp\/wp-content\/uploads\/2021\/03\/csharp_oracle_samuneiru.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"1143\" \/>\n\t<meta property=\"og:image:height\" content=\"659\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\n<meta name=\"author\" content=\"extralab_sf\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@https:\/\/twitter.com\/s_fuku_s\" \/>\n<meta name=\"twitter:site\" content=\"@s_fuku_s\" \/>\n<meta name=\"twitter:label1\" content=\"\u57f7\u7b46\u8005\" \/>\n\t<meta name=\"twitter:data1\" content=\"extralab_sf\" \/>\n\t<meta name=\"twitter:label2\" content=\"\u63a8\u5b9a\u8aad\u307f\u53d6\u308a\u6642\u9593\" \/>\n\t<meta name=\"twitter:data2\" content=\"3\u5206\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/extralab.org\/wp\/blog\/2021\/03\/14\/csharp-oracle-xe-db-controlclass-create\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/extralab.org\/wp\/blog\/2021\/03\/14\/csharp-oracle-xe-db-controlclass-create\/\"},\"author\":{\"name\":\"extralab_sf\",\"@id\":\"https:\/\/extralab.org\/wp\/#\/schema\/person\/08765162da76c96842cc20d837e31426\"},\"headline\":\"\u3010C#&#038;OracleDB\u63a5\u7d9a\u3011Database\u63a5\u7d9a\u30af\u30e9\u30b9\u4f5c\u6210\u3057\u3066\u7ba1\u7406\u304c\u5bb9\u6613\u3067\u958b\u767a\u52b9\u7387UP\",\"datePublished\":\"2021-03-14T09:37:36+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/extralab.org\/wp\/blog\/2021\/03\/14\/csharp-oracle-xe-db-controlclass-create\/\"},\"wordCount\":96,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/extralab.org\/wp\/#\/schema\/person\/08765162da76c96842cc20d837e31426\"},\"image\":{\"@id\":\"https:\/\/extralab.org\/wp\/blog\/2021\/03\/14\/csharp-oracle-xe-db-controlclass-create\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/extralab.org\/wp\/wp-content\/uploads\/2021\/03\/csharp_oracle_samuneiru.jpg\",\"keywords\":[\".netframework\",\"C#\",\"database\",\"datagrid\",\"dataguridview\",\"dataview\",\"oracle\",\"oracledb\",\"postgresql\",\"SQLite\",\"WindowsForm\"],\"articleSection\":[\"C#.NET\",\"WindowsForm\",\"\u30d7\u30ed\u30b0\u30e9\u30df\u30f3\u30b0\"],\"inLanguage\":\"ja\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/extralab.org\/wp\/blog\/2021\/03\/14\/csharp-oracle-xe-db-controlclass-create\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/extralab.org\/wp\/blog\/2021\/03\/14\/csharp-oracle-xe-db-controlclass-create\/\",\"url\":\"https:\/\/extralab.org\/wp\/blog\/2021\/03\/14\/csharp-oracle-xe-db-controlclass-create\/\",\"name\":\"\u3010C#&OracleDB\u63a5\u7d9a\u3011Database\u63a5\u7d9a\u30af\u30e9\u30b9\u4f5c\u6210\u3057\u3066\u7ba1\u7406\u304c\u5bb9\u6613\u3067\u958b\u767a\u52b9\u7387UP - Extra-Lab\",\"isPartOf\":{\"@id\":\"https:\/\/extralab.org\/wp\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/extralab.org\/wp\/blog\/2021\/03\/14\/csharp-oracle-xe-db-controlclass-create\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/extralab.org\/wp\/blog\/2021\/03\/14\/csharp-oracle-xe-db-controlclass-create\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/extralab.org\/wp\/wp-content\/uploads\/2021\/03\/csharp_oracle_samuneiru.jpg\",\"datePublished\":\"2021-03-14T09:37:36+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/extralab.org\/wp\/blog\/2021\/03\/14\/csharp-oracle-xe-db-controlclass-create\/#breadcrumb\"},\"inLanguage\":\"ja\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/extralab.org\/wp\/blog\/2021\/03\/14\/csharp-oracle-xe-db-controlclass-create\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"ja\",\"@id\":\"https:\/\/extralab.org\/wp\/blog\/2021\/03\/14\/csharp-oracle-xe-db-controlclass-create\/#primaryimage\",\"url\":\"https:\/\/extralab.org\/wp\/wp-content\/uploads\/2021\/03\/csharp_oracle_samuneiru.jpg\",\"contentUrl\":\"https:\/\/extralab.org\/wp\/wp-content\/uploads\/2021\/03\/csharp_oracle_samuneiru.jpg\",\"width\":1143,\"height\":659},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/extralab.org\/wp\/blog\/2021\/03\/14\/csharp-oracle-xe-db-controlclass-create\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"\u30db\u30fc\u30e0\",\"item\":\"https:\/\/extralab.org\/wp\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"\u3010C#&#038;OracleDB\u63a5\u7d9a\u3011Database\u63a5\u7d9a\u30af\u30e9\u30b9\u4f5c\u6210\u3057\u3066\u7ba1\u7406\u304c\u5bb9\u6613\u3067\u958b\u767a\u52b9\u7387UP\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/extralab.org\/wp\/#website\",\"url\":\"https:\/\/extralab.org\/wp\/\",\"name\":\"Extra-Lab\",\"description\":\"\u6620\u753b\u9451\u8cde\u3001\u81ea\u4f5cPC\u3001\u81ea\u5df1\u5553\u767a\u3001\u30d7\u30ed\u30b0\u30e9\u30df\u30f3\u30b0\u30b9\u30ad\u30eb(java,javaFX,C#.NET,SQL,OracleDB,H2DataBase)\u3001\u6295\u8cc7(\u682a\u5f0f\u6295\u8cc7)\u3001\u30a2\u30a4\u30c9\u30eb\u8ffd\u3063\u304b\u3051\u3001\u4ff3\u512a\u632b\u6298\u3001\u597d\u5947\u5fc3\u65fa\u76db\u306a\u30a8\u30f3\u30bf\u30fc\u30c6\u30a4\u30ca\u30fc\",\"publisher\":{\"@id\":\"https:\/\/extralab.org\/wp\/#\/schema\/person\/08765162da76c96842cc20d837e31426\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/extralab.org\/wp\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"ja\"},{\"@type\":[\"Person\",\"Organization\"],\"@id\":\"https:\/\/extralab.org\/wp\/#\/schema\/person\/08765162da76c96842cc20d837e31426\",\"name\":\"extralab_sf\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"ja\",\"@id\":\"https:\/\/secure.gravatar.com\/avatar\/5e81ff919e25d0bc6f9d6038f4004fdd3cf90f7964dc22474e797e5f18da01b6?s=96&d=mm&r=g\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/5e81ff919e25d0bc6f9d6038f4004fdd3cf90f7964dc22474e797e5f18da01b6?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/5e81ff919e25d0bc6f9d6038f4004fdd3cf90f7964dc22474e797e5f18da01b6?s=96&d=mm&r=g\",\"caption\":\"extralab_sf\"},\"logo\":{\"@id\":\"https:\/\/secure.gravatar.com\/avatar\/5e81ff919e25d0bc6f9d6038f4004fdd3cf90f7964dc22474e797e5f18da01b6?s=96&d=mm&r=g\"},\"description\":\"\u7530\u820e\u80b2\u3061\u3001\u6771\u4eac\u306b\u61a7\u308c\u3001\u72ec\u7acb\u5fc3\u3001\u6311\u6226\u3092\u5fc3\u639b\u3051\u308b\u3002 \u597d\u5947\u5fc3\u65fa\u76db\u3067\u597d\u304d\u306a\u4e8b\u3092\u3057\u3066\u751f\u304d\u3066\u3044\u304f\u3002 \u4eba\u751f\u306f\u4e00\u5ea6\u304d\u308a\u3002\u672a\u6765\u306f\u81ea\u5206\u3067\u9078\u629e\u3067\u304d\u308b\u3002\",\"sameAs\":[\"https:\/\/extralab.org\/wp\/\",\"https:\/\/www.instagram.com\/satoshi_extralab\/?hl=ja\",\"https:\/\/x.com\/https:\/\/twitter.com\/s_fuku_s\",\"https:\/\/www.youtube.com\/channel\/UCBLYKKfY3A0XHFGuE0YGJdA\"],\"url\":\"https:\/\/extralab.org\/wp\/blog\/author\/extralab_sf\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"\u3010C#&OracleDB\u63a5\u7d9a\u3011Database\u63a5\u7d9a\u30af\u30e9\u30b9\u4f5c\u6210\u3057\u3066\u7ba1\u7406\u304c\u5bb9\u6613\u3067\u958b\u767a\u52b9\u7387UP - Extra-Lab","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/extralab.org\/wp\/blog\/2021\/03\/14\/csharp-oracle-xe-db-controlclass-create\/","og_locale":"ja_JP","og_type":"article","og_title":"\u3010C#&OracleDB\u63a5\u7d9a\u3011Database\u63a5\u7d9a\u30af\u30e9\u30b9\u4f5c\u6210\u3057\u3066\u7ba1\u7406\u304c\u5bb9\u6613\u3067\u958b\u767a\u52b9\u7387UP - Extra-Lab","og_description":"\u3010C#&amp;OracleDB\u63a5\u7d9a\u3011Database\u63a5\u7d9a\u30af\u30e9\u30b9\u4f5c\u6210\u3057\u3066\u7ba1\u7406\u304c\u5bb9\u6613\u3067\u958b\u767a\u52b9\u7387UP oracle \u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u3067\u6709\u540d\u306a\u306e\u304coracle\u3067\u3059\u306d\u3002 \u4eca\u56de\u306f\u3001Oracle\u00a0Database\u00a0Express Edi...","og_url":"https:\/\/extralab.org\/wp\/blog\/2021\/03\/14\/csharp-oracle-xe-db-controlclass-create\/","og_site_name":"Extra-Lab","article_published_time":"2021-03-14T09:37:36+00:00","og_image":[{"width":1143,"height":659,"url":"https:\/\/extralab.org\/wp\/wp-content\/uploads\/2021\/03\/csharp_oracle_samuneiru.jpg","type":"image\/jpeg"}],"author":"extralab_sf","twitter_card":"summary_large_image","twitter_creator":"@https:\/\/twitter.com\/s_fuku_s","twitter_site":"@s_fuku_s","twitter_misc":{"\u57f7\u7b46\u8005":"extralab_sf","\u63a8\u5b9a\u8aad\u307f\u53d6\u308a\u6642\u9593":"3\u5206"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/extralab.org\/wp\/blog\/2021\/03\/14\/csharp-oracle-xe-db-controlclass-create\/#article","isPartOf":{"@id":"https:\/\/extralab.org\/wp\/blog\/2021\/03\/14\/csharp-oracle-xe-db-controlclass-create\/"},"author":{"name":"extralab_sf","@id":"https:\/\/extralab.org\/wp\/#\/schema\/person\/08765162da76c96842cc20d837e31426"},"headline":"\u3010C#&#038;OracleDB\u63a5\u7d9a\u3011Database\u63a5\u7d9a\u30af\u30e9\u30b9\u4f5c\u6210\u3057\u3066\u7ba1\u7406\u304c\u5bb9\u6613\u3067\u958b\u767a\u52b9\u7387UP","datePublished":"2021-03-14T09:37:36+00:00","mainEntityOfPage":{"@id":"https:\/\/extralab.org\/wp\/blog\/2021\/03\/14\/csharp-oracle-xe-db-controlclass-create\/"},"wordCount":96,"commentCount":0,"publisher":{"@id":"https:\/\/extralab.org\/wp\/#\/schema\/person\/08765162da76c96842cc20d837e31426"},"image":{"@id":"https:\/\/extralab.org\/wp\/blog\/2021\/03\/14\/csharp-oracle-xe-db-controlclass-create\/#primaryimage"},"thumbnailUrl":"https:\/\/extralab.org\/wp\/wp-content\/uploads\/2021\/03\/csharp_oracle_samuneiru.jpg","keywords":[".netframework","C#","database","datagrid","dataguridview","dataview","oracle","oracledb","postgresql","SQLite","WindowsForm"],"articleSection":["C#.NET","WindowsForm","\u30d7\u30ed\u30b0\u30e9\u30df\u30f3\u30b0"],"inLanguage":"ja","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/extralab.org\/wp\/blog\/2021\/03\/14\/csharp-oracle-xe-db-controlclass-create\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/extralab.org\/wp\/blog\/2021\/03\/14\/csharp-oracle-xe-db-controlclass-create\/","url":"https:\/\/extralab.org\/wp\/blog\/2021\/03\/14\/csharp-oracle-xe-db-controlclass-create\/","name":"\u3010C#&OracleDB\u63a5\u7d9a\u3011Database\u63a5\u7d9a\u30af\u30e9\u30b9\u4f5c\u6210\u3057\u3066\u7ba1\u7406\u304c\u5bb9\u6613\u3067\u958b\u767a\u52b9\u7387UP - Extra-Lab","isPartOf":{"@id":"https:\/\/extralab.org\/wp\/#website"},"primaryImageOfPage":{"@id":"https:\/\/extralab.org\/wp\/blog\/2021\/03\/14\/csharp-oracle-xe-db-controlclass-create\/#primaryimage"},"image":{"@id":"https:\/\/extralab.org\/wp\/blog\/2021\/03\/14\/csharp-oracle-xe-db-controlclass-create\/#primaryimage"},"thumbnailUrl":"https:\/\/extralab.org\/wp\/wp-content\/uploads\/2021\/03\/csharp_oracle_samuneiru.jpg","datePublished":"2021-03-14T09:37:36+00:00","breadcrumb":{"@id":"https:\/\/extralab.org\/wp\/blog\/2021\/03\/14\/csharp-oracle-xe-db-controlclass-create\/#breadcrumb"},"inLanguage":"ja","potentialAction":[{"@type":"ReadAction","target":["https:\/\/extralab.org\/wp\/blog\/2021\/03\/14\/csharp-oracle-xe-db-controlclass-create\/"]}]},{"@type":"ImageObject","inLanguage":"ja","@id":"https:\/\/extralab.org\/wp\/blog\/2021\/03\/14\/csharp-oracle-xe-db-controlclass-create\/#primaryimage","url":"https:\/\/extralab.org\/wp\/wp-content\/uploads\/2021\/03\/csharp_oracle_samuneiru.jpg","contentUrl":"https:\/\/extralab.org\/wp\/wp-content\/uploads\/2021\/03\/csharp_oracle_samuneiru.jpg","width":1143,"height":659},{"@type":"BreadcrumbList","@id":"https:\/\/extralab.org\/wp\/blog\/2021\/03\/14\/csharp-oracle-xe-db-controlclass-create\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"\u30db\u30fc\u30e0","item":"https:\/\/extralab.org\/wp\/"},{"@type":"ListItem","position":2,"name":"\u3010C#&#038;OracleDB\u63a5\u7d9a\u3011Database\u63a5\u7d9a\u30af\u30e9\u30b9\u4f5c\u6210\u3057\u3066\u7ba1\u7406\u304c\u5bb9\u6613\u3067\u958b\u767a\u52b9\u7387UP"}]},{"@type":"WebSite","@id":"https:\/\/extralab.org\/wp\/#website","url":"https:\/\/extralab.org\/wp\/","name":"Extra-Lab","description":"\u6620\u753b\u9451\u8cde\u3001\u81ea\u4f5cPC\u3001\u81ea\u5df1\u5553\u767a\u3001\u30d7\u30ed\u30b0\u30e9\u30df\u30f3\u30b0\u30b9\u30ad\u30eb(java,javaFX,C#.NET,SQL,OracleDB,H2DataBase)\u3001\u6295\u8cc7(\u682a\u5f0f\u6295\u8cc7)\u3001\u30a2\u30a4\u30c9\u30eb\u8ffd\u3063\u304b\u3051\u3001\u4ff3\u512a\u632b\u6298\u3001\u597d\u5947\u5fc3\u65fa\u76db\u306a\u30a8\u30f3\u30bf\u30fc\u30c6\u30a4\u30ca\u30fc","publisher":{"@id":"https:\/\/extralab.org\/wp\/#\/schema\/person\/08765162da76c96842cc20d837e31426"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/extralab.org\/wp\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"ja"},{"@type":["Person","Organization"],"@id":"https:\/\/extralab.org\/wp\/#\/schema\/person\/08765162da76c96842cc20d837e31426","name":"extralab_sf","image":{"@type":"ImageObject","inLanguage":"ja","@id":"https:\/\/secure.gravatar.com\/avatar\/5e81ff919e25d0bc6f9d6038f4004fdd3cf90f7964dc22474e797e5f18da01b6?s=96&d=mm&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/5e81ff919e25d0bc6f9d6038f4004fdd3cf90f7964dc22474e797e5f18da01b6?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/5e81ff919e25d0bc6f9d6038f4004fdd3cf90f7964dc22474e797e5f18da01b6?s=96&d=mm&r=g","caption":"extralab_sf"},"logo":{"@id":"https:\/\/secure.gravatar.com\/avatar\/5e81ff919e25d0bc6f9d6038f4004fdd3cf90f7964dc22474e797e5f18da01b6?s=96&d=mm&r=g"},"description":"\u7530\u820e\u80b2\u3061\u3001\u6771\u4eac\u306b\u61a7\u308c\u3001\u72ec\u7acb\u5fc3\u3001\u6311\u6226\u3092\u5fc3\u639b\u3051\u308b\u3002 \u597d\u5947\u5fc3\u65fa\u76db\u3067\u597d\u304d\u306a\u4e8b\u3092\u3057\u3066\u751f\u304d\u3066\u3044\u304f\u3002 \u4eba\u751f\u306f\u4e00\u5ea6\u304d\u308a\u3002\u672a\u6765\u306f\u81ea\u5206\u3067\u9078\u629e\u3067\u304d\u308b\u3002","sameAs":["https:\/\/extralab.org\/wp\/","https:\/\/www.instagram.com\/satoshi_extralab\/?hl=ja","https:\/\/x.com\/https:\/\/twitter.com\/s_fuku_s","https:\/\/www.youtube.com\/channel\/UCBLYKKfY3A0XHFGuE0YGJdA"],"url":"https:\/\/extralab.org\/wp\/blog\/author\/extralab_sf\/"}]}},"_links":{"self":[{"href":"https:\/\/extralab.org\/wp\/wp-json\/wp\/v2\/posts\/1445","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/extralab.org\/wp\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/extralab.org\/wp\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/extralab.org\/wp\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/extralab.org\/wp\/wp-json\/wp\/v2\/comments?post=1445"}],"version-history":[{"count":4,"href":"https:\/\/extralab.org\/wp\/wp-json\/wp\/v2\/posts\/1445\/revisions"}],"predecessor-version":[{"id":1457,"href":"https:\/\/extralab.org\/wp\/wp-json\/wp\/v2\/posts\/1445\/revisions\/1457"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/extralab.org\/wp\/wp-json\/wp\/v2\/media\/1446"}],"wp:attachment":[{"href":"https:\/\/extralab.org\/wp\/wp-json\/wp\/v2\/media?parent=1445"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/extralab.org\/wp\/wp-json\/wp\/v2\/categories?post=1445"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/extralab.org\/wp\/wp-json\/wp\/v2\/tags?post=1445"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}