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!"); }