I have two tables that is needed to be joined in Three-Tier Architecture. The code below works fine and as follows:
DAL:
public static IEnumerable<Demo> GetCategories()
{
using (SMPURCHASEEntities db = new SMPURCHASEEntities())
{
var lst = (from c in db.Demo
select c).ToList();
return lst;
}
}
public static IEnumerable<ApprovalStatus> GetCategory()
{
using (SMPURCHASEEntities db = new SMPURCHASEEntities())
{
var lst = (from c in db.ApprovalStatus
select c).ToList();
return lst;
}
}
BLL:
public static IEnumerable<Demo> GetCategories()
{
return Category_Provider.GetCategories();
}
public static IEnumerable<ApprovalStatus> GetCateg ...
Go to the complete details ...