• Favorite
  • Facebook
  • Twitter
  • LinkedIn

Microsoft Press Pearson Education (InformIT)
Skip Navigation Links
Pearson Education (InformIT)
Running a long time operations on the database using LLBLGen Pro.

Sometimes a query can take a long time to complete such as retrieving a large dataset that contains thouthands of database records. To run such queries, you have to set the command timeout of that operation.

To do so using the LLBLGen Pro O/R mapper

If you use the SelfServicing model of the LLBLGen Pro  use the DbUtils.CommandTimeOut  to set ADO.NET command timeout to a value other than the default of 30 seconds as  follows

DbUtils.CommandTimeOut = 120;

In the previous code sample it sets the ADO.NET command timeout to 120 seconds.

If you use the Adapter model of the LLBLGen Pro you can set the timeout for each query on a per-call basis, using the property DataAccessAdapter.CommandTimeOut. The default is 30 (seconds).

      DataAccessAdapter.CommandTimeOut = 120;

In the previous code sample it sets the adapter command timeout to 120 seconds.

(84) Comments

Blog Message

Thank you ever so for you article post.Really thank you! Great.

Blog Message

Wow! This can be one particular of the most helpful blogs We ave ever arrive across on this subject. Basically Magnificent. I am also a specialist in this topic therefore I can understand your effort.

Blog Message

Major thankies for the post.Really thank you! Cool.

Blog Message

Incredible! This blog looks exactly like my old one! It as on a totally different topic but it has pretty much the same page layout and design. Wonderful choice of colors!

Blog Message

I truly appreciate this blog.Thanks Again. Much obliged.

Blog Message

Right now it seems like Drupal could be the preferred blogging platform available at the moment. (from what I ave read) Is the fact that what you are using in your weblog?

Blog Message

us so I came to take a look. I am definitely enjoying the information.

Blog Message

Thanks for sharing, this is a fantastic blog. Will read on

Blog Message

9ETEVJ Respect the blog you given.. indeed, investigation is having to pay off. Adoring the posting.. bless you My internet searching seem full.. thank you.

Blog Message kate spade handbag

Advertising and Public Relations Rusty Budzinski from North Sydney, usually spends time with hobbies for example frisbee golf - frolf, nike free and traveling. Intends to quit work and take the family to numerous noteworthy heritage listed locales on the planet such as Rabat. kate spade handbag

Blog Message fitflops women

WoodBuyer Alvaro from Cowansville, usually spends time with hobbies and interests like ghost hunting, nike free and crafts. that included going to Archaeological Site of Atapuerca. fitflops women

Blog Message louis vuitton sale

40 yr old Massage Therapist Emerson Bonacci from Moosomin, really loves owning an antique car, nike free and autographs. Previous year just completed a trip Elephanta Caves. louis vuitton sale

Blog Message chi hair straightener

40 year-old Office Manager Harlan from Loretteville, spends time with passions including learning, nike free and collecting. In the last year has made a visit to . chi hair straightener

Blog Message kate spade handbag

Public Relationships Professional Anderson from Bowmanville, has lots of hobbies and interests including papermaking, nike free and digital photography. that covered going to Citadel of the Ho Dynasty. kate spade handbag

Blog Message louis vuitton outlet online

WoodBuyer Alvaro from Saint-Justin, has interests such as lawn darts, nike free and video games. Previous year just made a trip Abbey and Altenmünster of Lorsch. louis vuitton outlet online

First Previous 1 2 3 4 5 6 Next Last