zzz projects Entity Framework 6 EF 6
Home EF Core Articles Knowledge Base Online Examples
  • Home
  • EF Core
  • Articles
  • Knowledge Base
  • Online Examples

Entity Framework 6 - Knowledge Base (KB)

5 results in tag: select

In Linq to Entities / Entity SQL with type conversion, choose Max.

I'm trying to create some CRUD functionality for a legacy database and using the Entity Framework as an ORM tool. One table, 'Sites', has a Guid type 'Id' column which is never seen by the users and an integer type 'SiteId' which the users use to identitf...
entity-framework linq max select type-conversion
asked by andrej351

In Entity Framework, just the first row of a table is returned.

Background:...Entity Framework 4, with SQL Server 2008...Problem:...I have a table ...Order.... Each row has a column ...Timestamp.... ...The user can choose some time in past and I need to get the ...Order... closest to the specified time, but that had o...
c# entity-framework select sql-server-2008
asked by Kornelije Petak

Entity Framework GROUP and SUM

I want to select sum of all (paid) prices of an order item for each customer. Here is SQL command: ...SELECT c.name,SUM(oi.price * oi.count) from customer c JOIN order o ON c.id=o.customer_id JOIN order_item oi ON o.id=oi.order_id JOIN bill b ON b.id=oi.b...
entity-framework group-by linq-to-entities select sum
asked by quin16

Select only a single column in LINQ

The EntityModel is defined as: ...Personnel has a link to a Country...When executing this code in LinqPad, I see that the SQL which is generated is not optimized (all fields are returned) in the first query ? What am I missing here or doing wrong ?...Quer...
entity-framework linq select
asked by Stef Heyenrath

WCF OData Service stored procedure call generates "Operation could destabilize the runtime" error with $select option

I've been trying to call a stored procedure through Entity Framework and WCF Data Services (OData). It returns an entity not a complex type. Following walkthroughs found all over the web (like this ...one...), I came up with this code inside my service:..
entity-framework-5 entity-framework-6 odata select wcf-data-services
asked by iamnobody

Page 1 of 1
  • 1

Prime Library

Performance

  • Entity Framework Extensions
  • Entity Framework Classic
  • Bulk Operations
  • Dapper Plus

Expression Evaluator

  • C# Eval Expression
  • SQL Eval Function
More Projects...

Related

  • EF Extensions Online Benchmark
  • WIN an EF Extensions license
  • EF6 BatchSaveChanges for only $79
Save your entities 20× faster with EF Extensions
SaveChanges vs BulkSaveChanges

EF Extensions
Try for free now
Get monthly updates by subscribing to our newsletter!
SUBSCRIBE!