示例#1
0
        public async Task <Customer> CreateAsync(string firstName, string lastName)
        {
            var sql = "INSERT INTO customer.Customers (firstname, lastname) values (@firstName, @lastName) returning id;";

            using (var conn = new Npgsql.NpgsqlConnection(ConnectionString))
            {
                var id = await conn.ExecuteScalarAsync <int>(sql, new { firstName, lastName });

                return(await GetAsync(id));
            }
        }
 /// <summary>
 /// Execute scalar
 /// </summary>
 /// <param name="conn"></param>
 /// <param name="cmdText"></param>
 /// <param name="parameters"></param>
 /// <param name="commandType"></param>
 /// <returns></returns>
 public static Task <object> ExecuteScalarAsync(this NpgsqlConnection conn, string cmdText, NpgsqlParameter[] parameters, CommandType commandType)
 {
     conn.CheckNull(nameof(conn));
     return(conn.ExecuteScalarAsync(cmdText, parameters, commandType, null));
 }
 /// <summary>
 /// Execute scalar
 /// </summary>
 /// <param name="conn"></param>
 /// <param name="cmdText"></param>
 /// <param name="commandType"></param>
 /// <param name="transaction"></param>
 /// <returns></returns>
 public static Task <object> ExecuteScalarAsync(this NpgsqlConnection conn, string cmdText, CommandType commandType, NpgsqlTransaction transaction)
 {
     conn.CheckNull(nameof(conn));
     return(conn.ExecuteScalarAsync(cmdText, null, commandType, transaction));
 }