static void Main(string[] args)
{
SQLCmd.Connection = DataBaseFactory.Create(new MySqlConnection());
// SQLCmd.Insert("trading_test", "Securities").Values("NAME", "TEST2");
//insert into trading_test.indices (NAME,DESCRIPTION,ASSETCLASS_ID)values('TEST','DAS IST EINE DESCRIPTIOID_N',100)
//SQLCmd.Insert("trading_test", "indices").Values(
// "NAME", "TEST",
// "DESCRIPTION", "DAS IST EINE DESCRIPTION",
// "ASSETCLASS_ID", 10);
var lstIndices = new List <Indices>();
var cmd = SQLCmd.Select("trading_test", "indices").Fields("NAME,DESCRIPTION,ASSETCLASS_ID");
foreach (var item in cmd.QueryObjects <Indices>())
{
lstIndices.Add(item);
}
SQLCmd.Connection.Dispose();
// SQLCmd.Execute();
//var sqlCmd = new MySQLCommandBuilder();
//sqlCmd.Create();
//sqlCmd.Insert("trading_test", "Securities").Values("NAME", "TEST");
//DataBaseHelper.OpenConnection();
}
public static SQLCmd Insert(string database, string table)
{
CheckConnection();
_db = database;
_table = table;
var cmd = new SQLCmd(Connection, SQLCommandTypes.Insert);
return(cmd);
}
public static IDataReader CreateQuery(SQLCmd sqlCmd, DbConnection con, MySQLCommandBuilder builder)
{
try
{
_dbCon = con;
_dbCmd = con.CreateCommand();
_dbCmd.CommandText = builder.CmdBuilder.ToString();
return(_dbCmd.ExecuteReader());
}
catch (Exception ex)
{
Console.WriteLine(ex.Message);
}
return(null);
}
public static IDataReader Query(SQLCmd sqlCmd)
{
return(DbTools.CreateQuery(sqlCmd, Connection, _builder));
}