> For the complete documentation index, see [llms.txt](https://painlessado.obrassard.ca/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://painlessado.obrassard.ca/master.md).

# 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](/getting-started.md)
* [Methods](/methods.md)
  * [Connect](/methods/connect.md)
  * [Close](/methods/close.md)
  * [GetDataReader](/methods/getdatareader.md)
  * [RetrieveAllData](/methods/retrievealldata.md)
  * [ExecuteScalar](/methods/executescalar.md)
  * [ExecuteNonQuery](/methods/executenonquery.md)
* [Properties](/properties.md)
  * [Database](/properties/database.md)
  * [State](/properties/state.md)