static IList <T> GetListByQuery <T>(string query)
{
using (var db = new vinabits_homeclickEntities())
{
var result = db.Database.SqlQuery <T>(query).ToList();
return(result);
}
}
public static string GetTableName <T>() where T : class
{
using (var db = new vinabits_homeclickEntities())
{
var result = db.GetTableName <T>();
return(result);
}
}
public static IList <Category> GetProductCategories(CategoryTypes type, int productId)
{
using (var db = new vinabits_homeclickEntities())
{
var query = string.Format(@"select c.*
from[ProductDanhSachProducts_CategoryDanhSachCategories] pc
join[Category] c on c.Id = pc.DanhSachCategories and c.Category_typeId = '{0}'
where pc.DanhSachProducts = '{1}'", (int)type, productId);
var categories = db.Database.SqlQuery <Category>(query).ToList();
return(categories);
}
}