ExecuteStoreQuery

最新推荐文章于 2019-08-02 22:54:40 发布

weixin_30634661

最新推荐文章于 2019-08-02 22:54:40 发布

阅读量361

点赞数

原文链接：http://www.cnblogs.com/smailxiaobai/p/3740662.html

版权

  using (var webdb = new kyj_NewHouseDBEntities())
            {
                string sql = "select * from developer where loginname='liyuzhao'; select 4 as Id;select 3;UPDATE dbo.Developer SET Telephone='123' WHERE LoginName='liyuzhao'";
                var result = webdb.ExecuteStoreQuery<Developer>(sql, null);//返回第一个查询集合,返回的数据集的列要和实体对应
                var vv = result.Where(m => m.Id > 0);
                foreach (var v in vv)
                {
                    Console.WriteLine(v.ProvinceId);
                }
            }