Entity Framework 6 - Knowledge Base (KB)
6940 results
Random order of LINQ to Entities
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 exactly 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
JSON serialize Entity Framework objects
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
In entity framework, how can I query for null values?
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
In Linq to SQL with Entity Framework, how do you compare solely Date without Time in DateTime types?
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
"Before using ItemsSource, the Items collection must be empty."
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 does it take 30 seconds for Entity Framework to load data while the resulting query only takes 1/2 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: The given metadata resource could not be loaded.
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 database changes (.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 a DateTime Property's default value to DateTime. Now you're in the System. Default Value Attribute for ComponentModel
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
Entity Framework for ADO.Net Multiple instances of IEntityChangeTracker cannot refer to the same entity object.
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
Entity Framework and the repository pattern (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
Generic Repository Error in Entity Framework
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
What is the difference between an entity and an object?
Is there a difference between the terms Entity and Object?
asked by mrblah
Entity Framework: Retrieving newly inserted context objects
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
What is the best way to connect an Entity Framework object that isn't a database object?
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
Entity Framework Context Mocking
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 use an EntityDataSource to invoke a Stored Procedure?
(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
Using sql server compact edition to insert OR update (upsert).
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
Entity State Change
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
