Backend Strings and Provider Names List

When changing the backend of your model you may need to specify a backend string and a provider name. In this article you will find a list of the backend strings and provider names for all the backends supported by Telerik Data Access.

Backend string and provider name can be set respectively through the Backend and ProviderName properties of the BackEndConfiguration class. The Backend property tells Telerik Data Access with which database engine it will communicate and the ProviderName property which provider should be used to connect with the specified backend.

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