public static GetPost Detail(int id) { string sql = @"SELECT * FROM [dbo].[Articles] WHERE Id = @p1"; DataSet ds = DB.Query(sql, id); return(DB.GetPostDS(ds)); }
public static GetPost Detail(int id) { 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 WHERE Articles.Id = @p1"; DataSet ds = DB.Query(sql, id); return(DB.GetPostDS(ds)); }