1) SQL语句查询实体
var members = db.Members.SqlQuery(
"select * from Member").ToList();
2) SQL语句查询非实体类型
注意不要把类型指定错了,这里返回的一定是List。
string sql = "SELECT * FROM tableName WHERE name like 'B%' ";
// var memberNames = db.Database.SqlQuery<Entity>(sql).ToList();
List<Entity> list = db.Database.SqlQuery<Entity>(sql).ToList();
</pre><pre>
3)多表查询
<1> 建一个对应查询字段接收实体
public class Test
{
public int id { get; set; }
public string service_id { get; set; }
public int type { get; set; }
public int testenable { get; set; }
}
<2>查询
string sql = "SELECT p.id, p.service_id, p.type, pg.enable testenable FROM tableName1 pg LEFT JOIN tableName2 p ON p.id = pg.id";
List<Test> list = db.Database.SqlQuery<Test>(sql).ToList();
4) 执行SQL命令
context.Database.ExecuteSqlCommand(
"update Member set Name = '张三' where Name = '李四'");