Entity Framework Core - Knowledge Base (KB)
16 results in tag: entity-framework-6.1
How are people unit testing with Entity Framework 6, should you bother?
I am just starting out with Unit testings and TDD in general. I have dabbled before but now I am determined to add it to my workflow and write better software....I asked a question yesterday that kind of included this, but it seems to be a question on its...
asked by Modika
How can you add a navigation property on a view in EF 6.1 CodeFirst
Let's make a case to explain my problem. ...MyTable1...+id...+myTable2Id...MyTable2...+id...MyView1...+id...+myTable2Id...MyView1 exists in the case, from data from the MyTable1. Now i want to create a Navigation property from my EF6.1 Code first approach...
asked by Spons
Entity Framework -- caching an object in memory across multiple contexts
I am using Entity Framework 6 with a tenant-segregated application. I determine the tenant by looking at the request host name, then use it throughout the application, set it in tenant-owned records, et cetera....Every context gets disposed at the end of...
asked by Casey
Upgraded EF5 to EF 6 and now get "Cannot find the object because it does not exist or you do not have permissions."
I've got a main web application project using a referenced class library that uses EF code first. In the main web application I've also got several .edmx files. This is a production app with real data using automatic migrations (MigrateDatabaseToLatestVer...
asked by SventoryMang
When executing a command, parameters must be exclusively database parameters or values
I am not able to retrieve the ouput value back. I get the following exception:...Execption Type: InvalidOperationException:...When executing a command, parameters must be exclusively database parameters or values....C# Code Method...public Student Insert...
asked by Ernie R.
Foreach loop through table seems to load every row and run out of memory
I am trying to dump a database table using the Entity Framework in C# using EF Version 6.1.1. I was expecting the foreach loop to load each row one at a time but it gradually loads every row and then runs out of memory....foreach (Quote L in context.Quote...
asked by Mythlandia
Entity Framework 6: is there a way to iterate through a table without holding each row in memory
I would like to be able to iterate through every row in an entity table without holding every row in memory. This is a read only operation and every row can be discarded after being processed. ...If there is a way to discard the row after processing that ...
asked by Mythlandia
Entity Framework Code-First - Define the Non-clustered key for this EntityType
I Have defined an entity class with a key, but I don,t want that key be cluster because I have another cluster index in my entity, but I received an error when I add an Index attribute to my model,...Can anybody tell me that how can I define a ...Non-Clus...
asked by Mahdi Khalili
Entity Framework 6 where did key and column attributes go
I'm upgrading from Entity Framework 4.1.0.0 to Entity Framework 6 and I'm having a really hard time tracking where all of the old classes went and what namespace things are in these days....I've got a class that looks like this and was using these attribu...
asked by Josh R
EntityFramework Stored Proc Function Import is it possible to read async?
I'm using EF 6.1.1 and Database First. When I import a stored proc into the edmx and generate the DBContext it looks like this:...return ((IObjectContextAdapter)this).ObjectContext.ExecuteFunction<TestSP_Result>("TestSP", params[]...) ...That returns an O...
asked by oscarmorasu
Entity Framework Include related table when table is empty
I'm reading data from database to gridview's datasource. My Table2 can be empty. When I try to bind columns from Table2 gives me error that doesn't contain that column. I checked the data that was coming from query. There is Table2 but not columns. Just C...
asked by TurKorsaN
Migration to MySQL and Schema specified is not valid
I have migrated SQL2012 Database to MySQL, apart from one issue....I get the following error when I connect to the MySQL Database....An exception occurred while initializing the database. ...InnerException for details: Schema specified is not valid. Erro...
asked by RentUrApp
Adding Inner Join to DbScanExpression in Entity Framework Interceptor
I'm trying to use an Entity Framework CommandTree interceptor to add a filter to every query via a DbContext....For the sake of simplicity, I have two tables, one called "User" with two columns ("UserId" and "EmailAddress") and another called "TenantUser"...
asked by Mark Johnson
Preventing "'System.DateTime' failed because the materialized value is null"
I would like to prevent this from happening but in a different way rather than setting type of DateCreated to nullable DateTime....The full exception reads like this:...The cast to value type 'System.DateTime' failed because the materialized value is nu...
asked by Jakub Holovsky
Mocking Entity Framework 6 ObjectResult with Moq
How can I mock the Entity Framework 6 ObjectResult with Moq so that I can unit test my code that relies on an EF database connection?...Having read numerous questions and answers along these lines, and gleaned many nuggets from what I've read, I've implem...
asked by Jim Speaker
Persisting and retrieving serialized entity property with Entity Framework 6.1 code first
Example: Let's say I have these three classes. ...Foo... is a proper Entity Framework entity with a DbSet whereas I want my EF DbContext to be unaware of ...Bar... and ...Baz... because I have flagged Foo's Bar property with my made up ...SerializedColumn...
asked by Jeremy Cook
Page 1 of 1