Retrieve data with the linq query

Question

I have table StudentAccount with columns Code,Amount,Description,Valid Period for selected period there might be same code and description write a linq query that gets the data Code/Description needs to be unique for the selected date range.( the date is in the format 1/1/1990-1/1/1991)

    public IEnumerable<StudentAccount> StudentAccountdata
    {
        get { return Context.StudentAccount.Where(q=>q.Active).OrderBy(q =>q.Description).ToList(); }            
    }

how can u say like this..if u can answer it fine..dont make silly comments..problem can be small or big — GANI
– GANI, Commented Feb 25, 2012 at 3:50

OGHaza · Accepted Answer · 2014-02-15 14:24:50Z

1

Use IEqualityComparer like so:

public class StdComparer : IEqualityComparer<StudentAccount>
{
    #region IEqualityComparer<StudentAccount> Members

    public bool Equals(StudentAccount x, StudentAccount y)
    {
        return x.Code == y.Code && x.Description == y.Description;
    }

    public int GetHashCode(StudentAccount obj)
    {
        return 0;
    }

    #endregion
}

Then

public IEnumerable<StudentAccount> StudentAccountdata
{
    get { return Context.StudentAccount.Where(q=>q.Active && 
                    q.Date >= BeginDate && 
                    q.Date <= EndDate)
                   .OrderBy(q =>q.Description).Distinct(new StdComparer()); }
}

edited Feb 15, 2014 at 14:24

OGHaza

4,7957 gold badges26 silver badges30 bronze badges

answered Feb 25, 2012 at 11:21

Amen Ayach

4,3481 gold badge26 silver badges23 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Retrieve data with the linq query

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related