SQL 查询 - EF Core | Microsoft Learn
1. 执行原始SQL的三个方法
//sqlite 查询user表是否存在
var executeSqlInt = db.Database.ExecuteSql($"SELECT count(*) FROM sqlite_master WHERE type='table' AND name='user';");
var sqlQueryInt = db.Database.SqlQuery<int>($"SELECT count(*) FROM sqlite_master WHERE type='table' AND name='user';");
var sqlQueryRawInt = db.Database.SqlQueryRaw<int>($"SELECT count(*) FROM sqlite_master WHERE type='table' AND name='user';");
2. 使用实例
//原始sql查询 0:不存在 1:表存在
var i = db.Database.SqlQuery<int>($"SELECT count(*) FROM sqlite_master WHERE type='table' AND name='user'").AsEnumerable().First();
//user 表是否存在
var isTableExist = i > 0;