如何使用多个连接在sql server查询中使用关键字？ [英] How to use into key word in sql server query by using multiple joins?

问题描述

如何在包含多个连接的sql server查询中使用INTO关键字



这是linq查询我在sql中需要这个如何使用INTO关键字sql server

 var query = 来自 eq  设备
  join  f  in  fileCodes   eq.EquipmentCode等于f.EquipmentCode 
 
  join  pcv   _context.PCVs  on  eq.PcvId等于pcv.EquipmentId 进入 pcvj 
 来自 pcvx   pcvj.DefaultIfEmpty（）
 
  join  pcve   _context.Equipment  on  pcv x.EquipmentId等于pcve.EquipmentId 进入 pcvej 
 来自 pcvex  in  pcvej.DefaultIfEmpty（）
 
  join  pcv2  in  _context.PCVs  on  eq.EquipmentId等于pcv2.EquipmentId  into  pcv2j 
 来自 pcv2x   pcv2j.DefaultIfEmpty（）

解决方案

代码如下所示

 var query =（来自设备中的eq 
在eq.EquipmentCode上的fileCodes中加入f等于f.EquipmentCode 
加入pcv in _context.PCVs on eq.PcvId equals pcv.EquipmentId 
 join pcve in _context.Equipment on pcv.EquipmentId equals pcve.EquipmentId 
 sele ct new 
 {
 EquipmentCode = f.EquipmentCode，// so 
}}。ToList（）; 

How to use INTO key word in sql server query which contain multiple joins

This is linq query I need this in sql that how to use INTO key word in sql server

var query = from eq in equipment
    join f in fileCodes on eq.EquipmentCode equals f.EquipmentCode

    join pcv in _context.PCVs on eq.PcvId equals pcv.EquipmentId into pcvj
    from pcvx in pcvj.DefaultIfEmpty()

    join pcve in _context.Equipment on pcvx.EquipmentId equals pcve.EquipmentId into pcvej
    from pcvex in pcvej.DefaultIfEmpty()

    join pcv2 in _context.PCVs on eq.EquipmentId equals pcv2.EquipmentId into pcv2j
    from pcv2x in pcv2j.DefaultIfEmpty()

解决方案

code like following below

var query = (from eq in equipment
                         join f in fileCodes on eq.EquipmentCode equals f.EquipmentCode
                         join pcv in _context.PCVs on eq.PcvId equals pcv.EquipmentId
                         join pcve in _context.Equipment on pcv.EquipmentId equals pcve.EquipmentId
                         select new
                         {
                             EquipmentCode = f.EquipmentCode,//so on
                         }).ToList(); 

这篇关于如何使用多个连接在sql server查询中使用关键字？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！