.net core webapi 怎么使用ef来调用sql函数

Question

.net core webapi 怎么使用ef来调用sql函数

Answer 1

ef混用dapper吧

db.Database.GetDbConnection().ExecuteScalar<string>("");

Answer 2

context.Blogs.FromSqlRaw("SELECT * FROM dbo.Blogs")
https://docs.microsoft.com/en-us/ef/core/querying/raw-sql
来自微软官方文档 https://docs.microsoft.com/en-us/ef/core/querying/raw-sql

Answer 3

db.Database.ExecuteSqlCommand(sqlString)