Entity Framework 6 - Knowledge Base (KB)
6940 results
Linq to Entities, random order
How do i return matching entities in a random order?... Just to be clear this is Entity Framework stuff and LINQ to Entities....(air code)...IEnumerable<MyEntity> results = from en in context.MyEntity where en.type == myTyp...
asked by NikolaiDante
What is datetime2?
I´ve got this in a INSERT statment to MSSQL 2008...System.Data.SqlClient.SqlException: The conversion of a datetime2 data type to a datetime data type resulted in an out-of-range value.
asked by Glenn
Serialize Entity Framework objects into JSON
It seems that serializing Entity Framework objects into JSON is not possible using either WCF's native DataContractJsonSerializer or ASP.NET's native JavaScript serializer. This is due to the reference counting issues both serializers reject. I have also ...
asked by Program.X
How can i query for null values in entity framework?
I want to execute a query like this... var result = from entry in table where entry.something == null select entry; ...and get an ...IS NULL... generated. ...Edited: After the first two answers i feel the need t...
asked by Adrian Zanescu
How to compare only Date without Time in DateTime types in Linq to SQL with Entity Framework?
Is there a way to compare two ...DateTime... variables in ...Linq2Sql... but to disregard the Time part....The app stores items in the DB and adds a published date. I want to keep the exact time but still be able to pull by the date itself....I want to co...
asked by Sruly
"Items collection must be empty before using ItemsSource."
I'm trying to get images to display in a WPF ListView styled like a WrapPanel as described in this old ATC Avalon Team article: ...How to Create a Custom View.......When I try to populate the ListView with a LINQ-to-Entities queried collection of ADO.NET ...
asked by Zack Peterson
Why is Entity Framework taking 30 seconds to load records when the generated query only takes 1/2 of a second?
The executeTime below is 30 seconds the first time, and 25 seconds the next time I execute the same set of code. When watching in SQL Profiler, I immediately see a login, then it just sits there for about 30 seconds. Then as soon as the select statement...
asked by NotDan
MetadataException: Unable to load the specified metadata resource
All of a sudden I keep getting a ...MetadataException... on instantiating my generated ...ObjectContext... class. The connection string in App.Config looks correct - hasn't changed since last it worked - and I've tried regenerating a new model (edmx-file)...
asked by J. Steen
Updating your edmx to reflect changes made in your db (.net linq-to-entities)
So I have my edmx made. ...Then I change my database a little bit, changing a column to from being a NOT NULL to allowing NULL....I go into my edmx, right click and choose "Update Model from Database"...Now I go into my program and it hasnt actually upda...
asked by Stuck In Baghdad
Setting the default value of a DateTime Property to DateTime.Now inside the System.ComponentModel Default Value Attrbute
Does any one know how I can specify the Default value for a DateTime property using the System.ComponentModel DefaultValue Attribute?...for example I try this:...[DefaultValue(typeof(DateTime),DateTime.Now.ToString("yyyy-MM-dd"))] public DateTime DateCrea...
asked by REA_ANDREW
ADO.Net Entity Framework An entity object cannot be referenced by multiple instances of IEntityChangeTracker
I am trying to save my contact, which has references to ContactRelation (just the relationship of the contact, married, single, etc) and Country. But everytime I try to save my contact, which is validated I get the exception "ADO.Net Entity Framework An e...
asked by Peter
Using the repository pattern with Entity Framework (mvc storefront)
Can anyone give a helping hand? I've been watching the videos for the MVC storefront and have created my own website using these techniques i.e. DDD, Repository pattern but I wish to use Entity Framework....In the Interfaces it returns IQueryable but with...
asked by Mark Smith
Entity Framework Generic Repository Error
I am trying to create a very generic generics repository for my Entity Framework repository that has the basic CRUD statements and uses an Interface. I have hit a brick wall head first and been knocked over. Here is my code, written in a console applica...
asked by Jeff Ancel
Is there a difference between an Entity and a object?
Is there a difference between the terms Entity and Object?
asked by mrblah
Entity Framework: Re-finding objects recently added to context
I am using the entity framework and I'm having a problem with "re-finding" objects I just created... basically it goes like this: ...string theId = "someId"; private void Test() { using(MyEntities entities = new MyEntities()) { EntityObject o = n...
asked by dovholuk
How can I attach an Entity Framework object that isn't from the database?
I have a complete separation of my Entity Framework objects and my POCO objects, I just translate them back and forth......i.e:...// poco public class Author { public Guid Id { get; set; } public string UserName { get; set; } } ...and then I have an...
asked by sontek
Mocking Entity Framework Context
I'm using the entity framework to access my database and I want to mock the database context inside my unit tests so that I can test my middle tier classes free of their dependency on real data. I know that I'm not the first to ask about this ...(Mocking ...
asked by Dav Evans
Can I call a Stored Procedure from an EntityDataSource?
(ASP.net 3.5, C#, SQL Express 2008)...I want to have a Web Form, where I can search for "Solutions" (my table) using a keyword entered by the user and after the result comes back and populates a GridView. ...I already have parts of this search via a store...
asked by miccet
Performing Insert OR Update (upsert) on sql server compact edition
I have c# project that is using sqlserver compact edition and entity framework for data access. I have the need to insert or update a large amount of rows, 5000+ or more to the db, so if the key exists update the record if not insert it. I can not find ...
asked by RBear
Change Entity State
I currently have an entity model with a bunch of deleted items, the state is deleted. Is there a way to "undelete" them? I know which Items I want to undelete, but I don't know how to undelete the items. Ideally I'd like to get it back to an unchanged sta...
asked by JohnathanKong
Page 5 of 347
