Question regarding .Take(NumItems)

[Seabus]

Hi,

Simple question:

var query = (from Person p in Persons select p).Take(5).ToList();

Does OpenAccess turn this into a SELECT TOP 5 statement ??? :-)


MadSeb

[Thomas]

Hello Seabus,

Simple answer: Yes.

All the best,
Thomas
the Telerik team

[Rui]

Hello, if I have something like this:

var c = from p in ctx.GetAll<Person >().Where(x => x.Name.Contains(e.Text)).Take(15)
                           select new
                                  {
                                      p.IdPerson,
                                      p.name
              };

var count = c.Count(); //<- this will not be 15, it will be the total where clause result count

What am I doing wrong?

[Thomas]

Hello Rui,

I just double checked that this does not occur. Which database version and which OpenAccess version do you use? Do you use fetchplans or FetchStrategy ? Can you give us your .rlinq file?
Greetings,
Thomas
the Telerik team

[Rui]

Hello,
telerik openaccess version: 2011.3.1129.2
DB Version: SQLServer 2008 R2

I just build the rlinq from the DB and the I just use something like:

 using (var ctx = new DbContext())
            {

var c = from p in ctx.GetAll<Person >().Where(x => x.Name.Contains(e.Text)).Take(15)
                           select new
                                  {
                                      p.IdPerson,
                                      p.name
              };

var count = c.Count();

}

[Rui]

I'm using .NET 3.5, does it matter?

[Rui]

Hello.
The database is taken from http://northwind.codeplex.com/
In attachement is a sample application (with rlinq file: http://www.wupload.com/file/2661526527/WebApplication1.7z

thank you

[Thomas]

Hello Rui,

works like a charm on my side...

SELECT TOP(@__TAKE) a.[ContactName] AS COL1, a.[ID] AS COL2 FROM [Customer] a

Please double check your configuration, esp. that there is no reference to older OpenAccess versions.
I tested here with the newest upcoming build.

Greetings,
Thomas
the Telerik team

[Rui]

I don't quite understand how you get that query...
What version are you using?
Since it's a Count() why in you query there is no TOP?

here is my result for count(): untitled.png

when I use tolist: tolist.png

[Rui]

With the Latest internal build: 2011.3.1320.1 is working.