What providers do you use to connect to oracle database ?
Answers were Sorted based on User's Feedback
Answer / tarun
odbc data provider that available in System.Data.ODBC
namespace.
| Is This Answer Correct ? | 3 Yes | 0 No |
Answer / anshuman sahoo
Oracle data provider (namespace=System.Data.OracleClient)
| Is This Answer Correct ? | 3 Yes | 4 No |
Answer / bhupi
we use "DATAPROVIDER "
which cosists $ components
1 Connection ,(Create COnnection)
2. Command ,(Write Command)
3.DataReader
4.DataAdapter
| Is This Answer Correct ? | 1 Yes | 2 No |
what are types of Dataset ?
What are the uses of Stored Procedure?
What are the difference between readonly vs. Const?
Is datareader faster than datatable?
What is dataset object? Explain the various objects in dataset.
Which method do you invoke on the DataAdapter control to load your generated dataset with data?
If we want to connect to many databases in dataaccess layer such as MSAccess,Sql server,oracle means not to a particular database depends on condition we have to connect to appropriate database in this scenario if we without changing code Ho wdo you handle this situation?
What are the two fundamental objects in ADO.NET?
When multiple users attempt to modify data at the same time Ex user 1 is updating record at same time user2 deleted record sucessfully.now user1 has press update button . how to handle concurrency
What provider ADO.net use by default ?
5 Answers Accenture, BirlaSoft, Wipro,
How to connect and retrieve data from database using dataset
How can I retrieve two tables of data at a time by using data reader? Data reader read and forward only, how is it possible to get 2 tables of data at a time?
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)