public void TestExecFromSql() { const string sql = "DELETE FROM dbo.Customer WHERE CustomerId=-99"; Assert.DoesNotThrow(() => _db.Exec(sql)); }
/// <summary> /// Insert a data row into table Customer from entity class Customer object /// </summary> public void AddNew(Customer item) { const string sql = "INSERT INTO \"Customer\"(\"CustomerId\", \"FirstName\", \"LastName\", \"Company\", \"Address\", \"City\", \"State\", \"Country\", \"PostalCode\", \"Phone\", \"Fax\", \"Email\", \"SupportRepId\") " + "VALUES (@CustomerId, @FirstName, @LastName, @Company, @Address, @City, @State, @Country, @PostalCode, @Phone, @Fax, @Email, @SupportRepId)"; var cmd = new NpgsqlCommand(sql); NpgsqlParameter p; // Parameter @CustomerId p = new NpgsqlParameter("@CustomerId", NpgsqlDbType.Integer) { Value = item.CustomerId }; cmd.Parameters.Add(p); // Parameter @FirstName p = new NpgsqlParameter("@FirstName", NpgsqlDbType.Varchar) { Value = item.FirstName }; cmd.Parameters.Add(p); // Parameter @LastName p = new NpgsqlParameter("@LastName", NpgsqlDbType.Varchar) { Value = item.LastName }; cmd.Parameters.Add(p); // Parameter @Company p = new NpgsqlParameter("@Company", NpgsqlDbType.Varchar) { Value = item.Company }; cmd.Parameters.Add(p); // Parameter @Address p = new NpgsqlParameter("@Address", NpgsqlDbType.Varchar) { Value = item.Address }; cmd.Parameters.Add(p); // Parameter @City p = new NpgsqlParameter("@City", NpgsqlDbType.Varchar) { Value = item.City }; cmd.Parameters.Add(p); // Parameter @State p = new NpgsqlParameter("@State", NpgsqlDbType.Varchar) { Value = item.State }; cmd.Parameters.Add(p); // Parameter @Country p = new NpgsqlParameter("@Country", NpgsqlDbType.Varchar) { Value = item.Country }; cmd.Parameters.Add(p); // Parameter @PostalCode p = new NpgsqlParameter("@PostalCode", NpgsqlDbType.Varchar) { Value = item.PostalCode }; cmd.Parameters.Add(p); // Parameter @Phone p = new NpgsqlParameter("@Phone", NpgsqlDbType.Varchar) { Value = item.Phone }; cmd.Parameters.Add(p); // Parameter @Fax p = new NpgsqlParameter("@Fax", NpgsqlDbType.Varchar) { Value = item.Fax }; cmd.Parameters.Add(p); // Parameter @Email p = new NpgsqlParameter("@Email", NpgsqlDbType.Varchar) { Value = item.Email }; cmd.Parameters.Add(p); // Parameter @SupportRepId p = new NpgsqlParameter("@SupportRepId", NpgsqlDbType.Integer) { Value = item.SupportRepId }; cmd.Parameters.Add(p); _db.Exec(cmd); }
/// <summary> /// Insert a data row into table Customer from entity class Customer object /// </summary> public void AddNew(Customer item) { const string sql = "INSERT INTO [Customer] ([CustomerId], [FirstName], [LastName], [Company], [Address], [City], [State], [Country], [PostalCode], [Phone], [Fax], [Email], [SupportRepId]) " + "VALUES (@CustomerId, @FirstName, @LastName, @Company, @Address, @City, @State, @Country, @PostalCode, @Phone, @Fax, @Email, @SupportRepId)"; var cmd = new SqlCommand(sql); SqlParameter p; // Parameter @CustomerId p = new SqlParameter("@CustomerId", SqlDbType.Int) { Value = item.CustomerId }; cmd.Parameters.Add(p); // Parameter @FirstName p = new SqlParameter("@FirstName", SqlDbType.NVarChar) { Value = item.FirstName }; cmd.Parameters.Add(p); // Parameter @LastName p = new SqlParameter("@LastName", SqlDbType.NVarChar) { Value = item.LastName }; cmd.Parameters.Add(p); // Parameter @Company p = new SqlParameter("@Company", SqlDbType.NVarChar) { Value = item.Company }; cmd.Parameters.Add(p); // Parameter @Address p = new SqlParameter("@Address", SqlDbType.NVarChar) { Value = item.Address }; cmd.Parameters.Add(p); // Parameter @City p = new SqlParameter("@City", SqlDbType.NVarChar) { Value = item.City }; cmd.Parameters.Add(p); // Parameter @State p = new SqlParameter("@State", SqlDbType.NVarChar) { Value = item.State }; cmd.Parameters.Add(p); // Parameter @Country p = new SqlParameter("@Country", SqlDbType.NVarChar) { Value = item.Country }; cmd.Parameters.Add(p); // Parameter @PostalCode p = new SqlParameter("@PostalCode", SqlDbType.NVarChar) { Value = item.PostalCode }; cmd.Parameters.Add(p); // Parameter @Phone p = new SqlParameter("@Phone", SqlDbType.NVarChar) { Value = item.Phone }; cmd.Parameters.Add(p); // Parameter @Fax p = new SqlParameter("@Fax", SqlDbType.NVarChar) { Value = item.Fax }; cmd.Parameters.Add(p); // Parameter @Email p = new SqlParameter("@Email", SqlDbType.NVarChar) { Value = item.Email }; cmd.Parameters.Add(p); // Parameter @SupportRepId p = new SqlParameter("@SupportRepId", SqlDbType.Int) { Value = item.SupportRepId }; cmd.Parameters.Add(p); _db.Exec(cmd); }