public Customer GetCustomerByUniqueidentifier(string uniqueidentifier)
{
using (var db = new AdventureWorksLT2012_DataEntities())
{
return db.Customer.FirstOrDefault(u => u.rowguid.ToString() == uniqueidentifier);
}
}
public Address GetAddressesByUserId(int userId)
{
using (var db = new AdventureWorksLT2012_DataEntities())
{
var customerAddress = db.CustomerAddress.FirstOrDefault(x=>x.CustomerID==userId);
if(customerAddress==null) return new Address();
var result = db.Address.FirstOrDefault(x => x.AddressID == customerAddress.AddressID);
return result;
}
}
