private static void OpenDatabase(out PetaPoco.NetCore.Database database, bool useDataSource, string dataSource, string host, int port, bool useWindowsAuthentication, string userName, string password, string dbName) { string connectionString = MakeConnectionString(useDataSource, dataSource, host, port, useWindowsAuthentication, userName, password, dbName); database = new PetaPoco.NetCore.Database(connectionString, "System.Data.SqlClient"); database.OpenSharedConnection(); }
private static void OpenDatabase(out PetaPoco.NetCore.Database database, string server, int port, bool useWindowsAuthentication, string userName, string password, string dbName) { string connectionString = MakeConnectionString(server, port, useWindowsAuthentication, userName, password, dbName); database = new PetaPoco.NetCore.Database(connectionString, "MySql.Data.MySqlClient"); database.OpenSharedConnection(); }
public static void OpenDatabase(out PetaPoco.NetCore.Database database, string host, int port, bool useWindowsAuthentication, string userName, string password, string dbName) { string connectionString = MakeConnectionString(host, port, useWindowsAuthentication, userName, password, dbName); database = new PetaPoco.NetCore.Database(connectionString, "Npgsql"); database.OpenSharedConnection(); }
/// <summary> /// 配置文件中的数据库连接名 /// </summary> /// <param name="connectString"> </param> protected DALBase() { var config = new ConfigurationBuilder() .SetBasePath(Directory.GetCurrentDirectory()) .AddJsonFile("appsettings.json") .Build(); _connectionString = config.GetConnectionString("DefaultConnection"); db = new PetaPoco.NetCore.Database(new MySqlConnection(_connectionString)); }
public static void CreateDatabase(out MycoKeyCreator.Library.Database.IDatabase iDatabase, string folder, string dbName) { string path = System.IO.Path.Combine(folder, dbName + ".sqlite"); OpenDatabase(out iDatabase, path); PetaPoco.NetCore.Database database = (iDatabase as DatabaseWrapper).Database; SqlQueryBuilders.ISqlQueryBuilder iSqlQueryBuilder = (iDatabase as DatabaseWrapper).ISqlQueryBuilder; // Create each table iDatabase.CreateTables(); }
public DatabaseWrapper(PetaPoco.NetCore.Database database) { Database = database; }
/// <summary> /// 配置文件中的数据库连接名 /// </summary> /// <param name="connectString"> </param> protected DALBase(string connectString) { db = new PetaPoco.NetCore.Database(new MySqlConnection(connectString)); }
public Table(SqlQueryBuilders.ISqlQueryBuilder iSqlQueryBuilder, PetaPoco.NetCore.Database database, string tableName) { _iSqlQueryBuilder = iSqlQueryBuilder; _database = database; _tableName = tableName; }
private static void OpenDatabase(out PetaPoco.NetCore.Database database, string path) { database = new PetaPoco.NetCore.Database("Data Source=" + path + ";Version=3;", "System.Data.SQLite"); database.OpenSharedConnection(); }
public AttributeTable(SqlQueryBuilders.ISqlQueryBuilder iSqlQueryBuilder, PetaPoco.NetCore.Database database) : base(iSqlQueryBuilder, database, Database.TableNames.Attribute) { }
public SpeciesAttributeSizeTable(SqlQueryBuilders.ISqlQueryBuilder iSqlQueryBuilder, PetaPoco.NetCore.Database database) : base(iSqlQueryBuilder, database, Database.TableNames.SpeciesAttributeSize) { }
public KeyTable(SqlQueryBuilders.ISqlQueryBuilder iSqlQueryBuilder, PetaPoco.NetCore.Database database) : base(iSqlQueryBuilder, database, Database.TableNames.Key) { }
public QueryManager(PetaPoco.NetCore.Database database) { _database = database; }
public LiteratureTable(SqlQueryBuilders.ISqlQueryBuilder iSqlQueryBuilder, PetaPoco.NetCore.Database database) : base(iSqlQueryBuilder, database, Database.TableNames.Literature) { }