Linq to sql converter online

from P in session.Query<Pessoa>()
                    where (P.NumCPF.Contains(CPF_CNPJ) || P.NumCNPJ.Contains(CPF_CNPJ) || string.IsNullOrEmpty(CPF_CNPJ))
                    select new PessoaVO
                    {
                        CodigoPessoa = P.Codigo,
                        NomePessoa = P.NomePessoa,
                        CPF_CNPJ = !string.IsNullOrEmpty(P.NumCPF) ? P.NumCPF : P.NumCNPJ
                    }

Linq to sql converter online

(from p in db.Products
                         join sp in db.Saleorder_Product on   p.ProductID equals sp.ProductID
                         join s in db.Saleorders  on sp.SaleID equals s.SaleID
                         join u in db.Users on s.UserID equals u.UserID
                         group by u.UserName, s.BookDate, p.ProductID, p.ProductName
                         select u.UserName,s.BookDate,p.ProductID,p.ProductName,sum(sp.quantity) as SoLuong)

Linq to sql converter online

 ProductBrandingPriceVariants = (from branding in _repositoryBrandingMethod.GetAll().AsQueryable()
                                                        join method in _productBrandingMethodsRepository.GetAll().AsQueryable() on branding.Id equals method.BrandingMethodId
                                                        where method.ProductMasterId == Input.ProductId
                                                        select new BrandingMethodPriceModel
                                                        {
                                                            Id = branding.Id,
                                                            MethodName = branding.MethodName,
                                                            UnitPrice = branding.UnitPrice,
                                                            // IsColorSelected = _BrandingMethodAssignedColors.GetAll().Where(i => i.BrandingMethodId == branding.Id).Select(i => i.Id).FirstOrDefault() > 0 ? true : false,
                                                            IsColorSelected = branding.ColorSelectionType == 1 ? true : false,
                                                            SelectedColor =  string.IsNullOrEmpty((from color in _BrandingMethodAssignedColors.GetAll().Where(i=>i.BrandingMethodId == branding.Id)
                                                                             join colormaster in _ProductColourMasterRepo.GetAll() on color.ColorId equals colormaster.Id
                                                                             select colormaster.ProductColourName
                                                                             ).FirstOrDefault())? "0" : (from color in _BrandingMethodAssignedColors.GetAll().Where(i => i.BrandingMethodId == branding.Id)
                                                                                                         join colormaster in _ProductColourMasterRepo.GetAll() on color.ColorId equals colormaster.Id
                                                                                                         select colormaster.ProductColourName
                                                                             ).FirstOrDefault(),

                                                            PriceModel = (from price in _productBrandingPriceVariantsRepository.GetAll().Where(i => i.BrandingMethodId == branding.Id)
                                                                          select new ProductBrandingPriceVariantsDto
                                                                          {
                                                                              Quantity = price.Quantity,
                                                                              BrandingUnitPrice = price.BrandingUnitPrice,
                                                                              IsActive = price.IsActive,
                                                                              Price = price.Price,
                                                                              Id = price.Id,
                                                                              BrandingMethodId = price.BrandingMethodId
                                                                          }).ToList()
                                                        }).ToList(),

Linq to sql converter online

from usu in context.USUARIOs
                                    join per in context.PERFILs on usu.per_id equals per.per_id
                                    join menper in context.MENU_PERFIL on per.per_id equals menper.per_id
                                    join menu in context.MENUs on menper.men_id equals menu.men_id
                                    join sol in context.SOLUCIONs on per.solu_id equals sol.solu_id
                                    where (usu.pers_rol == pers_rol)
                                    && sol.solu_nombre == "RegistroOTPlotter"
                                    && usu.usu_vigente == true
                                    select usu

Linq to sql converter online

from location in _context.Businessunit
                                       where request.locationId.Contains(location.Id)
                                       join client in _context.Businessunit on location.Parentbusinessunitid equals client.Id
                                       join building in _context.Area on location.AddressId equals building.AddressId
                                       where building.Appcategoryname == "Building" && building.IsEnable == true
                                       join floor in _context.Area on building.Id equals floor.Parentareaid
                                       where floor.Appcategoryname == "Floor" && building.IsEnable == true
                                       join department in _context.Area on floor.Id equals department.Parentareaid
                                       where department.Appcategoryname == "Department" && building.IsEnable == true
                                       join equipment in _context.Equipment on department.Id equals equipment.Areaid
                                       join device in _context.Device on equipment.Id equals device.Equipmentid
                                       where device.IsEnable == true
                                     
                                       select new
                                       {
                                           deviceId = device.Id,
                                           deviceName = device.Devicename,
                                           deviceNummber = device.DeviceNumber,
                                           isConnected = device.IsConnected,
                                           lastConnected = device.LastConnected,
                                           lastSprayCycle = device.LastActualCommunicatedAt,
                                           location_name = location.Name,
                                           customer = client.Name,
                                           building_name = building.AreaName,
                                           floor_name = floor.AreaName,
                                           department_name = department.AreaName,
                                           
                                       }

Linq to sql converter online

(from p in db.Products
                         join sp in db.Saleorder_Product on   p.ProductID equals sp.ProductID
                         join s in db.Saleorders  on sp.SaleID equals s.SaleID
                         join u in db.Users on s.UserID equals u.UserID
                         group by u.UserName, s.BookDate, p.ProductID, p.ProductName
                         select u.UserName,s.BookDate,p.ProductID,p.ProductName,sum(sp.quantity) as SoLuong)

Linq to sql converter online

SELECT * FROM TABLE

Linq to sql converter online

            var bonuses = AutoMapEntityToDTO.AutoMapCBBonusDTO(_cbBonusRepository.GetListResultSpec(r => r.Where(predicate).OrderByDescending(p => p.CBBonusValueNew != null ? p.CBBonusValueNew.PK : p.CBBonusValueOld.PK).Skip(skip).Take(stringCount)));

Linq to sql converter online

select * from table

Similar codes

0 vote135 views2 answers
Mysql row_number() example
SQL
0 vote136 views1 answer
Convert sqlalchemy.util._collections to list of string
SQL
25 votes106 views1 answer
Mysql grant all privileges to a user
SQL
21 votes111 views1 answer
Cheatsheet for sql
SQL
0 vote136 views1 answer
Check command
SQL
1 vote127 views1 answer
Sysdate in sql
SQL
0 vote125 views1 answer
Set mysql socket file docker windows
SQL
0 vote133 views2 answers
Select last 30 days sql
SQL
6 votes126 views2 answers
Sql display max value
SQL
0 vote116 views1 answer
Whenever i'm passing data from datatable to sql table for large number in table it is storing with e+
SQL