News
  • 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 https://www.diigo.com/user/peasleelosinger/karajad

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


Blog Message http://www.buy3dmetalpuzzle.com

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 https://www.behance.net/cathyflore7441

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


Blog Message http://www.mykingsmall.com

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 http://www.icsi.edu/capitalmarketweek/UserProfile/tabid/4706/userId/1427723/Default.aspx

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


Blog Message https://greenleafexpress.ca/

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 http://jav18tv.com/category/asian-movies/

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


Blog Message http://closestdispensaries.com/

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


Blog Message http://www.suba.me/

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 http://www.skehanaghlodge.com#


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 http://www.ktype.org#


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 http://www.whalebonehouse.com#


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 http://www.ewebwire.com#


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 http://www.skehanaghlodge.com#


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 http://www.paulhobbsphotography.com#

First Previous 1 2 3 4 5 6 Next Last 
Rating
Name
Email
Comment