各種 .NET Data Provider

# DBMS

## ODBC

<details><summary>ライブラリ</summary><div>
- System.Data.dll
</div></details>

<details><summary>クラス</summary><div>
- OdbcConnection
- OdbcCommand
- OdbcDataAdapter
</div></details>

<details><summary>コネクション作成例</summary><div>

```C#
var builder = new OdbcConnectionStringBuilder() { Dsn = "データソース名" };
builder["Uid"] = "ユーザー名";
builder["Pwd"] = "パスワード";
using (var connection = new OdbcConnection(builder.ConnectionString))
{
	// 処理
}
```
</div></details>


## SQL Server

<details><summary>ライブラリ</summary><div>
- System.Data.dll
</div></details>

<details><summary>クラス</summary><div>
- SqlConnection
- SqlCommand
- SqlDataAdapter
</div></details>

<details><summary>コネクション作成例</summary><div>

```C#
var builder = new SqlConnectionStringBuilder()
{
	DataSource = "データソース名",
	InitialCatalog = "データベース名",
	UserID = "ユーザー名",
	Password = "パスワード",
	ApplicationName = Assembly.GetEntryAssembly().GetName().Name,
};
using (var connection = new SqlConnection(builder.ConnectionString))
{
	// 処理
}
```
</div></details>


## Oracle
12c からフルマネージド対応！

<details><summary>ライブラリ</summary><div>
- Oracle.ManagedDataAccess.dll
</div></details>

<details><summary>クラス</summary><div>
- OracleConnection
- OracleCommand
- OracleDataAdapter
</div></details>

<details><summary>コネクション作成例</summary><div>

```C#
var builder = new OracleConnectionStringBuilder()
{
	DataSource = "サーバー名/SID",
	UserID = "ユーザー名",
	Password = "パスワード",
};
using (var connection = new OracleConnection(builder.ConnectionString))
{
	// 処理
}
```
</div></details>


## PostgreSQL

<details><summary>ライブラリ</summary><div>
- Npgsql.dll
- Mono.Security.dll
</div></details>

<details><summary>クラス</summary><div>
- NpgsqlConnection
- NpgsqlCommand
- NpgsqlDataAdapter
</div></details>

<details><summary>コネクション作成例</summary><div>

```C#
var builder = new NpgsqlConnectionStringBuilder()
{
	Host = "サーバー名",
	Database = "データベース名",
	UserName = "ユーザー名",
	Password = "パスワード",
};
using (var connection = new NpgsqlConnection(builder.ConnectionString))
{
	// 処理
}
```
</div></details>


## MySQL

<details><summary>ライブラリ</summary><div>
- MySql.Data.dll
</div></details>

<details><summary>クラス</summary><div>
- MySqlConnection
- MySqlCommand
- MySqlDataAdapter
</div></details>

<details><summary>コネクション作成例</summary><div>

```C#
var builder = new MySqlConnectionStringBuilder()
{
	Server = "サーバー名",
	Database = "データベース名",
	UserID = "ユーザー名",
	Password = "パスワード",
};
using (var connection = new MySqlConnection(builder.ConnectionString))
{
	// 処理
}
```
</div></details>


## Firebird

<details><summary>ライブラリ</summary><div>
- FirebirdSql.Data.FirebirdClient.dll
</div></details>

<details><summary>クラス</summary><div>
- FbConnection
- FbCommand
- FbDataAdapter
</div></details>

<details><summary>コネクション作成例</summary><div>

```C#
var builder = new FbConnectionStringBuilder()
{
	DataSource = "サーバー名",
	Database = "データベース名",
	UserID = "ユーザー名",
	Password = "パスワード",
	Dialect = 3,
};
using (var connection = new FbConnection(builder.ConnectionString))
{
	// 処理
}
```
</div></details>


## Caché

<details><summary>ライブラリ</summary><div>
- InterSystems.Data.CacheClient.dll
</div></details>

<details><summary>クラス</summary><div>
- CacheConnection
- CacheCommand
- CacheDataAdapter
</div></details>

<details><summary>コネクション作成例</summary><div>

```C#
var builder = new CacheConnectionStringBuilder()
{
	Server = "サーバー名",
	//Port = 1972,
	Namespace = "ネームスペース",
	User = "ユーザー名",
	Password = "パスワード",
};
using (var connection = new CacheConnection(builder.ConnectionString))
{
	// 処理
}
```
</div></details>


## DB2
IBM 製の DBMS で、アンマネージド。。


## Symfoware
富士通製の DBMS で、無償提供されていない。