static int Insert_should_assign_identity_to_new_entity()
{
// arrange
Module4.IContactRepository repository = CreateRepository();
var contact = new Module4.Contact
{
FirstName = "Joe",
LastName = "Blow",
Email = "*****@*****.**",
Company = "Microsoft",
Title = "Developer"
};
var address = new Module4.Address
{
AddressType = "Home",
StreetAddress = "123 Main Street",
City = "Baltimore",
StateId = 1,
PostalCode = "22222"
};
contact.Addresses.Add(address);
// act
//repository.Add(contact);
repository.Save(contact);
// assert
Debug.Assert(contact.Id != 0);
Console.WriteLine("*** Contact Inserted ***");
Console.WriteLine($"New ID: {contact.Id}");
return(contact.Id);
}
public Module4.Address Add(Module4.Address address)
{
var sql =
"INSERT INTO Addresses (ContactId, AddressType, StreetAddress, City, StateId, PostalCode) VALUES(@ContactId, @AddressType, @StreetAddress, @City, @StateId, @PostalCode); " +
"SELECT CAST(SCOPE_IDENTITY() as int)";
var id = this.db.Query <int>(sql, address).Single();
address.Id = id;
return(address);
}
public Module4.Address Update(Module4.Address address)
{
this.db.Execute("UPDATE Addresses " +
"SET AddressType = @AddressType, " +
" StreetAddress = @StreetAddress, " +
" City = @City, " +
" StateId = @StateId, " +
" PostalCode = @PostalCode " +
"WHERE Id = @Id", address);
return(address);
}
