c#后台查询sql server数据库

Question

请问我要查询满足条件的供货商编号的话 ef语句怎么写 还有他的sql语句应该怎么写

Answer 1

sql
select supplierno from supplier_material where materialname like '%物料a%' and materialname like '%物料b%'  materialname like '%物料c%' 
linq
from x in db.supplier_material 
where x.materialname.Contains("物料a") && x.materialname.Contains("物料b") && x.materialname.Contains("物料c")
select x.supplierno

问题解决请点下采纳