Linq query to get rows from id 200 to 500 out of 1000 id's (rows) orderby id and where notification! =False

Question

1.00/5 (1 vote)

See more:

Quote:
table users contains 1000 records with ID 1-1000 and i need to retrieve only from id 200 to 500 records

What I have tried:

List<string> users = ((from tbl in helper.GetTables<TBL_Users>()
                                where tbl.aaaa == true && tbl.bbbb != true
                                 orderby tbl.Id descending
                                 select new {
                                           tbl.email,
                                      }).Skip(start).Take(end - start);

Posted 26-Feb-20 0:10am

Arfat M

Updated 26-Feb-20 0:39am

Add a Solution

2 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Maciej Los · Answer 1 · 2020-02-26T00:22:00

In a short:

C#

var emails = your_data
    .Where(x=> x.aaaa==true && tbl.bbbb==false)
    .OrderByDescending(x=>x.Id)
    .Skip(199)
    .Take(301)
    .Select(x=>x.email)
    .ToList();

Above query skips 199 records and gets 301 records to get a range of 200-500.
Note: it does NOT mean that you will get ids from 200 to 500!

phil.o · Answer 2 · 2020-02-26T00:40:00

Solution 2

You can try

C#

List<string> emails = (from user in helper.GetTables<TBL_Users>()
                      where user.aaaa && !user.bbbb
                         && user.Id >= 200 && user.Id <= 500
                      orderby user.Id descending
                      select user.email
                      ).ToList();

Posted 26-Feb-20 0:40am

phil.o

Updated 26-Feb-20 0:56am

v2

Comments

Arfat M 26-Feb-20 6:53am

Cannot implicitly convert type 'System.Collections.Generic.List<anonymoustype#1>' to 'System.Collections.Generic.List<string>'

phil.o 26-Feb-20 6:55am

Solution revised.

Maciej Los 26-Feb-20 11:07am

I believe you're right.
5ed!

phil.o 26-Feb-20 11:29am

Thanks :)