GetDefaultConnection() public static méthode

public static GetDefaultConnection ( ) : string
Résultat string
Exemple #1
0
        public void TestFixtureSetUp()
        {
            LogManager.LogFactory = new ConsoleLogFactory();

            switch (Dialect)
            {
            case Dialect.Sqlite:
                OrmLiteConfig.DialectProvider = SqliteDialect.Provider;
                ConnectionString = GetFileConnectionString();
                ConnectionString = ":memory:";
                return;

            case Dialect.SqlServer:
                OrmLiteConfig.DialectProvider = SqlServerDialect.Provider;
                ConnectionString = Config.SqlServerBuildDb;
                return;

            case Dialect.MySql:
                OrmLiteConfig.DialectProvider = MySqlDialect.Provider;
                ConnectionString = "Server=localhost;Database=test;UID=root;Password=test";
                return;

            case Dialect.PostgreSql:
                OrmLiteConfig.DialectProvider = PostgreSqlDialect.Provider;
                ConnectionString = "Server=localhost;Port=5432;User Id=test;Password=test;Database=test;Pooling=true;MinPoolSize=0;MaxPoolSize=200";
                return;

            case Dialect.SqlServerMdf:
                ConnectionString = "~/App_Data/Database1.mdf".MapAbsolutePath();
                ConnectionString = Config.GetDefaultConnection();
                return;
            }
        }
        private void Init()
        {
            LogManager.LogFactory = new ConsoleLogFactory(debugEnabled: false);

            switch (Dialect)
            {
            case Dialect.Sqlite:
                OrmLiteConfig.DialectProvider = SqliteDialect.Provider;
                ConnectionString = GetFileConnectionString();
                ConnectionString = ":memory:";
                return;

            case Dialect.SqlServer:
                OrmLiteConfig.DialectProvider = SqlServerDialect.Provider;
                ConnectionString = Config.SqlServerBuildDb;
                return;

            case Dialect.MySql:
                OrmLiteConfig.DialectProvider = MySqlDialect.Provider;
                ConnectionString = "Server=localhost;Database=test;UID=root;Password=test";
                return;

            case Dialect.PostgreSql:
                OrmLiteConfig.DialectProvider = PostgreSqlDialect.Provider;
                ConnectionString =
                    "Server=localhost;Port=5432;User Id=test;Password=test;Database=test;Pooling=true;MinPoolSize=0;MaxPoolSize=200";
                return;

            case Dialect.SqlServerMdf:
                OrmLiteConfig.DialectProvider = SqlServerDialect.Provider;
                ConnectionString = "~/App_Data/Database1.mdf".MapAbsolutePath();
                ConnectionString = Config.GetDefaultConnection();
                return;

            case Dialect.Oracle:
                OrmLiteConfig.DialectProvider = OracleDialect.Provider;
                return;

            case Dialect.VistaDb:
                OrmLiteConfig.DialectProvider             = VistaDbDialect.Provider;
                VistaDbDialect.Provider.UseLibraryFromGac = true;

                var connectionString = System.Configuration.ConfigurationManager.ConnectionStrings["myVDBConnection"];
                var factory          = DbProviderFactories.GetFactory(connectionString.ProviderName);
                using (var db = factory.CreateConnection())
                    using (var cmd = db.CreateCommand())
                    {
                        var tmpFile = Path.GetTempPath().CombineWith(Guid.NewGuid().ToString("n") + ".vb5");
                        cmd.CommandText = @"CREATE DATABASE '|DataDirectory|{0}', PAGE SIZE 4, LCID 1033, CASE SENSITIVE FALSE;"
                                          .Fmt(tmpFile);
                        cmd.ExecuteNonQuery();
                        ConnectionString = "Data Source={0};".Fmt(tmpFile);
                    }

                return;
            }
        }
Exemple #3
0
        public void TestFixtureSetUp()
        {
            LogManager.LogFactory = new ConsoleLogFactory();

            //OrmLiteConfig.DialectProvider = SqliteDialect.Provider;
            //ConnectionString = GetFileConnectionString();
            //ConnectionString = ":memory:";

            //OrmLiteConfig.DialectProvider = SqlServerDialect.Provider;
            //ConnectionString = Config.SqlServerBuildDb;
            //ConnectionString = "~/App_Data/Database1.mdf".MapAbsolutePath();

            ConnectionString = Config.GetDefaultConnection();
        }