Breaking News: Grepper is joining You.com. Read the official announcement!

dapper insert record when entity properties have the same names as the SQL columns.

Combative Cicada answered on September 30, 2021 Popularity 1/10 Helpfulness 1/10

answer dapper insert record when entity properties have the same names as the SQL columns.

dapper insert record when entity properties have the same names as the SQL columns.

Comment

using (IDbConnection db = new SqlConnection(ConfigurationManager.ConnectionStrings["myDbConnection"].ConnectionString))
{
    string insertQuery = @"INSERT INTO [dbo].[Customer]([FirstName], [LastName], [State], [City], [IsActive], [CreatedOn]) VALUES (@FirstName, @LastName, @State, @City, @IsActive, @CreatedOn)";

    var result = db.Execute(insertQuery, customerViewModel);
}

Popularity 1/10 Helpfulness 1/10 Language whatever

Source: stackoverflow.com

Tags: dapper entity insert names properties record sql whatever when

Link to this answer
Share Copy Link