Entity Framework 6 - Knowledge Base (KB)
22 results in tag: savechanges
Unable to save Entity Framework Inherited types
I have implemented some table-per-type inheritance in my data model (basically have a ...BaseEntity... type with all the base information for my items and a ...Employer... type that inherits from the ...BaseEntity... item). Everything appears to be set u...
asked by ChrisHDog
How to rollback a transaction in Entity Framework
string[] usersToAdd = new string[] { "asd", "asdert", "gasdff6" }; using (Entities context = new Entities()) { foreach (string user in usersToAdd) { context.AddToUsers(new User { Name = user }); } try { context.SaveChan...
asked by Shimmy
Entity Framework won't SaveChanges on new entity with two-level relationship
I'm building an ASP.NET MVC site using the ADO.NET Entity Framework. I have an entity model that includes these entities, associated by foreign keys:...Report(ID, Date, Heading, Report_Type_ID, etc.)...SubReport(ID, ReportText, etc.) - one-to-one relation...
asked by Tim Rourke
Check if an insert or update was successful in Entity Framework
In ADO.NET, ExecuteNonQuery() "For UPDATE, INSERT, and DELETE statements, the return value is the number of rows affected by the command" (...http://msdn.microsoft.com/en-us/library/system.data.sqlclient.sqlcommand.executenonquery.aspx...)...In EF v1, con...
asked by dev
When should I call SaveChanges() when creating 1000's of Entity Framework objects? (like during an import)
I am running an import that will have 1000's of records on each run. Just looking for some confirmation on my assumptions:...Which of these makes the most sense:...Run ...SaveChanges()... every ...AddToClassName()... call....Run ...SaveChanges()... every...
asked by John Bubriski
EntityFramework show entities before saving changes
Entity Framework ObjectSet with its method ToList shows just saved entities. That means, when I call...context.AddToCustomers(myNewCust); ...and then (without calling SaveChanges)...myDataGrid.DataContext = context.Customers.ToList(); ...the DataGrid does...
asked by Mix Net
EF4/WCF SaveChanges() Best Practice
This is how we implement a generic Save() service in WCF for our EF entities. A TT does the work for us. Even though we don't have any problems with it, I hate to assume this is the best approach (even if it might be). You guys seem pretty darn bright and...
asked by Jerry Nixon
Entity FrameWork - Exception on SaveChanges
I have this code saving a simple Entity:...ExecutionEngineEntities db = new ExecutionEngineEntities(); Task task = new Task(); task.Message = "Test"; task.Result = "Test"; task.Name = "Test"; db.Tasks.AddObject(task); db.SaveChanges(); ...This is the exc...
asked by SexyMF
DbContext SaveChanges() - Detecting updated entities
I have overridden the SaveChanges() method in the Entity Framework 4.1 DbContext class....My override looks like this:...public override int SaveChanges() { IEnumerable<DbEntityEntry> modifiedEntityEntries = ChangeTracker.Entries().Where( e => e.Stat...
asked by FantasticJamieBurns
Can't SaveChanges with Entity Framework in ASP.Net MVC 3 project
Studying asp.net mvc 3 + EF code-first. I am new to both. My example is trivial, but I still can't make it work. Missing something simple and obvious......I've got a class:... public class Product { [HiddenInput(DisplayValue = false)] public int...
asked by horgh
Entity Framework 5 Using SaveChanges to add audit log
Seems straight forward override SaveChanges in EF to add an audit logger. See the ApplyAuditLogging method to set the audit properties (created, createdby, updated, updatedby) below.... public override int SaveChanges() { var autoDetectChang...
asked by user1538467
Custom atomic UPDATE commands inside SaveChanges()
For various reasons I need to be able to do several custom SQL ...UPDATE... commands when I call ...SaveChanges... on a ...DbContext.... I want this to happen atomically so either both the regular ...SaveChanges... and the SQL succeeds, or neither does...
asked by JulianR
Saving in entity framework
I have read ...this... article and still misunderstanding key moments. Don't we need call..._context.SaveChanges() ...in every Delete/Update/... operations?...If I change property of any entity does ...SaveChanges()... submitted result to database or I mu...
asked by NET
How to get id from entity for Auditlog in Entity Framework 6
I know it's several similar posts out there, but I cannot find any with a solution to this issue....I want to add a (sort of) AudioLog when adding, changing or deleting entities (soft-delete) in Entity Framework 6. I've overridden the SaveChanges and beca...
asked by baddaydaddy
Entity Framework Db.SaveChanges() not working?
Can u tell me what is the problem?
asked by PsyGnosis
Calling SaveChanges when database objects have not been changed
I am coding a MVC 5 internet application with EF6 and I have a question about what happens when the context.SaveChanges() method is called....Does the DbContext object store the CRUD actions that occur, such that if the SaveChanges() method is called, and...
asked by user3736648
Entity Framework 6, Transaction Scope, Context and SaveChanges
Question pertains to transaction scope and ...context.SaveChanges().... If I'm processing a million records with a ...foreach..., and I save after every, let's say, 1000 records by calling ...context.SaveChanges()... inside a transaction scope and somethi...
asked by Dee
Invalid ObjectName xxx.dbo.xxx, but it is there
I do not understand, why the following Code does not work:... //Database connection using (var db = new KassenautomatEntities()) { //Create Model var quittung = new WAWI_Quittungen { ...
asked by Christian Gollhardt
Using TransactionScope with Entity Framework 6
What I can't understand is if its possible to make changes to the context and get the changes in the same transaction before its commited....This is what I´m looking for:...using (var scope = new TransactionScope(TransactionScopeOption.Required)) { ...
asked by Marcus Höglund
Entity framework 6 ObjectMaterialized event and SaveChanges override
I'm using Model First approach and I have one abstract class MyEntity which have few flags with attribute [NotMapped]. All my entities inherits from MyEntity. Inside the ObjectMaterialized event handler I set those flags to indicate the entity is material...
asked by Steve Li
Page 1 of 2
