Backend Strings and Provider Names List

This article is relevant to entity models that utilize the deprecated Visual Studio integration of Telerik Data Access. The current documentation of the Data Access framework is available here.

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
  • Backend string: “Oracle”
  • Provider name: “Oracle.DataAccess.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”