Library tutorials & articles

Using MySQL with .NET

Introduction

Ever wanted to combine the power and ease of the .NET platform with a free database like MySQL? Well thanks to ODBC database functions in ADO.NET it's really easy. All you need is the latest drivers for ADO.NET and MySQL installed. For this tutorial we will use C# to build a simple application for reading a table built in MySQL. This assumes at least basic knowledge of C# and .NET.

Creating the Database

To start the project, we will need to create a mysql database to work with. Create a new database called mysqlsample and create a new table like this:

mysql> create database mysqlsample;

mysql> use mysqlsample;

mysql> create table tutorials (id int not null auto_increment, title varchar(80) not null, link varchar(255) not null, primary key(id));

mysql> insert into tutorials values (1, ‘DOT.NET For Dummies', ‘http://www.dotnetfordummies.com');

mysql> insert into tutorials values (2, ‘XML For Idiots', ‘http://www.xmlforidiots.com');

mysql> insert into tutorials values (3, ‘Windows For Wimps', ‘http://www.windowsforwimps.com');

Comments

  1. 13 Aug 2006 at 00:18
    HI a better way to Connect to a Mysql Database ould be using the Mysql Provided Connector. provides faster access provides suport for almost all mysql Functionality. you can check out the Following Link.

    http://dev.mysql.com/downloads/connector/net/5.0.html you get the connector along with a basic documnetion that will help you with Connecting to the Mysql database.
    being a Mysql fan will also tell people who do not want to have transaction support that mysql with a myisam type table is blazingly fast.

    regards

    David Xavier
  2. 01 Jan 1999 at 00:00

    This thread is for discussions of Using MySQL with .NET.

Leave a comment

Sign in or Join us (it's free).

 cardinals33
AddThis

Related podcasts

  • Object-Oriented Programming in Ruby

    In this episode, I talk with Scott Bellware about object-oriented programming in Ruby, and Ruby's object model. This is taken from a private conversation, and the audio quality suffers at times. Much thanks to Scott for allowing this to be released.This episode of the Alt.NET Podcast is bro...

Events coming up

  • Oct 23

    MySQL Northern Europe Customer Conference

    London, United Kingdom

    Whether you are a developer, a solution architect, a project manager, a DBA or a senior executive, the MySQL European Customer Conferences are designed for you. A day packed with technical sessions, customer experiences and all round MySQL goodnes...

Want to stay in touch with what's going on? Follow us on twitter!