Newly inserted row value to be returned using entity framework core 2.0

asp.net-core entity-framework-core

Question

I am using ExcecuteSqlCommand for update and insert, which will return an integer but i want the entire inserted or updated row. Using FromSql the updation and insertion are not happening, i am able to fetch only the items. How can i achieve this?

1
0
3/5/2019 9:13:19 AM

Fastest Entity Framework Extensions

Bulk Insert
Bulk Delete
Bulk Update
Bulk Merge

Accepted Answer

If you are using EF , you'd better insert/update via DbContext :

https://www.learnentityframeworkcore.com/dbcontext/adding-data

https://www.learnentityframeworkcore.com/dbcontext/modifying-data 

Book book = new Book();
book.Title = "Title1";

_context.Book.Add(book);
await _context.SaveChangesAsync();

var id = book.BookId;

EF will help you fill the enitity after operations , include the new added identity column value.

0
3/6/2019 7:59:10 AM

Related Questions

Override sql default value on insert using Entity Framework Core (7)

I have a table with a column [CreatedAtIsoUtc] that sets a Sql Server default value...migrationBuilder.CreateTable( name: "CurrentAccountLedger", columns: table => new { Id = table.Column<Guid>(nullable: false, defaultValueSql: "newsequentialid()"), CreatedAtIsoUtc = table.Column<D...
entity-framework entity-framework-core
asked by sf.

Entity Framework Core 2.0 Scaffold-DbContext returns Build Error

I had the same problem today, please be sure ...any project in your solution... does not fail to build. Examine output folder after you got this error. I think one of your projects in your solution fails to build.
.net core entity-framework-core
asked by Mehmet Ali Sepici

I am having trouble creating DB in SQL Server Express with Entity Framework Core 2.0

I needed to run:...Update-Database ...I went through this last year: ...Why is dotnet ef not able to create a database against SQL Server Express?...It seems I never learn.
entity-framework-core sql-server-express
asked by Sam

Entity Framework Core 2.0 Many to Many Inserts before primary key is generated

I'm trying to create an entity object that has many to many relationships with other entities. The relationships are indicated as follows....public class Change { // Change Form Fields [Key] [DatabaseGenerated(DatabaseGeneratedOption.Identity)] public int ChangeId { get; set; } public string ChangeTitle { get; set; } public...
asp.net-core-2.0 asp.net-core-webapi c# entity-framework-core sql-server-2012
asked by David

How to specify default property values for owned entity types in Entity Framework Core 2.0?

Assuming you understand what EF Core ...Default Values... are for, and just looking for equivalent of ...Entity<T>().Property(...)... equivalent. ...The owned entities are always configured for each owner type by using the ...ReferenceOwnershipBuilder<TEntity,TRelatedEntity>... class methods. To access this class you either use the result of ...Ow...
asp.net entity-framework-core
asked by Ivan Stoev

Entity Framework Core Code First changing added entities values before save causes identity insert error

The documentation of ...ToObject... method states:...Creates an instance of the entity type and sets all its properties using the values from this object....In other words, the method creates a ...new... entity instance and populates it with the current values of the tracked entity....Note that at the time you add entity to the context, EF generate...
.net-core asp.net-core c# ef-code-first entity-framework-core
asked by Ivan Stoev

How to increase insert speed using Bulk insert using AddRange and then SaveChanges in Entity Framework

I have used Entity Framework to insert data into SQL tables....For larger number of records, instead of ...Add()..., I have used ...AddRange()... and called ...SaveChanges()... later....It's still taking too much time to insert records - are there any solutions to increase the speed? ..._Repository.InsertMultiple(deviceDataList); await _Repository...
c# c#-4.0 entity-framework entity-framework-6
asked by Neo

Why am I getting duplicate ID columns when using Table Per Hierarchy in Entity Framework Core?

In your model any Base can be added to the ...Accounts... of an Elevated, and so every Base needs and ElevatedId Foreign Key property. Only a Standard can have an Elevated ...Parent.... ...And a Standard can have an Elevated ...Parent... and belong to the ...Accounts... of a ...different... Elevated.
c# entity-framework entity-framework-core
asked by David Browne - Microsoft

Entity Framework Core Insert multiple entities similar to SQL single insert statement

How do you manage to get the same effect as SQL simple...INSERT INTO myTable VALUES (X), (Y), (Z),..... ...and so on?
entity-framework-core performance
asked by Jackal

I am unable to store data into database using Entity Framework Core and Ajax

Add ...contentType: "application/json"... to specify the type of data you're sending.If you do not specify it,it would use ...application/x-www-form-urlencoded; charset=UTF-8... by default:... $.ajax({ contentType: "application/json", }); ...And add ...[FromBody]... to your action:...[HttpPost] public async Task<IActionResult> Sa...
asp.net asp.net-core asp.net-core-2.0 asp.net-core-mvc entity-framework-core
asked by Rena

Fastest Entity Framework Extensions

Bulk Insert
Bulk Delete
Bulk Update
Bulk Merge
View more on Stack Overflow

Prime Library

Performance

Expression Evaluator

More Projects...

Related

Licensed under: CC-BY-SA with attribution
Not affiliated with Stack Overflow
Licensed under: CC-BY-SA with attribution
Not affiliated with Stack Overflow