在实体框架中的两个表之间进行选择

发布于 2024-11-19 01:58:22 字数 528 浏览 4 评论 0原文

我想在两个有关系的表之间编写一个选择。我使用这段代码，但没有得到任何结果。请告诉我

 using (doctorEntities de = new doctorEntities())
        {
            var select = from tibase in de.Table_infobase_print
                         from tidetail in de.Table_infodetail_print
                         where tibase.ID == tidetail.ID_infobase 
                         select new
                         {
                             tidetail.services_discription,tidetail.price,tibase.folder_code
                         };
        }

原文

I want to write a select between two table that have relation.
I use this code but i get no result.
Please advise me

 using (doctorEntities de = new doctorEntities())
        {
            var select = from tibase in de.Table_infobase_print
                         from tidetail in de.Table_infodetail_print
                         where tibase.ID == tidetail.ID_infobase 
                         select new
                         {
                             tidetail.services_discription,tidetail.price,tibase.folder_code
                         };
        }

分享到QQ

分享到微博

如果你对这篇内容有疑问，欢迎到本站社区发帖提问参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。

发布评论

需要登录才能够评论，你可以免费注册一个本站的账号。

诺曦 2024-11-26 01:58:22

我认为您可能正在寻找联接，无论数据库中是否有匹配的行，您都应该获得结果。目前您还没有对结果做任何事情。

using (doctorEntities de = new doctorEntities())
{
    var results = from tibase in de.Table_infobase_print
                  join tidetail in de.Table_infodetail_print
                  on tibase.ID equals tidetail.ID_infobase 
                  select new
                  {
                      tidetail.services_discription,
                      tidetail.price,
                      tibase.folder_code
                  };
    foreach(var result in results)
    {
        Console.WriteLine("Service description: " + result.services_discription);
    }
}

I think you might be looking for a join instead, regardless you should be getting results if you have matching rows in the database. Also currently you are not doing anything with the results.

using (doctorEntities de = new doctorEntities())
{
    var results = from tibase in de.Table_infobase_print
                  join tidetail in de.Table_infodetail_print
                  on tibase.ID equals tidetail.ID_infobase 
                  select new
                  {
                      tidetail.services_discription,
                      tidetail.price,
                      tibase.folder_code
                  };
    foreach(var result in results)
    {
        Console.WriteLine("Service description: " + result.services_discription);
    }
}

回复收藏 0 原文

~没有更多了~