在核心 MVC 中使用 Dapper 连接表并按多个条件 asp.net 过滤

Question

我想查询连接具有多个条件的两个表

string sql = "Select l.*, c.FirstName_CompanyName from dbo.Loan l left join Customer c on  l.CustId=c.CustId where LoanAccountNo > 0 ";

当我实现上面的代码时，但我发现我需要按批准和删除过滤贷款表，但我似乎无法正确处理。

下面的代码是我尝试过但没有奏效的代码

string sql = "Select l.*, c.FirstName_CompanyName from dbo.Loan WHERE Delete = 0 AND Approve = 1 l left join Customer c on  l.CustId=c.CustId where LoanAccountNo > 0 ";

{"Incorrect syntax near the keyword 'Delete'."}

Answer 1

请使用下面的代码，代码中存在类型错误，您在贷款表和别名之间添加了删除 DNA 批准条件 l

string sql = "Select l.*, c.FirstName_CompanyName from dbo.Loan l WHERE l.Delete = 0 AND l.Approve = 1 left join Customer c on  l.CustId=c.CustId where LoanAccountNo > 0 ";