{"rsdb":{"rid":"239893","subhead":"","postdate":"0","aid":"165295","fid":"57","uid":"1","topic":"1","content":"
\r\n \/\/1.\u65b0\u5efa\u4e00\u4e2a\u4e34\u65f6\u6587\u4ef6\u5939\u6765\u5b58\u653e\u65b0\u5efa\u7684\u6570\u636e\u5e93\r\n string userTempFolder = Environment.GetEnvironmentVariable\r\n ("SystemDrive") + @"\\YJingLee";\r\n Directory.CreateDirectory(userTempFolder);\r\n \/\/2.\u65b0\u5efa\u6570\u636e\u5e93NewCreateDB\r\n string userMDF = System.IO.Path.Combine(userTempFolder,\r\n @"NewCreateDB.mdf");\r\n string connStr = String.Format(@"Data Source=.\\SQLEXPRESS;\r\nAttachDbFilename={0};Integrated Security=True;\r\nConnect Timeout=30;User Instance=True; \r\nIntegrated Security = SSPI;", userMDF);\r\n NewCreateDB newDB = new NewCreateDB(connStr);\r\n newDB.CreateDatabase();\r\n \/\/3.\u63d2\u5165\u6570\u636e\u5e76\u67e5\u8be2\r\n var newRow = new Person\r\n {\r\n PersonID = 1,\r\n PersonName = "YJingLee",\r\n Age = 22\r\n };\r\n\r\n newDB.Persons.InsertOnSubmit(newRow);\r\n newDB.SubmitChanges();\r\n var q = from x in newDB.Persons\r\n select x;\r\n \/\/4.\u5220\u9664\u6570\u636e\u5e93\r\n newDB.DeleteDatabase();\r\n \/\/5.\u5220\u9664\u4e34\u65f6\u76ee\u5f55\r\n Directory.Delete(userTempFolder);<\/pre> \n\u6570\u636e\u5e93\u9a8c\u8bc1<\/h2> DatabaseExists\u65b9\u6cd5\u7528\u4e8e\u5c1d\u8bd5\u901a\u8fc7\u4f7f\u7528DataContext\u4e2d\u7684\u8fde\u63a5\u6253\u5f00\u6570\u636e\u5e93\uff0c\u5982\u679c\u6210\u529f\u8fd4\u56detrue\u3002\n
\u4e0b\u9762\u4ee3\u7801\u8bf4\u660e\u662f\u5426\u5b58\u5728Northwind\u6570\u636e\u5e93\u548cNewCreateDB\u6570\u636e\u5e93 \u3002\n
\n\r\n\/\/\u68c0\u6d4bNorthwind\u6570\u636e\u5e93\u662f\u5426\u5b58\u5728\r\nif (db.DatabaseExists())\r\n Console.WriteLine("Northwind\u6570\u636e\u5e93\u5b58\u5728");\r\nelse\r\n Console.WriteLine("Northwind\u6570\u636e\u5e93\u4e0d\u5b58\u5728");\r\n\/\/\u68c0\u6d4bNewCreateDB\u6570\u636e\u5e93\u662f\u5426\u5b58\u5728\r\nstring userTempFolder = Environment.GetEnvironmentVariable("Temp");\r\nstring userMDF = System.IO.Path.Combine(userTempFolder,\r\n@"NewCreateDB.mdf");\r\nNewCreateDB newDB = new NewCreateDB(userMDF);\r\n\r\nif (newDB.DatabaseExists())\r\n Console.WriteLine("NewCreateDB\u6570\u636e\u5e93\u5b58\u5728");\r\nelse\r\n Console.WriteLine("NewCreateDB\u6570\u636e\u5e93\u4e0d\u5b58\u5728");<\/pre> \n\u6570\u636e\u5e93\u66f4\u6539<\/h2> SubmitChanges\u65b9\u6cd5\u8ba1\u7b97\u8981\u63d2\u5165\u3001\u66f4\u65b0\u6216\u5220\u9664\u7684\u5df2\u4fee\u6539\u5bf9\u8c61\u7684\u96c6\uff0c\u5e76\u6267\u884c\u76f8\u5e94\u547d\u4ee4\u4ee5\u5b9e\u73b0\u5bf9\u6570\u636e\u5e93\u7684\u66f4\u6539\u3002\n
\u65e0\u8bba\u5bf9\u8c61\u505a\u4e86\u591a\u5c11\u9879\u66f4\u6539\uff0c\u90fd\u53ea\u662f\u5728\u66f4\u6539\u5185\u5b58\u4e2d\u7684\u526f\u672c\u3002\u5e76\u672a\u5bf9\u6570\u636e\u5e93\u4e2d\u7684\u5b9e\u9645\u6570\u636e\u505a\u4efb\u4f55\u66f4\u6539\u3002\u76f4\u5230\u5bf9DataContext\u663e\u5f0f\u8c03\u7528SubmitChanges\uff0c\u6240\u505a\u7684\u66f4\u6539\u624d\u4f1a\u4f20\u8f93\u5230\u670d\u52a1\u5668\u3002\u8c03\u7528\u65f6\uff0cDataContext\u4f1a\u8bbe\u6cd5\u5c06\u6211\u4eec\u6240\u505a\u7684\u66f4\u6539\u8f6c\u6362\u4e3a\u7b49\u6548\u7684SQL\u547d\u4ee4\u3002\u6211\u4eec\u4e5f\u53ef\u4ee5\u4f7f\u7528\u81ea\u5df1\u7684\u81ea\u5b9a\u4e49\u903b\u8f91\u6765\u91cd\u5199\u8fd9\u4e9b\u64cd\u4f5c\uff0c\u4f46\u63d0\u4ea4\u987a\u5e8f\u662f\u7531DataContext\u7684\u4e00\u9879\u79f0\u4f5c\u201c\u66f4\u6539\u5904\u7406\u5668\u201d\u7684\u670d\u52a1\u6765\u534f\u8c03\u7684\u3002\u4e8b\u4ef6\u7684\u987a\u5e8f\u5982\u4e0b\uff1a\n
\u5f53\u8c03\u7528SubmitChanges\u65f6\uff0cLINQ to SQL\u4f1a\u68c0\u67e5\u5df2\u77e5\u5bf9\u8c61\u7684\u96c6\u5408\u4ee5\u786e\u5b9a\u65b0\u5b9e\u4f8b\u662f\u5426\u5df2\u9644\u52a0\u5230\u5b83\u4eec\u3002\u5982\u679c\u5df2\u9644\u52a0\uff0c\u8fd9\u4e9b\u65b0\u5b9e\u4f8b\u5c06\u6dfb\u52a0\u5230\u88ab\u8ddf\u8e2a\u5bf9\u8c61\u7684\u96c6\u5408\u3002\n
\u6240\u6709\u5177\u6709\u6302\u8d77\u66f4\u6539\u7684\u5bf9\u8c61\u5c06\u6309\u7167\u5b83\u4eec\u4e4b\u95f4\u7684\u4f9d\u8d56\u5173\u7cfb\u6392\u5e8f\u6210\u4e00\u4e2a\u5bf9\u8c61\u5e8f\u5217\u3002\u5982\u679c\u4e00\u4e2a\u5bf9\u8c61\u7684\u66f4\u6539\u4f9d\u8d56\u4e8e\u5176\u4ed6\u5bf9\u8c61\uff0c\u5219\u8fd9\u4e2a\u5bf9\u8c61\u5c06\u6392\u5728\u5176\u4f9d\u8d56\u9879\u4e4b\u540e\u3002\n
\u5728\u5373\u5c06\u4f20\u8f93\u4efb\u4f55\u5b9e\u9645\u66f4\u6539\u65f6\uff0cLINQ to SQL\u4f1a\u542f\u52a8\u4e00\u4e2a\u4e8b\u52a1\u6765\u5c01\u88c5\u7531\u5404\u6761\u547d\u4ee4\u7ec4\u6210\u7684\u7cfb\u5217\u3002\n
\u5bf9\u5bf9\u8c61\u7684\u66f4\u6539\u4f1a\u9010\u4e2a\u8f6c\u6362\u4e3aSQL\u547d\u4ee4\uff0c\u7136\u540e\u53d1\u9001\u5230\u670d\u52a1\u5668\u3002 \n\u5982\u679c\u6570\u636e\u5e93\u68c0\u6d4b\u5230\u4efb\u4f55\u9519\u8bef\uff0c\u90fd\u4f1a\u9020\u6210\u63d0\u4ea4\u8fdb\u7a0b\u505c\u6b62\u5e76\u5f15\u53d1\u5f02\u5e38\u3002\u5c06\u56de\u6eda\u5bf9\u6570\u636e\u5e93\u7684\u6240\u6709\u66f4\u6539\uff0c\u5c31\u50cf\u672a\u8fdb\u884c\u8fc7\u63d0\u4ea4\u4e00\u6837\u3002DataContext \u4ecd\u5177\u6709\u6240\u6709\u66f4\u6539\u7684\u5b8c\u6574\u8bb0\u5f55\u3002<\/p> \n
\u4e0b\u9762\u4ee3\u7801\u8bf4\u660e\u7684\u662f\u5728\u6570\u636e\u5e93\u4e2d\u67e5\u8be2CustomerID\u4e3aALFKI\u7684\u987e\u5ba2\uff0c\u7136\u540e\u4fee\u6539\u5176\u516c\u53f8\u540d\u79f0\uff0c\u7b2c\u4e00\u6b21\u66f4\u65b0\u5e76\u8c03\u7528SubmitChanges()\u65b9\u6cd5\uff0c\u7b2c\u4e8c\u6b21\u66f4\u65b0\u4e86\u6570\u636e\u4f46\u5e76\u672a\u8c03\u7528SubmitChanges()\u65b9\u6cd5\u3002<\/p> \n
\r\n\/\/\u67e5\u8be2\r\nCustomer cust = db.Customers.First(c => c.CustomerID == "ALFKI");\r\n","orderid":"0","title":"LINQ to SQL\u8bed\u53e5DataContext\u4ecb\u7ecd\u548c\u4f7f\u7528(\u4e00)","smalltitle":"","mid":"0","fname":"\u6570\u636e\u5e93\u7f16\u7a0b","special_id":"0","bak_id":"0","info":"0","hits":"277","pages":"2","comments":"0","posttime":"2017-10-20 08:14:17","list":"1508458457","username":"admin","author":"","copyfrom":"","copyfromurl":"","titlecolor":"","fonttype":"0","titleicon":"0","picurl":"https:\/\/www.cppentry.com\/upload_files\/","ispic":"0","yz":"1","yzer":"","yztime":"0","levels":"0","levelstime":"0","keywords":"LINQ<\/A> SQL<\/A> \u8bed\u53e5<\/A> DataContext<\/A> \u4ecb\u7ecd<\/A> \u4f7f\u7528<\/A>","jumpurl":"","iframeurl":"","style":"","template":"a:3:{s:4:\"head\";s:0:\"\";s:4:\"foot\";s:0:\"\";s:8:\"bencandy\";s:0:\"\";}","target":"0","ip":"113.108.110.181","lastfid":"0","money":"0","buyuser":"","passwd":"","allowdown":"","allowview":"","editer":"","edittime":"0","begintime":"0","endtime":"0","description":"LINQ to SQL\u8bed\u53e5DataContext\u4ecb\u7ecd\u548c\u4f7f\u7528","lastview":"1701788121","digg_num":"0","digg_time":"0","forbidcomment":"0","ifvote":"0","heart":"","htmlname":"","city_id":"0"},"page":"1"}