Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

which one is faster execute reader, scalar, execute non
query ?

Answer Posted / anirudh g

Scalar will be faster that the execute reader and execute
non query. As scalar only fetch one column single row.
Whereas execute reader may return numbers of record and
though non-query will not return any records it will take
time to identify the data types to validate be4 inserting
the data

Is This Answer Correct ?    2 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How to comment out asp.net tags?

1057


Where session variables are stored?

989


What is the difference between an htmlinputcheckbox control and an htmlinputradiobutton control?

1134


What is viewstate? What does the “enableviewstate” property do?

922


What is asp.net mvc5? : Asp.Net MVC

1034


What's the ASP.Net Application life cycle?

1113


Where are session variables stored?

971


Explain Optimization technique description?

1046


Can a .net web application consume java web service?

970


About CLR, reflection and assemblies?

1977


How u refer webservices?

1961


Can more than one person use the same login?

975


What are different types of authentication techniques that are used in connection strings to connect .net applications with microsoft sql server?

1012


What is the difference between user control and custom control?

952


Dataset is the disconnected environment. suppose if you are binding records to gridview (disconnected environment) and you are making changes to the the grid but before updating the database if any other user modify the data, how will you avoid such problem?

2158