Linq with entity framework

c# entity-framework linq

Question

I'm new to LINQ and Entity Framework and would appreciate some advice on the following scenario.

I have a entity model with two tables.

Travel_Request and Resource

Sample Fields

Travel_Request

Request_ID
Resource_ID

Resource

Resource_ID
Resource_Name

I would like to add the Resource_Name to the list when returning all the TRAVEL_REQUESTS

Thanks in advance

1
3
9/4/2013 2:50:33 PM

Fastest Entity Framework Extensions

Bulk Insert
Bulk Delete
Bulk Update
Bulk Merge

Accepted Answer

Hi you need to use the Linq join:

var data = from t in Travel_Request
       join r in Resource on t.Resource_ID equals r.Resource_ID
       select new 
              { 
                 RequestId = t.Request_ID,
                 ResourceId = t.Resource_ID,
                 ResourceName = r.Resource_Name
              };

If you already have an EF association then it could simply be:

var data = from t in Travel_Request
    select new
           {
                 RequestId = t.Request_ID,
                 ResourceId = t.Resource_ID,
                 ResourceName = t.Resource.Resource_Name
           };
7
9/4/2013 3:06:26 PM

Popular Answer

You will have to create a new object something like this.

var data = Travel_Request.Select(s=> new { Resource_Name = s.Recource.Resource_Name, Request_ID = s.Request_ID, Resource_ID = s.Resource_ID}).ToList();

As long as I've understood the question correctly this will work.

Rob White

Related Questions

What are Java's Linq and Entity Framework equivalents?

Having played with Linq (to SQL and Objects) as well as the Entity Framework from Microsoft recently, I was wondering what the non-.Net (specifically Java) equivalents are?
entity-framework java linq
asked by Colin Desmond

Is it feasible to do an outside join with Linq to Entity Framework?

There are many examples of outer join using Linq to Sql, all of them hinging on ...DefaultIfEmpty()... which is not supported with Linq to Entity Framework....Does this mean that outer join is not possible with Linq to Entity using .NET 3.5 (I understand that DefaultIfEmpty is coming with 4.0 --- but that's not an option at this time for me)...Coul...
entity-framework left-join linq
asked by Ralph Shillington

LINQ to Entity Framework using a MySQL adapter to convert String to Long

I have a table with a column of type ...varchar... where the majority of rows have numerical looking values, that is, each string contains nothing but the digits 0 through 9....+------+ | n | +------+ | 123 | | 234 | | BLAH | -- This row is an exception to the rule. | 456 | | 789 | +------+...In MySQL, this works: ...SELECT * FROM t WHERE n...
entity-framework linq linq-to-entities mysql type-conversion
asked by Walt Stoneburner

How do I retrieve the row number using Entity Framework and LINQ?

Hope someone can help me out here as I'm a little stuck....I'm building a service in front of a hiscore database for a game....The database have the following two tables:...CREATE TABLE [dbo].[PB_HiscoreEntry] ( [Id] UNIQUEIDENTIFIER NOT NULL, [PlayerId] UNIQUEIDENTIFIER NOT NULL, [Score] INT NOT NULL, ...
count entity-framework row
asked by Mads Laumann

Performance of Linq on entity framework vs SQL stored procedure

We are using the Entity Framework to fetch some data. The LINQ query is using multiple joins, as shown in the code below. I have been asked to change this to a SQL Stored Procedure because its faster. How can i optimize this LINQ code and why is it slow?...var brands = (from b in entity.tblBrands join m in entity.tblMateri...
c# entity-framework linq performance
asked by V.K.

How to use a Func in an expression with Linq to Entity Framework?

I am trying to write a linq to entity extension method that takes a Func to select a property Id and compare it against a list of ids....Classes...public class A { public int AId { get; set; } } public class B { public int BId { get; set; } } ...Extension Method...public static IQueryable<T> WithId<T>(this IQueryable<T> entities, Func<...
c# entity-framework expression func linq
asked by David

How do I do a table join using LINQ and entity framework 6?

I have three tables: Exam > Objectives > ObjectiveDetails...Here's what they look like:...public class Exam { public Exam() { this.Objectives = new HashSet<Objective>(); } public int ExamId { get; set; } public int SubjectId { get; set; } public virtual ICollection<Objective> Objectives { get; set; } } public class ...
asp.net c# entity-framework linq sql
asked by user1464139

Filtering include items in LINQ and Entity Framework

I currently have this LINQ/EF code in my application:...var rootCategoryItem = DatabaseContext.Categories .Include("SubCategories") .OrderBy(c => c.CategoryOrder) .Single(c => c.CategoryId == 1); ...I know in EF you can't filter Included items yet, and I can write s...
c# entity-framework linq
asked by binks

Use PredicateBuilder in SelectMany LINQ to Entity Framework

It's the first time I write here on stackoverflow....I would like to use PredicateBuilder in a LINQ query with SelectMany....I enter my code...public async Task<List<Articolo>> OttieniElencoArticoliFiltratoComplessoAsync (ExpressionStarter<Articolo> predicateArticolo, ExpressionStarter<ArticoloFornitore> predicateFornitore, Expr...
c# entity-framework-6 linq linqkit predicatebuilder
asked by Antonio Pisarra

Convert String to linq condition Entity Framework core

I have a Combobox with different conditions like "=", ">=", "<=" ... and dates. I would like to use the conditions in strings to compare dates. It's possible to convert the operators in string format to logical operators to compare dates on linq query to Oracle Database? I need dynamic conditions based on strings like "=", ">=" ...
.net-core entity-framework-6 entity-framework-core-2.1 linq
asked by JuanDYB

Fastest Entity Framework Extensions

Bulk Insert
Bulk Delete
Bulk Update
Bulk Merge
View more on Stack Overflow

Prime Library

Performance

Expression Evaluator

More Projects...

Related

Licensed under: CC-BY-SA with attribution
Not affiliated with Stack Overflow
Licensed under: CC-BY-SA with attribution
Not affiliated with Stack Overflow