There are certain points we need to take into consideration while performing UNION in Entity Framework. This is an easier way to get entities with different queries and then use Union. As shown in below example, where we are using Union to get result from Texas and Florida states. var floridaEntity = ctx.Orders.Where(o => o.State == "Florida").Select(o => o); var TexasEntity = ctx.Orders.Where(o => o.State == "Texas").Select(o => o); var floridaTexas = floridaEntity.Union(TexasEntity); Another way to use Union is shown below, (from p in Tblpages join pa in Tblpageactions on p.PageId equals pa.PageId join rp in Tblrolepermissions on pa.ActionId equals rp.ActionId into jrs from jrResult in jrs.DefaultIfEmpty() where jrResult.RoleId == 1 select new {
Technology & Knowledge is to Share
Comments
Post a Comment