public static void Main(string[] args) { Console.WriteLine("Hello World!"); OrmLiteConfig.DialectProvider = new FirebirdOrmLiteDialectProvider(); using (IDbConnection db = "User=SYSDBA;Password=masterkey;Database=employee.fdb;DataSource=localhost;Dialect=3;charset=ISO8859_1;" .OpenDbConnection()) { try { var employees = db.Select <Employee>(); Console.WriteLine("Total Employees '{0}'", employees.Count); Employee employee = new Employee() { FirstName = "LILA", LastName = "FUTURAMA", PhoneExtension = "0002", HireDate = DateTime.Now, DepartamentNumber = "900", JobCode = "Eng", JobGrade = 2, JobCountry = "USA", Salary = 75000 }; int count = employees.Count; db.Insert(employee); Console.WriteLine("Id for new employee : '{0}'", employee.Id); employees = db.Select <Employee>(); Console.WriteLine("Total Employees '{0}' = '{1}'", employees.Count, count + 1); Console.WriteLine("Executing 'DELETE_EMPLOYEE' for '{0}' - {1}", employee.Id, employee.LastName); ProcedureDeleteEmployee de = new ProcedureDeleteEmployee(); de.EmployeeNumber = employee.Id; db.ExecuteProcedure(de); employees = db.Select <Employee>(); Console.WriteLine("Total Employees '{0}'= '{1}' ", employees.Count, count); } catch (Exception e) { Console.WriteLine(e.Message); } try { ProcedureSubTotalBudgetParameters p = new ProcedureSubTotalBudgetParameters() { HeadDepartament = "000" }; var results = db.SelectFromProcedure <ProcedureSubTotalBudgetResult>(p, ""); foreach (var r in results) { Console.WriteLine("r.Total:{0} r.Average:{1} r.Max:{2} r.Min:{3}", r.Total, r.Average, r.Max, r.Min); } } catch (Exception e) { Console.WriteLine(e.Message); } try { ProcedureShowLangsParameters l = new ProcedureShowLangsParameters() { Code = "Sales", Grade = 3, Country = "England" }; var ls = db.SelectFromProcedure <ProcedureShowLangsResult>(l, ""); foreach (var lr in ls) { Console.WriteLine(lr.Language); } } catch (Exception e) { Console.WriteLine(e.Message); } try { ProcedureAllLangs l = new ProcedureAllLangs(); //var ls = db.SelectFromProcedure<ProcedureAllLangsResult>(l); //db.SelectFromProcedure(l); var ls = l.Execute(db); // better ? foreach (var lr in ls) { Console.WriteLine("lr.Code:{0} lr.Country:{1} lr.Grade:{2} lr.Language:{3}", lr.Code, lr.Country, lr.Grade, lr.Language); } } catch (Exception e) { Console.WriteLine(e.Message); } Console.WriteLine("This is The End my friend!"); } }
public static void Main(string[] args) { Console.WriteLine("Hello World!"); OrmLiteConfig.DialectProvider = new FirebirdOrmLiteDialectProvider(); using (IDbConnection db = "User=SYSDBA;Password=masterkey;Database=employee.fdb;DataSource=localhost;Dialect=3;charset=ISO8859_1;".OpenDbConnection()) { try { var employees = db.Select<Employee>(); Console.WriteLine("Total Employees '{0}'", employees.Count); Employee employee = new Employee() { FirstName = "LILA", LastName = "FUTURAMA", PhoneExtension = "0002", HireDate = DateTime.Now, DepartamentNumber = "900", JobCode = "Eng", JobGrade = 2, JobCountry = "USA", Salary = 75000 }; int count = employees.Count; db.Insert(employee); Console.WriteLine("Id for new employee : '{0}'", employee.Id); employees = db.Select<Employee>(); Console.WriteLine("Total Employees '{0}' = '{1}'", employees.Count, count + 1); Console.WriteLine("Executing 'DELETE_EMPLOYEE' for '{0}' - {1}", employee.Id, employee.LastName); ProcedureDeleteEmployee de = new ProcedureDeleteEmployee(); de.EmployeeNumber = employee.Id; db.ExecuteProcedure(de); employees = db.Select<Employee>(); Console.WriteLine("Total Employees '{0}'= '{1}' ", employees.Count, count); } catch (Exception e) { Console.WriteLine(e.Message); } try { ProcedureSubTotalBudgetParameters p = new ProcedureSubTotalBudgetParameters() { HeadDepartament = "000" }; var results = db.SqlProcedure<ProcedureSubTotalBudgetResult>(p, ""); foreach (var r in results) { Console.WriteLine("r.Total:{0} r.Average:{1} r.Max:{2} r.Min:{3}", r.Total, r.Average, r.Max, r.Min); } } catch (Exception e) { Console.WriteLine(e.Message); } try { ProcedureShowLangsParameters l = new ProcedureShowLangsParameters() { Code = "Sales", Grade = 3, Country = "England" }; var ls = db.SqlProcedure<ProcedureShowLangsResult>(l, ""); foreach (var lr in ls) { Console.WriteLine(lr.Language); } } catch (Exception e) { Console.WriteLine(e.Message); } try { ProcedureAllLangs l = new ProcedureAllLangs(); //var ls = db.SelectFromProcedure<ProcedureAllLangsResult>(l); //db.SelectFromProcedure(l); var ls = l.Execute(db); // better ? foreach (var lr in ls) { Console.WriteLine("lr.Code:{0} lr.Country:{1} lr.Grade:{2} lr.Language:{3}", lr.Code, lr.Country, lr.Grade, lr.Language); } } catch (Exception e) { Console.WriteLine(e.Message); } Console.WriteLine("This is The End my friend!"); } }