我需要从数据库查询linq查询 [英] I need linq query from database query

问题描述

这是数据库查询...

Here is the database query ...

SELECT Circular_Id,Circular_Name,Topic,StartDate,EndDate,detail1,detail2,detail3,Name,branch_name FROM Circular C INNER JOIN Circular_Type CT ON C.Circular_Type_Id = CT.Circular_Type_Id INNER JOIN SMS_Branches B ON B.branch_id = C.branch_id

我尝试了什么：



如何创建linq查询从上面写的数据库查询...请帮忙！

What I have tried:

how to create linq query from the database query written above... please help!

推荐答案

检查一下：

join子句（C＃参考）| Microsoft Docs [ ^ ]

执行内部加入| Microsoft Docs [ ^ ]

向左执行外连接| Microsoft Docs [ ^ ]

执行分组加入| Microsoft Docs [ ^ ]

Check this:
join clause (C# Reference) | Microsoft Docs[^]
Perform inner joins | Microsoft Docs[^]
Perform left outer joins | Microsoft Docs[^]
Perform grouped joins | Microsoft Docs[^]

var result = from a in tablea
      join b in tableb on a.PrimaryKey equals b.ForeignKey
      join c in tablec on b.PrimaryKey equals c.ForeignKey
      select new {...};

我们不做你的作业：它是有原因的。它就是为了让你思考你被告知的事情，并试着理解它。它也在那里，以便您的导师可以识别您身体虚弱的区域，并将更多的注意力集中在补救措施上。



亲自尝试，你可能会发现它不是和你想的一样困难！



如果遇到具体问题，请询问相关问题，我们会尽力提供帮助。但我们不打算为你做这一切！

We do not do your homework: it is set for a reason. It is there so that you think about what you have been told, and try to understand it. It is also there so that your tutor can identify areas where you are weak, and focus more attention on remedial action.

Try it yourself, you may find it is not as difficult as you think!

If you meet a specific problem, then please ask about that and we will do our best to help. But we aren't going to do it all for you!

这篇关于我需要从数据库查询linq查询的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！