Entity Framework 6 - Knowledge Base (KB)
6940 results
While binding, the ObjectContext object was disposed of.
This is my code:...public class JobsRepository:BaseNewsletterRepository { public IEnumerable<Job> GetJobs() { var jobs = Newsletterctx.Jobs.Include("Info").OrderBy(o => o.JobID); return jobs.AsEnumerable(); } } publi...
asked by shlomjmi
Using the 'Contains' Clause in Entity Framework instead of the 'IN' SQL Clause
I am working on a tag cloud application. There are 3 database tables....Content...: ContentID, Text...Tag...: TagID, Name...TagRelation...: TagRelationID, TagID, ContentID...The code below is wrong. Because 'Contains' clause doesn't take a list of paramet...
asked by gavss
The method 'System' is not recognized by LINQ to Entities. Linq.IQueryable
When I try to call my repository in a Sub Select, I got this error.... IGrpTextRepository rep = new GrpTextRepository(); var query = new DetailViewModel { ViewDet = (from gh in _db.Grp select new MultiDe...
asked by Jean-Francois
On an Entity Framework query, filter the "Includes" table.
This is for Entity Framework for .NET 3.5:...I have the need to query a table and include a collection of the "many" table of a one-to-many relationship. I'm trying to filter that collection as part of the query - I'm pretty new to Entity Framework, and ...
asked by Joe Enos
[extension] methods for LINQPad
Does anyone have a complete list of LINQPad extension methods and methods, such as....Dump() SubmitChanges()
asked by Bent Rasmussen
When utilizing entity framework with Visual Studio 2010.net 4.0, you get a 'datetime2' issue.
Getting this error:...System.Data.SqlClient.SqlException : The conversion of a datetime2 data type to a datetime data type resulted in an out-of-range value....My entity objects all line up to the DB objects....I found only a single reference to this erro...
asked by KevinDeus
In Entity Framework 4.NET, how do you update an entity?
my code is something like this:...public class Program { [STAThread] static void main() { DataAccessClass dal = new DataAccessClass(); List<Person> list = dal.GetPersons(); Person p = list[0]; p.LastName = "Changed!"; dal.Update(p); } } pub...
asked by losingsleeep
For the 'providerInvariantName' argument, Entity Framework expects a non-empty string.
Ok, this may not be related to EF. I am trying to use the code-first feature and following is what I wrote:-...var modelBuilder = new ModelBuilder(); var model = modelBuilder.CreateModel(); using (AddressBook context = new AddressB...
asked by Ashish Gupta
How to Repair In nopCommerce, the ConnectionString attribute has not been initialized.
I'm trying to integrate nopCommerce into a third party system but am hitting a problem when I try to access any nopCommerce pages. Because I'm integrating with a third party system I've had to merge web.configs and copy all files over. I have a standalone...
asked by Matt Brailsford
Entity Framework 4 Code First demonstrates how to declare a one-to-one connection (POCO)
How to declare a one to one relationship using Entity Framework 4 Code First (POCO)?...I found ...this question (one-to-one relationships in Entity Framework 4) ..., but the article that the answer references was not useful (there is one line of code that...
asked by Paul Hiles
Connection Pooling and Entity Framework
I've recently started to use the Entity Framework 4.0 in my .NET 4.0 application and am curious about a few things relating to pooling....Connection pooling as I know is managed by the ADO.NET data provider, in my case that of MS SQL server. Does this app...
asked by Noldorin
Where should SetInitializer be placed in Entity Framework CTP4?
I am attempting to add Entity Framework, code first, to an MVC application that's been running with test data, using the CTP4 preview....I am currently getting this error:...The model backing the 'SchedulerContext' context has changed since the database w...
asked by Cynthia
Entity Framework: How to appropriately handle SQL constraint-related errors
I use Entity Framework to access my SQL data. I have some constraints in the database schema and I wonder how to handle exceptions that are caused by these constraints....As example, I get the following exception in a case where two users try to add an (a...
asked by driAn
A big Entity Framework Diagram may be exported.
I have a fairly large Entity Diagram. I tried to export it to an image, unfortunately because it's so large the image comes out all pixelated....See this link ...http://connect.microsoft.com/VisualStudio/feedback/details/534574/edmx-model-image-export-pix...
asked by Stephen Lacy
Cannot locate VS2010's ADO.NET Entity Model Browser Window
I want to update my ADO.NET Entities Framework Model from the database, but I cannot find the ...Entity Model Browser Window.... There is an example of how to update my model ...here..., but I cannot find how to open the model browser. Could someone pleas...
asked by John Fischer
Call a stored procedure using RIA Services.
I am using RIA Services with Silverlight and Entity Framework. I want to call a stored procedure and map the results to a datagrid. What is the best way to do this? The output of the stored procedure doesn't map to any table design....I found the followin...
asked by Craig Schwarze
What is the source of the Linq error: This procedure cannot be converted to a store expression?
I have a bunch of Linq to Entity methods that had the same select statement, so I thought I would be clever and separate that out into it's own method to reduce redundancy... but when i attempted to run the code, i got the following error......this method...
asked by Rod Johnson
How to utilize the Html ShortDate string format. TextBoxFor
Using Entity Framework with MVC2, I have a series of date textboxes, that I want to display data from the model in a short date format, but I have to use Html.TextBoxFor in order for the update code to work (Having tried using HTML.Textbox the data never...
asked by JTrott
When using UpdateModel with LINQ to Entities in ASP.NET MVC 2, "The model of type 'XYZ' could not be updated" (.NET 3.5)
I have a model set up using LINQ to Entities and have code working that adds to the database as expected. However, I can't get UpdateModel to work when I am using .NET 3.5....[HttpPost] public ActionResult Edit(Site.Models.XYZ xyz) { try { ...
asked by SamWM
Inserts/deletes/updates are not visible in SQL Profiler.
When I run the profiler while running my application, it only seems to show SELECTs, not INSERTs or anything that changes the database. Yet my database is being updated, so those commands must be being executed. What do I have to do to get it to show upda...
asked by Cynthia
