201.Connection String Generator

201.1 Overview

Foxtension provides a set of strongly-typed builders for generating connection strings in a safe and structured way. Instead of manually constructing connection strings, developers can use dedicated builder classes to reduce errors and improve readability.

The following builders are available:

• SQL Server Connection String Builder
• SQLite Connection String Builder
• FTP Connection String Builder

---

201.2 SQL Server Connection String Builder

var sqlserver = new SqlServerCSBuilder
{
    DatabaseName = "test",
    DataSource = "",
    ServerAddress = "127.0.0.1",
    ServerPort = 8080, // default is null
    IntegratedSecurity = false, // true -> no username & password | false -> requires credentials
    Username = "Admin",
    Password = "123",
    Encryption = true, // default is true
    MultipleActiveResultSets = false, // default is false
    PersistSecurityInfo = false, // default is false
    Pooling = false, // default is false
    TrustServerCertificate = true // default is true
}.Build();

This builder constructs a valid SQL Server connection string based on provided configuration options. It supports both credential-based and integrated authentication modes.

201.3 SQLite Connection String Builder

var sqlite = new SqLiteCSBuilder
{
    DatabaseName = "test",
    TargetPath = @"Path/to/your/db file/"
}.Build();

This builder generates a SQLite connection string based on a database file path and database name. It is designed for lightweight local database usage.

201.4 FTP Connection String Builder

var ftp = new FtpCSBuilder
{
    ServerAddress = "127.0.0.1",
    ServerPort = 21,
    Username = "root",
    Password = "123"
}.Build();

This builder constructs an FTP connection string for connecting to remote FTP servers using authentication credentials.

201.5 Validation & Exceptions

ArgumentNullException Thrown when a required string parameter is null or empty. This applies to fields such as: DatabaseName ServerAddress Username Password (when required) TargetPath ArgumentOutOfRangeException Thrown when numeric parameters are outside valid ranges. Examples: ServerPort is less than 0 or greater than 65535 Notes All builders validate input before generating the final connection string. Default values are applied where optional parameters are not provided. SQL Server builder supports both integrated security and credential-based authentication. SQLite builder is intended for local file-based databases. FTP builder is designed for basic authentication scenarios and does not include advanced TLS configuration in its current version.