/C#/Entity framework linq join two tables

Entity framework linq join two tables

Entity framework linq join 2 tables c#

// model properties
 public class TargetUsers
    {
        public string LoginName { get; set; }
        public string Email { get; set; }
        public string CountryCode { get; set; }
        public string BranchCode { get; set; }
        public string LoginType { get; set; }
    }

// DAL
  public List<TargetUsers> GetTargetUsers()
        {
            try
            {
                using (var entities = new YourEntities())
                {
                    var query = (from login in entities.Login_User
                                 join company in entities.Mst_CompanyCode
                                   on login.LU_CountryCode equals company.MC_CompanyCode
                                 join branch in entities.Mst_BranchCode
                                   on company.MC_CompanyCode equals branch.MC_CompanyCode
                                 where company.MC_isEnabled == true
                                 orderby login.LU_LOGIN_NAME
                                 select new TargetUsers()
                                 {
                                     LoginName = login.LU_LOGIN_NAME,
                                     //Email = login.LU_EMAIL,
                                     //CountryCode = login.LU_CountryCode,
                                     //BranchCode = branch.MC_BranchCode,
                                     //LoginType = login.LU_Login_Type
                                 }).Distinct();

                    return query.ToList();

                }
            }
            catch (Exception)
            {

                throw;
            }
        }

Source: grepper.com

Similar codes

0 vote354 views1 answer
C# recorrer una lista
C#
0 vote342 views1 answer
Asp.net razor get list without refresh
C#
3 votes339 views2 answers
Ngrok for https
C#
0 vote320 views1 answer
C# property attribute
C#
1 vote348 views1 answer
Month number to text in c#
C#
0 vote330 views1 answer
There is no implicit reference conversion from 'xxxx.Database.Domain.Entities.Order' to 'System.IDisposable'
C#
9 votes369 views1 answer
Unity get layer of gameobject
C#Unity
0 vote310 views1 answer
C# json contains property
C#
0 vote378 views1 answer
Handling aggregation responses with NEST c#
C#
0 vote352 views1 answer
.Net Core Bundling & minification : .net core The name 'Scripts' does not exist in the current context
C#