public void SimpleSelect() { Net4.MySql.DataBase db = Connect(); var generator = new MySql.SqlGenerator(); db.LoadSchema(); Table historicoVentas = db.Schema.Tables.Where(t => t.Name == "historicoventa").Single(); Select select = new Select(); select.Table = historicoVentas; select.Columns.Add(new SelectColumn(historicoVentas["fecha"])); select.Columns.Add(new SelectColumn(historicoVentas["tipocambio"])); select.Columns.Add(new SelectColumn(historicoVentas["precio"])); Table cliente = db.Schema.Tables.Where(t => t.Name == "cliente").Single(); SelectJoin joinCliente = new SelectJoin(); joinCliente.Table = cliente; joinCliente.Columns.Add(new SelectColumn(cliente["RasonSocial"])); joinCliente.On.Add(new ColumnCompareFilter() { Column = historicoVentas["cliente"], ColumnToCompare = cliente["oid"] }); select.Where.Add(new RangeFilter() { Column = historicoVentas["fecha"], MinValue = DateTime.Now.AddYears(-1), MaxValue = DateTime.Now }); Command command = generator.Select(select); var result = db.GetDataTable(command); }