
Untitled
By: a guest on
Jul 15th, 2012 | syntax:
None | size: 1.52 KB | hits: 12 | expires: Never
How to sort in a related table in ASP.NET MVC3
var userQuery = from u in _db.Users
where u.Username.ToLower().Contains(search.ToLower())
|| u.FirstName.ToLower().Contains(search.ToLower())
|| u.LastName.ToLower().Contains(search.ToLower())
select u.FirmID;
var query = from f in _db.Firms
where f.Name.ToLower().Contains(search.ToLower())
|| f.Keyword.ToLower().Contains(search.ToLower())
|| f.KeywordList.ToLower().Contains(search.ToLower())
|| userQuery.Contains(f.ID)
select f;
// order by firm name
query = query.OrderBy(f => f.Name);
public class User
{
[Key]
public int ID { get; set; }
public string Username { get; set; }
public string FirstName { get; set; }
public string LastName { get; set; }
public int FirmID { get; set; }
[ForeignKey("FirmID")]
public virtual Firm Firm { get; set; }
}
public class Firm
{
[Key]
public int ID { get; set; }
public string Keyword { get; set; }
public string KeywordList { get; set; }
public string Name { get; set; }
public virtual ICollection<User> Users { get; set; }
}
query.OrderBy(f => f.Name).Select(aux => new
{
Firm = aux.Firm,
Users = aux.Users.OrderBy( x => x.Username )
})
query.OrderBy(f => f.Name)
.ToList()
.ForEach(f => f.Users = f.Users.OrderBy(u => u.LastName).ToList() );
@foreach (var user in Model.Users.OrderBy(u => u.LastName)) { }