public static List <GetPost> List()
{
string sql = @"SELECT * FROM [dbo].[Articles]";
DataSet ds = DB.Query(sql);
return(DB.GetAllPostDS(ds));
}
public static List <GetPost> List()
{
string sql = @"SELECT Articles.ID, Title, Content, Category, Articles.ByUser, Name, Articles.OnDate, Firstname, Lastname, Photo
FROM [dbo].[Articles]
INNER JOIN Users ON Users.Id = Articles.ByUser
INNER JOIN Categories ON Categories.Id = Articles.Category";
DataSet ds = DB.Query(sql);
return(DB.GetAllPostDS(ds));
}
