Answer Posted / sireesha

MySQLDirect .NET is data provider to direct access to MySQL
database server for
the Microsoft .NET Framework and .NET Compact Framework. It
is completely based
on ActiveX Data Objects for the .NET Framework (ADO.NET)
technology. ADO.NET provides
a rich set of components for creating distributed, data-
sharing applications. It
is an integral part of the .NET Framework, providing access
to relational data,
XML, and application data.





MySQLDirect .NET data provider can be used in the same way
as the SQL Server .NET
or the OLE DB .NET Data Provider. Data provider can access
MySQL server either using
native MySQL network protocol directly or through MySQL
client library. It allows
to create lightweight and fast applications working with
MySQL.

What is ado.net in mvc?

982

---

What are the data providers in ADO.NET framework?

1076

---

What is a sqldataadapter?

1057

---

What is the hierarchy of data in databases?

988

---

What are two types of transaction supported by ado.net?

1034

---

What is the difference between executequery and executenonquery?

972

---

What is the difference between Optimistic and Pessimistic locking?

1038

---

Define the executescalar method?

997

---

How can we load multiple tables in to dataset?

1146

---

How will you differentiate between ADO (ActiveX Data Object) and RDO (Remote Data Objects)?

1086

---

In how many ways we can retrieve table records count? How to find the count of records in a dataset?

1048

---

Data reader read and forward only, how is it possible to get 2 tables of data at a time?

966

---

Name which operations can you not perform on an ado.net dataset?

1039

---

What providers does Ado.net uses?

1064

---

What are the benefits of using of ADO.NET in .NET 4.0?

1154

---