What are the different namespaces used in the project to
connect the database?
Answers were Sorted based on User's Feedback
Answer / shashikant kothavale
in my project as we used sql server as back end i have used
sqlclient namespace and system io namespace to read
values/data from non database file via comm separated values!
other data providrs are
oledb;
sqlclient;
oraclclient,
odbc etc
| Is This Answer Correct ? | 1 Yes | 0 No |
Answer / rahul singhal
in vb.net for sql server
imports system.data
imports system.data.oledb
imports system.data.sqlclient
in c# for sql server
using system.data
using system.data.oledb
using system.data.sqlclient
| Is This Answer Correct ? | 1 Yes | 0 No |
system.data
system.data.oledb
system.data.sqlclient
| Is This Answer Correct ? | 0 Yes | 0 No |
Why do we need ado.net?
Does entity framework use ado.net?
If i am expecting a single result from sqlserverdatabase then what command should i follow ?sqlcommand.executereader (commandbehaviour.singleresult)or sqlcommand.executescalar()
What are all the different authentication techniques used to connect to MS SQL Server?
What are the main differences between classic ado and ado.net?
How will you fill the gridview by using datatable object at runtime?
What are the different row versions available in table?
What are the different execute methods of Ado.Net?
List all the steps in order, to access a database through ado.net?
What is sql command in ado net?
Describe datareader object of ado.net with example.
ADO.NET is Disconnected Architecture. DataReader is connected Architecture, but DataReader is a part of ADO.NET. How is it possible?
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)