public static async Task InsertNewOfferBankAsync(Offer offer, Bank bank)
{
using (var context = new BankLoansEntities())
{
//add instances to context
context.Banks.Add(bank);
context.Offers.Add(offer);
// add instance to navigation property
offer.Banks.Add(bank);
//call SaveChanges from context to confirm inserts
await context.SaveChangesAsync();
}
}
public static async Task InsertExistingOfferBankAsync(int offerId, int bankId)
{
using (var context = new BankLoansEntities())
{
var offer = new Offer {
PK_OfferId = offerId
};
context.Offers.Add(offer);
context.Offers.Attach(offer);
var bank = new Bank {
PK_RegNumber = bankId
};
context.Banks.Add(bank);
context.Banks.Attach(bank);
offer.Banks.Add(bank);
await context.SaveChangesAsync();
}
}
