public List <DTO.EF.Person> SelectAll()
{
using (var context = new DTO.EF.Test1Entities1())
{
try
{
var q = context.People.ToList();
return(q);
}
catch (Exception ex)
{
ErrorMessage = ex.Message + "==>" + ex.TargetSite;
throw;
// ErrorMessage = ex.Message + "==>" + ex.TargetSite;
// return ErrorMessage;
}
finally
{
context.Dispose();
}
}
}
/// <summary>
/// Insert:ParameterBinding
/// </summary>
/// <param name="fName"></param>
/// <param name="lName"></param>
/// <param name="phoneNumber"></param>
/// <param name="telNumber1"></param>
/// <param name="telNumber2"></param>
/// <param name="homeAddress"></param>
public void Insert(string fName, string lName, string phoneNumber, string telNumber1, string telNumber2, string homeAddress)
{
using (var context = new DTO.EF.Test1Entities1())
{
try
{
var people = new DTO.EF.Person();
people.LName = lName;
people.FName = fName;
people.PhoneNumber = phoneNumber;
people.TelNumber1 = telNumber1;
people.TelNumber2 = telNumber2;
people.HomeAddress = homeAddress;
context.People.Add(people);
context.SaveChanges();
}
catch (DbEntityValidationException ex)
{
Console.WriteLine(string.Format("DbEntityValidationException:{0}", ex.Message));
}
catch (Exception ex)
{
ErrorMessage = ex.Message + "==>" + ex.TargetSite;
throw;
// ErrorMessage = ex.Message + "==>" + ex.TargetSite;
// return ErrorMessage;
}
finally
{
context.Dispose();
}
}
}
