示例#1
0
        public void LicenseTest2()
        {
            var access = new ALinq.DataContext("C:/Northwind.mdb", typeof(ALinq.Access.AccessDbProvider))
            {
                Log = Console.Out
            };
            var q = access.GetTable <Customer>().ToList();

            var sqlLite = new ALinq.DataContext("C:/Northwind.db3", typeof(ALinq.SQLite.SQLiteProvider))
            {
                Log = Console.Out
            };

            q = sqlLite.GetTable <Customer>().ToList();

            var conn  = MySqlNorthwind.CreateConnection("root", "test", "Northwind", NorthwindDatabase.DB_HOST, 3306).ConnectionString;
            var mysql = new ALinq.DataContext(conn, typeof(ALinq.MySQL.MySqlProvider))
            {
                Log = Console.Out
            };

            q = mysql.GetTable <Customer>().ToList();

            conn = OracleNorthwind.CreateConnection("Northwind", "test", "vpc1").ConnectionString;
            var oracle = new ALinq.DataContext(conn, typeof(ALinq.Oracle.OracleProvider))
            {
                Log = Console.Out
            };

            q = oracle.GetTable <Customer>().ToList();

            conn = OdpOracleNorthwind.CreateConnection("Northwind", "test", "vpc1").ConnectionString;
            var odpOracle = new ALinq.DataContext(conn, typeof(ALinq.Oracle.Odp.OracleProvider))
            {
                Log = Console.Out
            };

            q = oracle.GetTable <Customer>().ToList();

            conn = "User=SYSDBA;Password=masterkey;Database=Northwind;DataSource=vpc1;ServerType=0";
            var firebird = new ALinq.DataContext(conn, typeof(ALinq.Firebird.FirebirdProvider))
            {
                Log = Console.Out
            };

            q = firebird.GetTable <Customer>().ToList();

            conn = "DataBase=SAMPLE;USER ID=db2admin;Password=test;Server=VPC1";
            var db2 = new ALinq.DataContext(conn, typeof(ALinq.DB2.DB2Provider))
            {
                Log = Console.Out
            };

            q = db2.GetTable <Customer>().ToList();
        }
示例#2
0
        public void temp()
        {
            //var formatFlags = QueryFormatOptions.None;
            //Assert.AreEqual(formatFlags & QueryFormatOptions.SuppressSize, QueryFormatOptions.None);
            var context = new ALinq.DataContext("C:/Northwind.mdb", typeof(ALinq.Access.AccessDbProvider));
            var product = context.GetTable <Product>();
            var tables  = context.Mapping.GetTables().ToArray();

            Console.WriteLine(tables.Count());
        }