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)); }