List of backend strings

[Ashley]

Hi,

Please provide me with a list of backend strings for creating the BackendConfiguration for OpenAccess, for example: 

var backendConfiguration = new BackendConfiguration { Backend = "mssql" };

or point me in the direction if it's in the documentation (I couldn't find it).

Regards,
Ash

[Kristian Nikolov]

Hi Ashley,

Indeed our documentation is currently lacking information on the subject, thank you for pointing that out for us. We will update the documentation accordingly. Here is a list containing the back-end strings and the provider names for the supported database engines. You will also find some additional information on building a context class.

 • Microsoft SQL Server
    o Backend string – “MsSql”
    o Provider name – “System.Data.SqlClient”
 • Oracle
    o Backend string – “Oracle”
    o Provider name – “Oracle.DataAccess.Client”
 • MySql
    o Backend string – “MySql”
    o Provider name – “MySql.Data.MySqlClient”
 • Advantage Database Server
    o Backend string – “Ads”
    o Provider name – “Advantage.Data.Provider”
 • Firebird
    o Backend string – “Firebird”
    o Provider name – “FirebirdSql.Data.FirebirdClient”
 • Microsoft SQL Azure
    o Backend string – “Azure”
    o Provider name – “System.Data.SqlClient”
 • Microsoft SQL Server Compact
    o Backend string – “SqlCe”
    o Provider name – “Microsoft.SqlServerCe.Client.3.5”
 • VistaDB
    o Backend string – “VistaDb”
    o Provider name – “System.Data.VistaDB”
 • SQLite
    o Backend string – “SQLite”
    o Provider name – “System.Data.SQLite”
 • PostgreSQL
    o Backend string – “PostgreSql”
    o Provider name – “Npgsql”

Assuming you are trying to build a context class, in addition to the above information, you will need to provide a name of a connection string defined in the .config file. If you require information on how to define a connection string in your .config file, you may find this MSDN article useful. Connectionstrings.com provides information on the connection string formats for the different database engines.

If you need any additional help, do not hesitate to contact us again.

Regards,
Kristian Nikolov
Telerik

[Ashley]

Hi Kristian,

Thanks for the list.

Regards,
Ash