static void RunL2s() { using (var db = new testDataContext()) { db.Log = Console.Out; var q = from t in db.tables select new { TableName = t.name, ColumnCount = t.all_columns.Count() }; foreach (var t in q) { Console.WriteLine("{0} {1}", t.TableName, t.ColumnCount); } } using (var otherDB = new other.otherDataContext()) { var prods = from p in otherDB.Products select p; DataTable t = prods.Take(10).ToDataTable(); t.WriteXml(Console.Out); } }
static void Main(string[] args) { System.Diagnostics.Stopwatch watch = new System.Diagnostics.Stopwatch(); watch.Start(); testDataContext db = new testDataContext(); Table <BCS_District> district = db.GetTable <BCS_District>(); db.Log = Console.Out; //IQueryable<BCS_District> query = from a in district where a.DepartmentCode == "21" select a; //foreach (var item in query) //{ // Console.WriteLine(item.DistrictName, item.CreateDT); //} //// IQueryable<BCS_Charge> query = db.BCS_Charge.Take<BCS_Charge>(100000); ////查询方法 //IQueryable<BCS_District> query1 = db.BCS_District.Where<BCS_District>(x=>x.Dis_ID>3); //查询语法 //db.Log = Console.Out; IQueryable <BCS_District> query2 = from x in district where x.Dis_ID >= 3 select x; watch.Stop(); Console.WriteLine(query2); Console.WriteLine(watch.ElapsedMilliseconds); watch.Restart(); string sql = @"SELECT TOP 100000 [Charge_ID] ,[InvoiceCode],[PriceMonth_ID],[BM_ID] ,[GetMoneyTime] ,[DepartmentCode] ,[CM_ID] ,[UsedWaterNumber] ,[GetMoney] ,[BankOfDeposit] ,[GetMoneyPersonId] ,[GetMoneyPersonName] ,[state] ,[PlanMoney] ,[LastBalance] ,[ThisBalance] ,[InvoiceOver] ,[BookOver] ,[OldInvoiceCode] ,[PosYn] ,[PosMoney] ,[CardType] ,[AdvanceYn] ,[MoneyType] ,[BalanceDt] ,[AdvanceReturn] ,[CreateDT] ,[ReviseDT] ,[Creator] ,[Operator] ,[Old定价] ,[Old年月] ,[Old客户] ,[Old水表] ,[Old支付方式] ,[OldUser] ,[otherOrderCode] FROM [FFSLJ].[dbo].[BCS_Charge]"; ExcuteTable(sql, CommandType.Text); watch.Stop(); Console.WriteLine(watch.ElapsedMilliseconds); Console.ReadKey(); }