\uff11\uff0e\u30af\u30a8\u30ea\u30fc\u5f0f<\/p>\n
using (var db = new Model1())\r\n{\r\n var query = from kokyaku in db.m_kokyaku\r\n where kokyaku.id >= 10 && kokyaku.id <= 20\r\n orderby kokyaku.id descending\r\n select kokyaku;\r\n\r\n foreach (var k in query)\r\n {\r\n Console.WriteLine(\"id={0}, name={1}, tel1={2}\", k.id, k.name, k.tel1);\r\n }\r\n}\r\n<\/pre>\n <\/p>\n
\uff12\uff0e\u30e9\u30e0\u30c0\u5f0f\u3000\u30d1\u30bf\u30fc\u30f3\uff11<\/p>\n
using (var db = new Model1())\r\n{\r\n var query = db.m_kokyaku\r\n .Where(x => x.id >= 10 && x.id <= 20)\r\n .OrderByDescending(x => x.id)\r\n .ToList();\r\n\r\n foreach (var k in query)\r\n {\r\n Console.WriteLine(\"id={0}, name={1}, tel1={2}\", k.id, k.name, k.tel1);\r\n }\r\n}\r\n<\/pre>\n <\/p>\n
\uff13\uff0e\u30e9\u30e0\u30c0\u5f0f\u3000\u30d1\u30bf\u30fc\u30f3\uff12<\/p>\n
using (var db = new Model1())\r\n{\r\n var query = db.m_kokyaku\r\n .Where(x => x.id >= 10 && x.id <= 20)\r\n .OrderByDescending(x => x.id)\r\n .Select(x => new\r\n {\r\n x.id,\r\n x.name,\r\n x.tel1\r\n });\r\n\r\n foreach (var k in query)\r\n {\r\n Console.WriteLine(\"id={0}, name={1}, tel1={2}\", k.id, k.name, k.tel1);\r\n }\r\n}\r\n<\/pre>\n <\/p>\n
\uff14\uff0e\u30c6\u30fc\u30d6\u30eb\u9023\u7d50<\/p>\n
using (var db = new Model1())\r\n{\r\n var query = from t in db.taiou_rireki\r\n join k in db.m_kokyaku on t.id equals k.id\r\n where k.sex == \"1\"\r\n select new\r\n {\r\n t.id,\r\n t.taiou_bi,\r\n t.kenmei,\r\n k.name,\r\n k.corp_name\r\n };\r\n\r\n foreach (var k in query)\r\n {\r\n Console.WriteLine(\"id={0}, taiou_bi={1}, kenmei={2}, name={3}, corp_name={4}\"\r\n , k.id, k.taiou_bi, k.kenmei, k.name, k.corp_name);\r\n }\r\n<\/pre>\n <\/p>\n
\uff15\uff0eINSERT\u3000\u5358\u4e00\u884c<\/p>\n
using (var db = new Model1())\r\n{\r\n var sts = new m_status\r\n {\r\n id = 5, status = \"\u6253\u5408\u305b\"\r\n };\r\n\r\n db.m_status.Add(sts);\r\n db.SaveChanges();\r\n}\r\n<\/pre>\n <\/p>\n
\uff16\uff0eINSERT\u3000\u8907\u6570\u884c<\/p>\n
using (var db = new Model1())\r\n{\r\n m_status[] sts = new m_status[]\r\n {\r\n new m_status {id = 6, status = \"\u4f1a\u8b70\" },\r\n new m_status {id = 7, status = \"\u51fa\u5f35\" },\r\n };\r\n\r\n db.m_status.AddRange(sts);\r\n db.SaveChanges();\r\n}\r\n<\/pre>\n <\/p>\n
\uff17\uff0eDELETE\u3000\u5358\u4e00\u884c<\/p>\n
using (var db = new Model1())\r\n{\r\n var sts = (from s in db.m_status\r\n where s.id == 4\r\n select s).Single();\r\n\r\n db.m_status.Remove(sts);\r\n db.SaveChanges();\r\n}\r\n<\/pre>\n <\/p>\n
\uff18\uff0eDELETE\u3000\u8907\u6570\u884c<\/p>\n
using (var db = new Model1())\r\n{\r\n var sts = from s in db.m_status\r\n where s.id >= 5 && s.id <= 7\r\n select s;\r\n\r\n db.m_status.RemoveRange(sts);\r\n db.SaveChanges();\r\n}\r\n<\/pre>\n <\/p>\n
\uff19\uff0eUPDATE\u3000\u5358\u4e00\u884c\uff11<\/p>\n
using (var db = new Model1())\r\n{\r\n var sts = db.m_status.Single(x => x.id == 3);\r\n\r\n sts.status = \"\u4fdd\u7559\";\r\n\r\n db.SaveChanges();\r\n}\r\n<\/pre>\n <\/p>\n
\uff11\uff10\uff0eUPDATE\u3000\u5358\u4e00\u884c\uff12<\/p>\n
using (var db = new Model1())\r\n{\r\n var sts = (from s in db.m_status\r\n where s.id == 3\r\n select s).FirstOrDefault();\r\n\r\n sts.status = \"\u4fdd\u7559\";\r\n\r\n db.SaveChanges();\r\n}\r\n<\/pre>\n <\/p>\n
\uff11\uff11\uff0eUPDATE\u3000\u5358\u4e00\u884c\uff13<\/p>\n
using (var db = new Model1())\r\n{\r\n var sts = new m_status()\r\n {\r\n id = 3,\r\n status = \"\u4fdd\u7559\"\r\n };\r\n\r\n db.m_status.Attach(sts);\r\n db.Entry(sts).State = System.Data.Entity.EntityState.Modified;\r\n db.SaveChanges();\r\n}\r\n<\/pre>\n <\/p>\n
\uff11\uff12\uff0e\u30c8\u30e9\u30f3\u30b6\u30af\u30b7\u30e7\u30f3\u51e6\u7406<\/p>\n
using (var db = new Model1())\r\n{\r\n ((IObjectContextAdapter)db).ObjectContext.Connection.Open();\r\n\r\n using (var tx = new TransactionScope())\r\n {\r\n var sts = new m_status\r\n {\r\n id = 5,\r\n status = \"\u6253\u5408\u305b\"\r\n };\r\n\r\n db.m_status.Add(sts);\r\n db.SaveChanges();\r\n\r\n\r\n m_status[] sts2 = new m_status[]\r\n {\r\n new m_status {id = 6, status = \"\u4f1a\u8b70\" },\r\n new m_status {id = 7, status = \"\u51fa\u5f35\" },\r\n };\r\n\r\n db.m_status.AddRange(sts2);\r\n db.SaveChanges();\r\n\r\n tx.Complete();\r\n }\r\n}\r\n<\/pre>\n <\/p>\n
\uff11\uff13\uff0eSQL\u6587\u3092\u76f4\u63a5\u767a\u884c<\/p>\n
using (var db = new Model1())\r\n{\r\n var q = db.Database.ExecuteSqlCommand(\"UPDATE m_status SET status = '\u51fa\u5f35' WHERE id = 7;\");\r\n}\r\n<\/pre>\n <\/p>\n
\uff11\uff14\uff0e\u30d1\u30e9\u30e1\u30fc\u30bf\u30fc\u30af\u30a8\u30ea\u30fc<\/p>\n
using (var db = new Model1())\r\n{\r\n var sql = @\"SELECT * FROM m_status WHERE id = @id\";\r\n var param = new SqlParameter(\"@id\", 3);\r\n var sts = db.Database.SqlQuery<m_status>(sql, param);\r\n\r\n foreach (var st in sts)\r\n {\r\n Console.WriteLine(\"id={0}, status={1}\", st.id, st.status);\r\n }\r\n}\r\n<\/pre>\n <\/p>\n","protected":false},"excerpt":{"rendered":"
\uff11\uff0e\u30af\u30a8\u30ea\u30fc\u5f0f using (var db = new Model1()) { var query = fro […]<\/p>\n","protected":false},"author":1,"featured_media":0,"parent":0,"menu_order":0,"comment_status":"closed","ping_status":"closed","template":"","meta":{"footnotes":""},"class_list":["post-20242","page","type-page","status-publish","hentry"],"wppr_data":{"cwp_meta_box_check":"No"},"_links":{"self":[{"href":"https:\/\/agrimo.jp\/wp\/index.php?rest_route=\/wp\/v2\/pages\/20242","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/agrimo.jp\/wp\/index.php?rest_route=\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/agrimo.jp\/wp\/index.php?rest_route=\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/agrimo.jp\/wp\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/agrimo.jp\/wp\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=20242"}],"version-history":[{"count":26,"href":"https:\/\/agrimo.jp\/wp\/index.php?rest_route=\/wp\/v2\/pages\/20242\/revisions"}],"predecessor-version":[{"id":20273,"href":"https:\/\/agrimo.jp\/wp\/index.php?rest_route=\/wp\/v2\/pages\/20242\/revisions\/20273"}],"wp:attachment":[{"href":"https:\/\/agrimo.jp\/wp\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=20242"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}