List of backend strings

3 posts, 1 answers
  1. Ashley
    Ashley avatar
    30 posts
    Member since:
    Nov 2012

    Posted 12 Jul 2013 Link to this post

    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
  2. Answer
    Kristian Nikolov
    Admin
    Kristian Nikolov avatar
    206 posts

    Posted 16 Jul 2013 Link to this post

    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
    OpenAccess ORM Q2 2013 brings you a more powerful code generation and a unique Bulk Operations support with LINQ syntax. Check out the list of new functionality and improvementsshipped with this release.

  3. DevCraft banner
  4. Ashley
    Ashley avatar
    30 posts
    Member since:
    Nov 2012

    Posted 17 Jul 2013 Link to this post

    Hi Kristian,

    Thanks for the list.

    Regards,
    Ash
Back to Top