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