Chapter 17. Using MySQL Stored Programs with .NET

ADO.NET is Microsoft’s database-independent, language-neutral data access interface included within the .NET framework. ADO.NET allows .NET languages such as C# and VB.NET to communicate with various data sources, primarily relational databases such as SQL Server, Oracle, and, of course, MySQL. MySQL provides an ADO-compliant driver—Connector/Net—that allows us to work with MySQL databases using the ADO.NET interfaces.

First, we’ll start with a quick review of how we can use ADO.NET to process standard SQL statements against a MySQL database. Next, we’ll examine the ADO.NET syntax for invoking stored programs, including handling input and output parameters and processing multiple result sets. Finally, we’ll show how we can use a MySQL stored procedure as the basis for an ASP.NET web application.

Get MySQL Stored Procedure Programming now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.