Introduction
MySQL is a fast, easy-to-use RDBMS used being used for many small and big businesses. MySQL is developed, marketed, and supported by MySQL AB, which is a Swedish company. MySQL is becoming so popular because of many good reasons.
Connect to a MySQL 5.0 database with ADO.NET
If you want to develop applications with the .NET Framework having a MySQL database as a data source you may want to try the MySQL Connector/NET 5.2. The MySQL Connector/NET is a fully managed ADO.NET component which provides specific implementation for all ADO.NET classes. You can download the MySQL Connector/NET 5.2 component from the MySQL web site.
MySQL Connector/NET 5.2 main features
How to use the MySQL Connector/NET
In order to use this component you have to add a reference to the MySql.Data.dll (from the MySQL Connector/NET package you downloaded form MySQL web site).
All downloads for MySQL are located at MySQL Downloads.
More to come........
MySQL is a fast, easy-to-use RDBMS used being used for many small and big businesses. MySQL is developed, marketed, and supported by MySQL AB, which is a Swedish company. MySQL is becoming so popular because of many good reasons.
- MySQL is released under an open-source license. So you have nothing to pay to use it.
- MySQL is a very powerful program in its own right. It handles a large subset of the functionality of the most expensive and powerful database packages.
- MySQL uses a standard form of the well-known SQL data language.
- MySQL works on many operating systems and with many languages including PHP, PERL, C, C++, JAVA etc.
- MySQL works very quickly and works well even with large data sets.
- MySQL is very friendly to PHP, the most appreciated language for web development.
- MySQL supports large databases, up to 50 million rows or more in a table. The default file size limit for a table is 4GB, but you can increase this (if your operating system can handle it) to a theoretical limit of 8 million terabytes (TB).
- MySQL is customizable. The open source GPL license allows programmers to modify the MySQL software to fit their own specific environments.
Connect to a MySQL 5.0 database with ADO.NET
If you want to develop applications with the .NET Framework having a MySQL database as a data source you may want to try the MySQL Connector/NET 5.2. The MySQL Connector/NET is a fully managed ADO.NET component which provides specific implementation for all ADO.NET classes. You can download the MySQL Connector/NET 5.2 component from the MySQL web site.
MySQL Connector/NET 5.2 main features
- A new profile provider has been implemented along with a fully revamped provider schema.
- New bulk loading and script execution classes are available.
- The ability to clear a single or all connection pools.
- Integration into Visual Studio 2008
- MySqlDataAdapter now supports batching
- BINARY(16) columns are now treated as GUIDs
- Various changes in how we handle parameters.
In order to use this component you have to add a reference to the MySql.Data.dll (from the MySQL Connector/NET package you downloaded form MySQL web site).
C# .NET
using MySql.Data.MySqlClient;
...
string connString = "SERVER=localhost;" +
"DATABASE=mySQLDatabase;" +
"UID=user;" +
"PASSWORD=password;";
MySqlConnection conn = new MySqlConnection(connString);
MySqlCommand command = conn.CreateCommand();
MySqlDataReader reader;
command.CommandText = "select * from table";
conn.Open();
reader = command.ExecuteReader();
while (reader.Read())
{
// Read the value...
string value = reader.GetValue(0).ToString();
}
conn.Close();
All downloads for MySQL are located at MySQL Downloads.
More to come........
No comments:
Post a Comment
Note: Only a member of this blog may post a comment.