# Introduction

![version](https://img.shields.io/badge/Version-1.3.0-brightgreen.svg?style=for-the-badge)\
![](https://img.shields.io/badge/Language-CSharp-5b0dc3.svg?style=for-the-badge)

### [*Read the complete documentation on GitBook*](https://painlessado.obrassard.ca)

## PainlessADO is a wrapper for C#'s ActiveX Data Objects Library (ADO.NET) which simplifies the use of basic SQL functions.

PainlessADO includes the **SQL** class, which allows you to quickly connect to a Microsoft SQL database and execute queries with or without parameters in your C# code :

```csharp
public class SQL
```

Version 1.3 also includes **support for MySQL** databases which provides the same methods as the SQL class, only they have been adapted to MySQL. Using this class is therefore exactly the same as the **SQL** class which is detailed in this document.

```csharp
public class MySQL
```

## Table of contents

* [Getting Started](https://painlessado.obrassard.ca/getting-started)
* [Methods](https://painlessado.obrassard.ca/methods)
  * [Connect](https://painlessado.obrassard.ca/methods/connect)
  * [Close](https://painlessado.obrassard.ca/methods/close)
  * [GetDataReader](https://painlessado.obrassard.ca/methods/getdatareader)
  * [RetrieveAllData](https://painlessado.obrassard.ca/methods/retrievealldata)
  * [ExecuteScalar](https://painlessado.obrassard.ca/methods/executescalar)
  * [ExecuteNonQuery](https://painlessado.obrassard.ca/methods/executenonquery)
* [Properties](https://painlessado.obrassard.ca/properties)
  * [Database](https://painlessado.obrassard.ca/properties/database)
  * [State](https://painlessado.obrassard.ca/properties/state)