Interested to Buy Any Domain ? << Click Here >> for more details...
If i am expecting a single result from sqlserverdatabase
then what command should i follow ?sqlcommand.executereader
(commandbehaviour.singleresult)or sqlcommand.executescalar()
- 4 Answers
- 7997 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / m.mohan krishna
Sqlcommand.executescalar() is preffered.
| Is This Answer Correct ? | 2 Yes | 0 No |
Answer / vinay
Both of these are same commandbehaviour.singleresult also
give you a single result. but we should use
sqlcommand.executescalar()
| Is This Answer Correct ? | 1 Yes | 0 No |
What are the disadvantages of using datalist?
Explain the architecture of ado.net?
What are the several execute methods of ado.net?
How would you connect to database using .NET?
Define the executescalar method?
Explain what are the steps to connect to a database?
What are the parameters that control most of connection pooling behaviours?
What is the current version of entity framework?
Why ca not we use multiple inheritance and garbage collector paralelly in .net?
What are the three Objects of ADO.
Which type of database is used while processing dynamic database?
What is partial class?
-
Visual Basic (800) - C Sharp (3816)
- ASP.NET (3180)
- VB.NET (461)
- COM+ (79)
- ADO.NET (717)
- IIS (369)
- MTS (11)
- Crystal Reports (81)
- BizTalk (89)
- Dot Net (2435)
- Exchange Server (362)
- SharePoint (720)
- WCF (340)
- MS Office Microsoft (6963)
- LINQ Language-Integrated Query (317)
- WPF (371)
- TypeScript (144)
- Microsoft Related AllOther (311)
