# 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