LINQ execute SQL query with output parameter

Question

I need to execute SQL query with output parameter.

For example,

 SELECT @Count = COUNT(*) FROM dbo.SomeTable
 SELECT * FROM SomeTable WHERE Id BETWEEN 1 AND 10

After quering I need to know the @Count value. How can I do it with LINQ without using a stored procedure?

Thank you.

Stefanvds · Accepted Answer · 2010-09-06 12:52:46Z

1

int value = yourDB.SomeTable.Count(q=>q.id >=1 && q.id <= 10);

linq is pretty easy :)

edit: so you want 2 items, the count, and then a limited part of the array.

        List<SomeTable> li = yourDB.SomeTable.ToList();
        int number = li.Count;
        List<SomeTable> partial = li.GetRange(0, 10);

or

        int value = yourDB.SomeTable.Count();
        List<SomeTable> partial = yourDB.SomeTable.ToList().GetRange(0, 10);

so the best LINQ thing for paging is:

        List<SomeTable> partial = yourDB.SomeTable.OrderBy(q=>q.id).Skip(0).Take(10).ToList();

edited Sep 6, 2010 at 12:52

answered Sep 6, 2010 at 11:02

Stefanvds

5,9065 gold badges51 silver badges73 bronze badges

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

6 Comments

SuperX Over a year ago

I understand, what you mean, but I have to implement paging. It is much more complex than I wrote SELECT * FROM SomeTable WHERE Id BETWEEN 1 AND 10 Is there a way to execute clean T-SQL code with output parameter?

SuperX Over a year ago

Using your solution solution I have to do 2 queries to DB, but I want to male only one.

Stefanvds Over a year ago

and what is the reason you want to make life difficult by swearing with only 1 query?

Ruben Over a year ago

@SuperX: your two statements still result in two queries, even if you only use one execute statement in C#.

Ruben Over a year ago

@Stefanvds: Are you sure you mean yourDB.SomeTable.ToList().GetRange(0, 10)? That would load the entire table into memory! Shouldn't you use yourDB.SomeTable.Where(q=>q.id >=1 && q.id <= 10).ToList() instead; or perhaps yourDB.SomeTable.OrderBy(q=>q.id).Take(10).ToList()

|

Collectives™ on Stack Overflow

LINQ execute SQL query with output parameter

1 Answer 1

6 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

6 Comments

Your Answer

Sign up or log in

Post as a guest

Related