Entity Framework 6 - Knowledge Base (KB)
6940 results
Use DBContext with Oracle
I have searched the web and reviewed similar questions on Stack Overflow but I can not figure how to use the Oracle Managed Data Provider with a DbContext from a C# .Net 4.6 Console Application....This works for Sql Express ...class SqlDBContext1 : DbCont...
asked by vscoder
Entity Framework - Invalid Column Name 'User_ID"
I have a project written with ...C#... on the top of ASP.NET MVC 5 framework. I am using Entity Framework 6.2 ORM to interact with my database....I have the following 2 entity classes...public class User { [Key] public int Id { get; set;} publ...
asked by Junior
EntityFramework - .Select() Projection with anonymous object throws a Exception that I am not sure how to interpret
Exception...The Include path expression must refer to a navigation property defined on the type. Use dotted paths for reference navigation properties and the Select operator for collection navigation properties....This is the call causing this. ...Vignett...
asked by beggarboy
XAF Look up property displays correctly in listview but is null in detailview
I have the following business classes ( simplified )...public class Customer { Customer() { } public int Id {get;set;} public string Name {get;set;} public virtual Category {get;set;} } Public Class Category { public int Id {get;set;} p...
asked by Kirsten Greed
IncludeFilter multiple levels not working
Having problems with this IncludeFilter and including multiple levels. I'm using Entity Framework 6 Plus....This is the example they provide ...https://entityframework-plus.net/query-include-filter... under the ...Load multiple levels... heading....This ...
asked by Bluebaron
Entity framework resiliency and retry logic
I get a lot of errors when adding data to my Azure SQL server like this:...An exception has been raised that is likely due to a transient failure. If you are connecting to a SQL Azure database consider using...I can see on following link you can impleme...
asked by Thomas Segato
Entity Framework 6 Make relation on behalf of ID or enum value
In my DB I have a relation between some tables that is relying on either an ID or an Enum value. Here is the structure:...Employee...ID ...Name...RoleEnum (CEO, Leader, Developer)...Virtual list of Advantages...Advantages...ID...Description...EmployeeAdva...
asked by PNR
ASP.NET MVC Auto generate integer number
Good day, a really newbie developer here....I Have a form and it have a entity of "QueueNumber" Can someone show me how to code so that when ever i save my form it generates automatically QueueNumber + the Prefix, btw my prefix entity is in another class ...
asked by Carlo Toribio
Garbage collection for Entity Framework dbcontext c#
just wondering if I dispose my dbcontext object correctly here or should I be using the using block instead?...public class RepoBankAccount : IBankAccount { private AppDbContext db = null; public RepoBankAccount() { this.db = new AppD...
asked by Steve
How To Use Effort in Conjunction with Reverse Poco Generator
So I am Visual Studio 2017, EF6 and I am using this T4 template ...https://marketplace.visualstudio.com/items?itemName=SimonHughes.EntityFrameworkReversePOCOGenerator... to generate my context class ...Being a big fan of testing I already have 100% covera...
asked by julian guppy
Automapper v8 is not ignoring navigation properties of EF (Entity Framework) class
Below is the code for Automapper profile:...public class MyMappingProfile: Profile { public MyMappingProfile() { Mapper.Initialize(cfg => { cfg.CreateMap<MyModelClass, MyEntityClass>() .ForMember(dest => dest.Na...
asked by Expert Freelancer
In SQL Server, Entity Framework 6 vs. Dapper vs. stored procedures vs. requests
I have EF with LINQ with SQL Server in my project a long time....And I was searching for a way to improve a performance of my requests to DB. And I read a lot of about Dapper and Procedures, that it's faster than EF. I added Dapper to project, I added pro...
asked by olegl19
Web API JSON deserialization converting value issue
I am trying to insert JSON data into my models via EF 6. I am getting this error;... Inner Exception is {0}System.ArgumentException: Could not cast or convert from System.String to EPINMiddleWareAPI.Models.Serial. konum: Newtonsoft.Json.Utilities.Co...
asked by Cenk
No Complex Type created from new stored procedure, EF database first
I can not figure out why EF6 will not create a complex type for my stored procedure. I am using the database-first approach. ...I created a new stored procedure in SSMS 2017. Open my EDMX, right clicked "Update Model From Database," check my stored proced...
asked by Ben-Coden
Entity Framework - only edmx without templates
We would like to add only .EDMX files without corresponding .tt files for context and entities. There is multiple reasons for this, but long story short - we would like to be able to have .EDMX and be able to refresh it from DB when needed....Currently if...
asked by katit
Entity Framework slow first db connection
First connection to database in my app (EF 6.2, code first) is very slow, is there a way to modify ...OnModelCreating... part of my ...DbContext...:...protected override void OnModelCreating(DbModelBuilder modelBuilder) { var typesToRegister = Ass...
asked by Mac
Unable to Save User Accounts After Renaming Identity Tables In Asp.Net MVC Core App
I have managed to customize Identity table names and IdentityUser as described on this forum. My problem is that I'm unable to save user accounts thereafter and I get the error below:...Cannot use table App Users for entity type App Users since it is bein...
asked by yaddly
'Option not supported' error when using SQL Server with MySQL
I'm trying to retrieve data from both MySQL and SQL Server on the same console application. I manage to retrieve data from MySQL, however when I trying to retrieve data from SQL Server, I got ...System.ArgumentException: 'Option not supported. Parameter n...
asked by Noctis Tong
EntityType' is a variable but is used like a type when use the Reflection
i need to register all entity in ...DbContext... ....i create a ...extention... for register automatic all Entity with ...Reflection... :... public static void RegisterAllEntity<BaseType>(this DbModelBuilder builder, params Assembly[] assmblies) { ...
asked by mr-dortaj
Entity framework error ... property could not be set to 'System.Int16' value
I have this Class:...public class PayTerm { public int PayTermExternalKey { get; set; } public int Code { get; set; } public string Name { get; set; } } ...In the Database, ...PayTermExternalKey... is ...smallint... because it is related to th...
asked by r.pezzolati
Page 335 of 347
