SyntaxFix

[c#] Creating a LINQ select from multiple tables

You can use anonymous types for this, i.e.:

var pageObject = (from op in db.ObjectPermissions
                  join pg in db.Pages on op.ObjectPermissionName equals page.PageName
                  where pg.PageID == page.PageID
                  select new { pg, op }).SingleOrDefault();

This will make pageObject into an IEnumerable of an anonymous type so AFAIK you won't be able to pass it around to other methods, however if you're simply obtaining data to play with in the method you're currently in it's perfectly fine. You can also name properties in your anonymous type, i.e.:-

var pageObject = (from op in db.ObjectPermissions
                  join pg in db.Pages on op.ObjectPermissionName equals page.PageName
                  where pg.PageID == page.PageID
                  select new
                  {
                      PermissionName = pg, 
                      ObjectPermission = op
                  }).SingleOrDefault();

This will enable you to say:-

if (pageObject.PermissionName.FooBar == "golden goose") Application.Exit();

For example :-)

Examples related to c#

• How can I convert this one line of ActionScript to C#? • Microsoft Advertising SDK doesn't deliverer ads • How to use a global array in C#? • How to correctly write async method? • C# - insert values from file into two arrays • Uploading into folder in FTP? • Are these methods thread safe? • dotnet ef not found in .NET Core 3 • HTTP Error 500.30 - ANCM In-Process Start Failure • Best way to "push" into C# array

Examples related to linq

• Async await in linq select • How to resolve Value cannot be null. Parameter name: source in linq? • What does Include() do in LINQ? • Selecting multiple columns with linq query and lambda expression • System.Collections.Generic.List does not contain a definition for 'Select' • lambda expression join multiple tables with select and where clause • LINQ select one field from list of DTO objects to array • The model backing the 'ApplicationDbContext' context has changed since the database was created • Check if two lists are equal • Why is this error, 'Sequence contains no elements', happening?