Source configuration
====================

**Energy.Source.Configuration** builds dialect-specific connection strings. It supports SQL Server, MySQL, SQLite, PostgreSQL, Oracle, Firebird, and generic ANSI SQL.

Properties
----------

| Property | Description |
|----------|-------------|
| `Dialect` | SQL dialect from `Energy.Enumeration.SqlDialect`. |
| `Server` | Server host or instance. |
| `Port` | Server port. |
| `Catalog` | Database/catalog name. |
| `User` | User ID. |
| `Password` | Password. |
| `Encryption` | Enable encryption (MySQL). |
| `Compression` | Enable compression. |
| `Timeout` | Connection timeout. |
| `Charset` | Character set. |

Connection string
-----------------

```csharp
Energy.Source.Configuration config = new Energy.Source.Configuration
{
    Dialect = Energy.Enumeration.SqlDialect.MYSQL,
    Server = "localhost",
    Catalog = "test",
    User = "root",
    Password = "secret",
    Port = 3306,
};

string connectionString = config.ConnectionString;
Console.WriteLine(connectionString);
// Server=localhost;Port=3306;Database=test;Uid=root;Pwd=secret
```

Entity Framework
----------------

```csharp
string ef = config.GetEntityConnectionString("MySql.Data.MySqlClient");
```

DSN prefix
----------

```csharp
string prefix = config.GetDSNPrefix(); // mysql
```

SQL Server example
------------------

```csharp
Energy.Source.Configuration sql = new Energy.Source.Configuration
{
    Dialect = Energy.Enumeration.SqlDialect.SQLSERVER,
    Server = @".\SQLEXPRESS",
    Catalog = "MyDatabase",
    User = "sa",
    Password = "secret",
    Timeout = 10,
};

Console.WriteLine(sql.ConnectionString);
// Data Source=.\SQLEXPRESS;Initial Catalog=MyDatabase;User ID=sa;Password=secret;Connect Timeout=10;
```

See also
--------

- `core-source`
- `enumeration` for `SqlDialect`