OrmLite question: How to limit rows count?

[KhodeN]

I have tried to select limited count of rows with this:

var list = dbCmd.Select<AddressObject>().Take(10);

But it didn't work perfectly. It is so slow! (Common number of records
is about 11 millions)

Another way I have tried was this:

var list = dbCmd.Select<AddressObject>("SELECT TOP 10 * FROM
as_addrobj");

It was quick, but I think, that it is dirty. This way is workaround.

How to select limited count of records with correct way?

[Demis Bellot]

What RDBMS are you using?

As you should be able to use the Sql Expression below for anything but Sql Server:

var results = dbCmd.Select<Author>(q => q.Limit(10));

P.S. if it's succinct, intuitive + works it's not dirty :)

Cheers,

--
- Demis

http://twitter.com/demisbellot

http://www.servicestack.net/mythz_blog

[Artem Berezin]

I'm using Sql Server.

Thanks for answer. It works excelent! I'm happy)

суббота, 31 марта 2012 г. 13:28:43 UTC+11 пользователь mythz написал:

What RDBMS are you using?

As you should be able to use the Sql Expression below for anything but Sql Server:

var results = dbCmd.Select<Author>(q => q.Limit(10));

P.S. if it's succinct, intuitive + works it's not dirty :)

Cheers,