Entity Framework Core - Knowledge Base (KB)

How can I use entity framework to query the database server for the current datetime?

I have an entity with a ModifiedDateTime property which I want to be updated with the current datetime from the database instead of the "application" server executing the application....Every time I want to update or add a person to my datebase on SQL Ser...

Check for any modifications that need to be saved.

Is there a way to find out whether there are unsaved changes in my entity context, in the Entity Framework?

With EF 4.1 Fluent Code First, you may inherit tables per type.

I have a pretty straight forward set of database tables, like:...Vehicle Id RegNo Car Id (FK of Vehicle.Id) OtherStuff Bike Id (FK of Vehicle.Id) MoreStuff ...My class model is as you'd expect: with Vehicle being an abstract class, and then Car an...

Upgrade EF 4 EDMX to EF 6

My application is using a database first EDMX in EF 4. I would like to upgrade everything to EF 6. After getting EF 6 with NuGet I had to make a lot of changes to my classes that are using my EF model, because namespaces have been changed in EF 6. Then I ...

Two foreign keys with same Navigation Property?

I am new to Entity Framework so I don't know much about it. Currently I am working on My College Project, in that Project I came across a problem where I have two foreign keys refers to the Same column in another table. how can I handle this situation. ..

ObjectStateManager vs Entry().State

What is the difference between this two and which is preferred? using change object state or ...Entry().state...db.ObjectStateManager.ChangeObjectState(employeeFromDB, EntityState.Modified) ...vs...context.Entry(employeeFromDB).State = EnitityState.Modifi...

how to insert parent child while doing entityframework.bulkinsert?

I am using Entityframework 6, I am trying to insert a parent-child kind of data in the database. I am using Entityframework.BulkInsert to insert data. I have ...autoIncrement int primary key... in all the tables...My object is as follows :... var paren...

Entity Framework get user from contex in saveChanges

i have two projects in my solution, UI as mvc and class project for entitiy model code first. I have severall entities in my model but now I need to extend them by new audit fields where I need to save who changed entity. I added new interface...public i...

How to pass null values into stored procedure via Entity Framework?

I am using an ASP.NET MVC 4 application with Entity Framework....I want to pass null values conditionally, let's say if pass value into ...DeptID... then it should list of values for only passed ...DeptID..., and if pass ...DeptID = NULL... then it should...

Error occured while Entity Framework generating model

I'm having very few tables in my edmx (not more than 20)...I'm having big list of stored procedures (may be more than 1k) in my edmx....EF version 5.0...Whenever I try to add/update model from DB it always throw this error, can any one help me out with th...

An exception of type 'System.Data.Entity.Core.EntityException' occurred in EntityFramework.SqlServer.dll but was not handled in user code

I am new to ASP.NET MVC, I am facing this exception, the connection string looks perfect but still, the exception is raised, appreciate if anyone give me why is happening....Thank you guys...Model 1...namespace MVCTwice.Models { public class StudentCo...

Entity framework- EF Code First Select foreign key

Model:...public class Address { [Key] public long AddressId { get; set; } public string Street { get; set; } public string Town { get; set; } public string State { get; set; } public string Country { get; set; } } public class ...

EntityFramework: Database.CurrentTransaction becomes null when exception occurs

Today I faced strange issue with Entity Framework. Consider following class:...public partial class Entities { ... public void DocumentUpdateForSync(string userLogin, IEntrySync document) { var timeEntry = document as Domain.Documents.TimeEntry; ...

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 ...