Пример #1
0
		public static void Main(string[] args) {
			var conString = string.Format("SERVER={0};UID={1};PASSWORD={2};DATABASE={3};", 
				"localhost", "root", "", "schule_hr"
			);
			var config = new ConnectionStringSettings("local", conString);

			
			//var con = new GodLesZ.Library.MySql.Data.MySqlClient.MySqlConnection(conString);
			//con.Open();

			dynamic table = new MysqlTestCountries(config);
			var results = table.Find(region_id : 1);
			Console.WriteLine("-- All with region_id = 1");
			foreach (var row in results) {
				Console.WriteLine("{0} | {1} | {2}", row.COUNTRY_ID, row.COUNTRY_NAME, row.REGION_ID);
			}

			Console.Read();
		}
Пример #2
0
        public static void Main(string[] args)
        {
            var conString = string.Format("SERVER={0};UID={1};PASSWORD={2};DATABASE={3};",
                                          "localhost", "root", "", "schule_hr"
                                          );
            var config = new ConnectionStringSettings("local", conString);


            //var con = new GodLesZ.Library.MySql.Data.MySqlClient.MySqlConnection(conString);
            //con.Open();

            dynamic table   = new MysqlTestCountries(config);
            var     results = table.Find(region_id: 1);

            Console.WriteLine("-- All with region_id = 1");
            foreach (var row in results)
            {
                Console.WriteLine("{0} | {1} | {2}", row.COUNTRY_ID, row.COUNTRY_NAME, row.REGION_ID);
            }

            Console.Read();
        }