static void Main(string[] args)
{
#region SqlServer
{
//BankSqlHelper bankSqlHelper = new BankSqlHelper(new DbInfo
//{
// ServerName = "localhost",
// DataBaseName = "test",
// DbType = DBTypeEnum.SqlServer,
// Password = "******",
// UserName = "******",
// Port = "1433"
//});
//if (bankSqlHelper.TestConnection())
//{
// var result = bankSqlHelper.GetValue("select 1");
// Console.WriteLine(result);
//}
}
#endregion
#region Oracle
BankSqlHelper bankSqlHelper = new BankSqlHelper(new DbInfo
{
ServerName = "192.168.106.71",
DataBaseName = "fjzy",
DbType = DBTypeEnum.Oracle,
Password = "******",
UserName = "******",
Port = "1521"
});
//Console.WriteLine("??");
string ysj = "adhkjafhajhfa";
if (bankSqlHelper.TestConnection())
{
var result = bankSqlHelper.GetValue("select 5 from dual");
//Console.WriteLine(result);
}
#endregion
#region Mysql
//BankSqlHelper bankSqlHelper = new BankSqlHelper(new DbInfo
//{
// ServerName = "test",
// DbType = DBTypeEnum.MySql,
// Password = "******",
// Port = "3306",
// UserName = "******"
//});
//if ( bankSqlHelper.TestConnection())
//{
// var result = bankSqlHelper.GetValue("select 1");
// Console.WriteLine(result);
//}
#endregion
#region Sqlite
//BankSqlHelper bankSqlHelper = new BankSqlHelper(new DbInfo
//{
// ConnString = "Db/LogData.sqlite",
// DbType = DBTypeEnum.Sqlite
//});
//if ( bankSqlHelper.TestConnection())
//{
// var result = bankSqlHelper.GetValue("select 1");
// Console.WriteLine(result);
//}
#endregion
}
static async Task Main(string[] args)
{
#region SqlServer
{
BankSqlHelper bankSqlHelper = new BankSqlHelper(new DbInfo
{
ServerName = "localhost",
DataBaseName = "test",
DbType = DBTypeEnum.SqlServer,
Password = "******",
UserName = "******",
Port = "1433"
});
if (await bankSqlHelper.TestConnectionAsync())
{
var result = await bankSqlHelper.GetValueAsync("select 1");
Console.WriteLine(result);
}
}
#endregion
#region Oracle
{
BankSqlHelper bankSqlHelper = new BankSqlHelper(new DbInfo
{
ServerName = "localhost",
DataBaseName = "fjzy",
DbType = DBTypeEnum.Oracle,
Password = "******",
UserName = "******",
Port = "1521"
});
if (await bankSqlHelper.TestConnectionAsync())
{
var result = await bankSqlHelper.GetValueAsync("select 1 from dual");
Console.WriteLine(result);
}
}
#endregion
#region Mysql
{
BankSqlHelper bankSqlHelper = new BankSqlHelper(new DbInfo
{
ServerName = "test",
DbType = DBTypeEnum.MySql,
Password = "******",
Port = "3306",
UserName = "******"
});
if (await bankSqlHelper.TestConnectionAsync())
{
var result = await bankSqlHelper.GetValueAsync("select 1");
Console.WriteLine(result);
}
}
#endregion
#region Sqlite
{
BankSqlHelper bankSqlHelper = new BankSqlHelper(new DbInfo
{
ConnString = "Db/LogData.sqlite",
DbType = DBTypeEnum.Sqlite
});
if (await bankSqlHelper.TestConnectionAsync())
{
var result = await bankSqlHelper.GetValueAsync("select 1");
Console.WriteLine(result);
}
}
#endregion
Console.WriteLine("Hello World!");
}
