/// <summary> /// Inserts an entity into table "T" and returns identity id asynchronously. /// </summary> /// <param name="connection">Open SqlConnection</param> /// <param name="entityToInsert">Entity to insert</param> /// <param name="queryBuilder"></param> /// <returns>Identity of inserted entity</returns> public static async Task <object> InsertAsync(this IDbConnection connection, BaseModel entityToInsert, QB queryBuilder) { using (connection) { connection.Open(); var cmd = queryBuilder.Insert(entityToInsert); return(await connection.ExecuteScalarAsync(cmd, entityToInsert)); } }
/// <summary> /// Inserts an entity into table "T" and returns identity id. /// </summary> /// <param name="connection">Open SqlConnection</param> /// <param name="entityToInsert">Entity to insert</param> /// <param name="queryBuilder"></param> /// <returns>Identity of inserted entity</returns> public static object Insert(this IDbConnection connection, BaseModel entityToInsert, QB queryBuilder) { using (connection) { connection.Open(); var cmd = queryBuilder.Insert(entityToInsert); return(connection.ExecuteScalar(cmd, entityToInsert)); } }