EF model first方式, 你的DB是繼承ObjectContext

using (MyObjectContext db = new MyObjectContext() ){ string sql = “ select columnA, columnB from TableA where 1 = 1 ”; db.ExecuteStoreQuery<TableAObject>(sql).ToList();//TableAObject就是你定義的物件，物件屬性就是columnA, columnB}

code first, 你的db是繼承DbContext

using (MyDbContext db = new MyDbContext() ){ string sql = “ select columnA, columnB from TableA where 1 = 1 ”; db.TableAObject.SqlQuery(sql).ToList();//TableAObject就是在MyDbContext 定義的物件 }

db.Database.ExecuteSqlCommand(sqlString)