C＃linq到sql使用但需要linq来进行sql查询 [英] C# linq to sql using but need linq to sql query

问题描述

大家好，



请帮我解决这个linq查询到sql查询



这里是外键关系有这三个表请帮我写一下sql

Hi All,

Please help me on this linq query to sql query

here is foreign key relation is there for these 3 tables please help me write in sql

var versionPackageMapping = from verMap 
  in this.MobileUpdateContext.VersionPackageMappings.Include(Constants.PACKAGE)
  join pkg in this.MobileUpdateContext.Packages on verMap.PackageId equals pkg.ID
  where verMap.PackageStatu.Status == packageStatus &&
     verMap.PackageType.Type == packageType &&
     verMap.Version.ManufacturerCode == manufacturerCode &&
     verMap.Version.HardwareVersion == hardwareVersion &&
     verMap.Version.CarrierCode == carrierCode &&
     verMap.Version.SoftwareVersion == softwareVersion &&
     verMap.IsActive == isActive
  select verMap;

提前付款

Narasimh

Thanks in advance
Narasimh

推荐答案

看看这里：如何：显示生成的SQL（LINQ to SQL） [ ^ ]。请仔细阅读;）

Have a look here: How to: Display Generated SQL (LINQ to SQL)[^]. Please read it carefully ;)

这篇关于C＃linq到sql使用但需要linq来进行sql查询的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！