随笔分类 - ORM

EntityFramework left join

摘要：var result = from u in db.Order join n in db.Equipment on u.OrderId equals n.OrderId into temp from m in temp.DefaultIfEmpty() select new { OrderID = 阅读全文

posted @ 2014-06-06 17:00 wolf12 阅读(167) 评论(0) 推荐(0)

EntityFramework 更新表结构到数据库

摘要：在程序包管理器控制台 1.执行：Enable-Migrations -Force 生成：Migrations 2 修改AutomaticMigrationsEnabled默认为false改为true 3.执行：Update-Database -Verbose -Script 生成迁移sql语句，如阅读全文

posted @ 2014-06-06 16:38 wolf12 阅读(555) 评论(0) 推荐(0)