HYTOS

using System.Data;

using System.Data.SqlClient;

using System.ComponentModel.DataAnnotations.Schema;

using System.Data.SQLite;

using Dapper;

namespace ID2.Manager.Dapper.Repository

        {

            switch (dbType)

            {

                case DatabaseType.SQLITE:

                    this._DbConnection = this.SQLiteDBConnection(connectionStr);

                    break;

                case DatabaseType.MSSQL:

                default:

                    this._DbConnection = this.DBConnection(connectionStr);

        {

            return new SqlConnection(connectionStr);

        }

        public SQLiteConnection SQLiteDBConnection(string connectionStr)

        {

            return new SQLiteConnection(connectionStr, true);

        }

        public IDbTransaction BeginTransaction()

        {