# EF执行原生sql
public async Task<object> Test()
{
string userName = "admin";
//FromSqlInterpolated方法参数化查询,具体参照EF文档
FormattableString formattableString = $"select * from Sys_User where UserName={userName}";
var user = await repository.FromSqlInterpolated(formattableString)
.Where(x => 1 == 1)
.Select(s => new
{
s.User_Id,
s.UserPwd
}).FirstOrDefaultAsync();
return user;
}
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16