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);
}