Entity Framework Core - Knowledge Base (KB)
4283 results in tag: c#
Entity Framework and Migration with multiple schemas in a single Context
I am developing a multi-tenant application with Entity Framework Code First. Each tenant will have a different schema in the database, but the application will have a single Context and model for all tenants. ...The Entity Framwork 6 is able to use multi...
asked by Bruno Albano de Souza
Entity Framework 6 Unable to retrive metadata
I am using EF 6 pre-3....Product model:...namespace ProductStore.Models { public class Product { [ScaffoldColumn(false)] public int Id { get; set; } [Required] public string Name { get; set; } public decimal...
asked by Alvin
Entity Framework 6 Code First function mapping
I want integrate Entity Framework 6 to our system, but have problem....I want to use Code First. I don’t want to use Database First *.edmx file for other reasons....I use attribute mapping [Table], [Column] and this works fine...Database has many User-D...
asked by Alexey
Entity Framework (6) Performance Optimisation advice
I have an ADO.Net Data Access layer in my application that uses basic ADO.Net coupled with CRUD stored procedures (one per operation e.g. Select_myTable, Insert_myTable). As you can imagine, in a large system (like ours), the number of DB objects required...
asked by Obsidian Phoenix
How to cancel an async query the right way
This is a follow up question to ...this question.......I'm trying to load data from my database which will take 5-10 seconds, but I want the GUI to stay responsive and also it should be cancellable....private CancellationTokenSource _source; public IEnum...
asked by Staeff
ObjectContext.GetObjectType(e.GetType()) not returning the entity type of the POCO entity
The ...ObjectContext.GetObjectType Method... should return "the entity type of the POCO entity associated with a proxy object of a specified type"...So how come in my code it just returns the proxy?...I am using entity framework 6 release candidate... ...
asked by Colin
How entity framework works for large number of records?
I see already a un-answered question ...here on.......My question is -...Is EF really production ready for large application?...The question originated from these underlying questions -...EF pulls all the records into memory then performs the query operat...
asked by Abhijeet
Unable to cast Anonymous Type from 'System.Linq.IQueryable' to 'System.Data.Entity.Core.Objects.ObjectQuery'
The following query was working well with EF5 but gives me error with EF6. I use DbContext and CodeFirst....Error raised with EF6:...Unable to cast the type 'System.Linq.IQueryable...1[[<>f__AnonymousType5...4[[System.Int32, mscorlib, Version=4.0.0.0, Cul...
asked by Dan
ODAC 12c and Entity Framework 6
Can anyone tell me if the ...Oracle Data Access Components 12c... is compatible with Entity Framework 6? The Oracle website is a nightmare for documentation and cannot find any references on how to resolve this....I have an existing project which I am tr...
asked by philreed
Test Entity Framework Find Method
I'm trying to test the that the ...GetSystem(int id)... method in ...SystemService.cs... returns the correct value, but can't seem to figure out how to get everything to play well together. It seems that no matter what I do, ...GetSystem()... always retur...
asked by Steve Platz
The type initializer for 'System.Data.Entity.Internal.AppConfig' threw an exception on a Sub Website
I have 2 websites, one is a sub directory of another but is an Application ex: /root & /root/Services...They both use Entity Framework 6.x but the child website is throwing ...The type initializer for System.Data.Entity.Internal.AppConfig' threw an except...
asked by Brian
Save detached object graph using Entity Framework code first causes Primary Key violation
I'm trying to save an object graph of POCOs I have mapped to EF6 using Code First fluent notations....Upon saving the object graph however, I stumble upon primary key violation exceptions....The object graph is quite simple:...One ...Issue... can contain ...
asked by Robert Sirre
Does System.Data.Sqlite support Entity Framework 6?
I looked around, and it was not clear if you could use it in EF6. I've found a compatible version on a blog (...here...) but I'd rather use the official one if possible. Is it compatible or not? ...Thanks!
asked by It'sNotALie.
How can set a default value constraint with Entity Framework 6 Code First?
In a legacy app, most string properties can't be null and need to have a default value of string.empty....I know it's possible to do this with migrations, but I'm looking for a way to do this using the fluent configuration interface:... protected overr...
asked by ECC-Dan
Dynamic MySQL database connection for Entity Framework 6
I wish to pass a dynamic connection string to the entity framework context. I have over 150 schemas which are identical (one per account) and I would like to select the connection as such:...ApplicationDbContext db = new ApplicationDbContext("dbName"); ..
asked by francisco.preller
IsRowVersion can only be configured for Byte array properties
I recently upgraded from EntityFramework 5 to 6 via the NuGet updater. Everything seemed to go well and I built and executed my application. When I tried to retrieve the first entity from the database, I received this error:...The property 'UpdatedDate' i...
asked by Sparafusile
How do I make a group of multi-select checkboxes in ASP.Net MVC with c# enum?
I need to make a set of checkboxes where a user can select 1 or more markets. I would normally use a set of boolean values to accomplish this as it would be pretty strait forward and in my mind not take up much space in the database or take that long to l...
asked by Bob
Issue with many-to-many relationship + TPH inhertitance in Entity Framework 6
I am running into an issue with EF6, though I'm fairly sure that this applies to previous versions that support this type of mapping. I fear I know the answer to the question at hand, but I hope that I am doing something wrong, or there is a better workar...
asked by joelmdev
Mapping a long data property to int in database
In all of the examples that I've seen use ...int32...s as the IDs. That's not always practical in production environments. Several of our databases have identity IDs that are in the realm of ...int64...s, so our practice is to always use ...long... for ou...
asked by krillgar
Entity Framework 6 and output parameter
First time working with EF in general and wanted to call a stored procedure. So far I've added the stored procedure in a model (.edmx) and I believe that it's calling properly but I'm not sure how to add the output parameter. ...This is what the stored p...
asked by Mike Stone