Entity Framework 6 - Knowledge Base (KB)
6940 results for:
Only get specific columns
Can I make my EF objects retrieve only specific columns in the sql executed? If I am executing the below code to retrieve objects, is there something I can do to only get certain columns if wanted?...public IEnumerable<T> GetBy(Expression<Func<T, bool>> ...
asked by Brian
EF Query With Conditional Include
I have two tables: a WorkItem table, and a WorkItemNote table. How do I return a WorkItem and all of the WorkItemNotes that meet a certain criteria?...I think this should be simple, almost like a conditional "Include", right?
asked by Esteban Araya
Entity framework with "Group By" and/or "Order by"
Say we've got a project that allows user to download things. On the main page, I want to show the Most downloaded files ordered by the number of download! All that using EF....How can i do this !! I've tried many things with Group By (Its a nightmare when...
asked by Simon Dugré
Entity Framework ObjectContext -> raw SQL calls to native DBMS
I have an app using the ADO.NET entity framework (the VS2008 version, not the newer, cooler one) and I need to be able to make a call down to the underlying DBMS (it's postgres) in order to call some SQL that Entity Framework doesn't support. ...Is there ...
asked by Justin Grant
SQL Server Compact Edition with Entity Framework
I try to use SQL Server Compact Edition with Entity Framework in Visual Studio 2008 SP1. Here's what I do:...1) I create a new project, of type Console Application....2) I right-click on the project, select Add->New Item....3) I choose to add a Local Data...
asked by Nitramk
Can Entity Framework deal with multiple result sets (each from joined tables) from a stored procedure?
In Linq to SQL, I can't find an easy way to deal with multiple result sets returned by a stored procedure where each result set is from table joins. Each result set does not map directly to a table. (can't change this behavior). For now, it seems using a ...
asked by Tony_Henrich
It has a DefiningQuery but no InsertFunction element... err
This thing is driving me crazy, and the error is quite meaningless to me:...Unable to update the EntitySet 'TableB' because it has a DefiningQuery and no element exists in the element to support the current operation....My tables are put like this:...Ta...
asked by Palantir
How to do a Bulk Insert -- Linq to Entities
I cannot find any examples on how to do a Bulk/batch insert using Linq to Entities. Do you guys know how to do a Bulk Insert?
asked by Luke101
How to use the default Entity Framework and default date values
In my SQL Server database schema I have a data table with a date field that contains a default value of...CONVERT(VARCHAR(10), GETDATE(), 111) ...which is ideal for automatically inserting the date into the new record when manually entering records in to ...
asked by Justin
Getting a count of returns seen by a RESTful request
So, I'd like to know how many results I'll be getting back from a RESTful uri GET request. I don't know of any way to do that at this point. Is there a way to do that? Since REST just throws out properties, I don't know if it is able to take a count of...
asked by georryan
Entity Framework Updating with Related Entity
I'm using the EF to try to update an entity with ASP.NET. I'm creating an entity, setting it's properties then passing it back to the EF on a separate layer with the ID so the change can be applied. I'm doing this because I only store the ID of the entity...
asked by Echilon
Locking a table with a select in Entity Framework
I need to do something like this ...select * from myTable with (xlock,holdlock) ...using Entity Framework. Is this possible? I've opened a ...TransactionScope... with the ...Serializable... isolation level but my selects are not locking the tables. I'd l...
asked by Manuel FelÃcio
Entity Framework 4 vs NHibernate
A lot has been talked about Entity Framework first version on the web (also on stackoverflow) and it is clear that it was not a good choice when we already have better alternative like NHibernate. But I can't find a good comparison of Entity Framework 4 a...
asked by Deependra Solanky
Entity Framework - Select specific columns and return strongly typed without losing cast
I'm trying to do something similar to ...this post... where I don't pull back all columns from a particular entity, however my framework makes use of inheritence and I lose scope of the entity type after it's been cast to an anonymous type. ...The structu...
asked by XVargas
The conversion of a datetime2 data type to a datetime data type resulted in an out-of-range value
I have an ASP.NET MVC application where I am editing an existing database to update a paticular field, ...DateTime.... My database has 4 fields, two of which are ...DateCreated... and ...DateModified.... When I try to update the field, I want to keep ...D...
asked by Anthony Forloney
Should I Use Entity Framework, DataSet or Custom classes?
I am really having a hard time here. I need to design a "Desktop app" that will use WCF as the communications channel. Its a multi-tiered application (DB and application server are the same, the client goes through the internet cloud)....The application i...
asked by user203252
Running sql in entity framework?
Is there any way to run a sql statement straight from the entity framework generated calls? Or will I have to create a procedure then call that via the entity framework?
asked by David
Quickly Testing Database Connectivity within the Entity Framework
[...I am new to ADO.NET and the Entity Framework, so forgive me if this questions seems odd....]...In my WPF application a user can switch between different databases at run time. When they do this I want to be able to do a ...quick... check that the dat...
asked by Rodney S. Foley
Linq to entities - searching in EntityCollection navigation properties
We have classes...public Invoice: EntityObject { public EntityCollection<InvoicePosition> Positions { get {...}; set{...}; } ... } public InvoicePosition: EntityObject { public string GroupName { get {...}; set{...}; } } ...We are given ...IQ...
asked by LukLed
Entity Framework - Saving Changes to Related Objects in Detached State
I'm using the Northwind database as an example for this post where I am having a problem saving detached entities back to the database using the entity framework....I have the following two methods to get me the territories and the regions:... static L...
asked by Ben
Page 13 of 347
