IDataAccessLayer - dictionary access provider

This class provides the set of RDBMS-independent methods to manipulate data in SQL storage. Inhereted classes implement or override IDataAccessLayer methods concerning primary key creation, SQL string functions, non-standard query syntax. Below is the list of data providers for supported RSDBS.

Source code - file IDataAccessLayer.cs

MSSQL_DataAccessLayer - MS SQL dictionary access via ADO.NET

Constructor gets the instance of System.Data.SqlClient.SqlConnection.

Sample code C#:

   SqlConnection cnx = new SqlConnection(
                                         "Data Source=localhost;"+
                                         "Initial Catalog=solarix;"+
                                         "Integrated Security=True;"+
                                         "MultipleActiveResultSets=true;"
                                        );
   cnx.Open();
   
   Solarix.MSSQL_DataAccessLayer dal = new Solarix.MSSQL_DataAccessLayer(cnx);
   Solarix.Dictionary dict = new Solarix.Dictionary(dal);
   
   // ...

MySQL_DataAccessLayer - MySQL dictionary access via .NET Provider

Constructor gets an instance of MySql.Data.MySqlClient.MySqlConnection.

Sample code:

   string cnx_string = "server=localhost;user id=root; password=; database=solarix; pooling=false;";
   MySql.Data.MySqlClient.MySqlConnection cnx = new MySql.Data.MySqlClient.MySqlConnection(cnx_string);
   cnx.Open();
   Solarix.MySQL_DataAccessLayer dal = new Solarix.MySQL_DataAccessLayer(cnx);
   Solarix.Dictionary dict = new Solarix.Dictionary(dal);
   
   // ...

FireBird_DataAccessLayer - FireBird dictionary access via .NET Provider

Constructor gets an instance of FirebirdSql.Data.FirebirdClient.FbConnection.

Sample code:

   FirebirdSql.Data.FirebirdClient.FbConnectionStringBuilder cs = new FirebirdSql.Data.FirebirdClient.FbConnectionStringBuilder();
        
   cs.DataSource = "localhost";
   cs.Database = "e:\\db\\solarix.fdb";
   cs.UserID = "SYSDBA";
   cs.Password = "masterkey";
   cs.Dialect = 3;
   cs.Charset = "UTF8";
        
   string cnx_string = cs.ToString();

   FirebirdSql.Data.FirebirdClient.FbConnection cnx = new FirebirdSql.Data.FirebirdClient.FbConnection(cnx_string);
   cnx.Open();
   Solarix.FireBird_DataAccessLayer dal = new Solarix.FireBird_DataAccessLayer(cnx);
   Solarix.Dictionary dict = new Solarix.Dictionary(dal);
   
   // ...

Oracle_DataAccessLayer provides the access to grammatical dictionary in Oracle RDBMS via .NET Oracle Data Provider.

Constructor gets an instance of Oracle.DataAccess.Client.OracleConnection.

Sample code:

   string cnx_string = "Data Source=TEST;User Id=USERNAME;Password=masterkey;";
   Oracle.DataAccess.Client.OracleConnection cnx = new Oracle.DataAccess.Client.OracleConnection(cnx_string);
   cnx.Open();
   Solarix.Oracle_DataAccessLayer dal = new Solarix.Oracle_DataAccessLayer(cnx);
   
   // ...

ODBC_DataAccessLayer provides the access to grammatical dictionary in any RDBMS via ODBC provider.

Constructor gets an instance of System.Data.Odbc.OdbcConnection.

Sample code:

   System.Data.Odbc.OdbcConnection cnx = new System.Data.Odbc.OdbcConnection("Dsn=solarix_firebird;");
   cnx.Open();
   Solarix.ODBC_DataAccessLayer dal = new Solarix.ODBC_DataAccessLayer(cnx);
   
   // ...

Navigation

Back to ORM main page

Russian version of the page

Connecting the instance of grammatical dictionary to the dictonary database

  © Козиев Илья 2019
changed 13-Mar-11