如何建立一个网站平台网站,苏州企业名称大全,用竹片做的网站,莱芜上汽大众4s店以下为有网友公司的评估测试及使用规范 大家可以下载word看看 http://pan.baidu.com/s/1hquvRuc 一、和ADO.NET进行的压力测试 说明#xff1a;2000并发用户#xff0c;此图为一网友公司对moon.orm的测评 二、和ADO.NET的性能对比测试 说明#xff1a;同时请求10000条数据2000并发用户此图为一网友公司对moon.orm的测评 二、和ADO.NET的性能对比测试 说明同时请求10000条数据此图为一网友公司对moon.orm的测评 三、和实体框架的对比测试 using System;
using System.Collections.Generic;
using System.Data.Entity;
using System.Diagnostics;
using System.Linq;
using System.Text;
using Moon.Orm;
using EfTest.Models;
using eftest;
namespace EfTest
{class Program{private static readonly Stopwatch Watch new Stopwatch();static void Main(string[] args){Watch.Start();Database.SetInitializer(new SampleData());using (var db new TestContext()){db.Database.Initialize(false);}Watch.Stop();//Console.WriteLine(数据库初始化完成耗时{0}, Watch.Elapsed);Method01();StartTest();}private static void Method01(){Console.WriteLine(查询预热防止第一次查询影响结果。);var db new TestContext();Console.WriteLine(产品目录个数{0}, db.Categories.Count());Console.WriteLine(客户个数{0}, db.Customers.Count());Console.WriteLine(产品个数{0}, db.Products.Count());Console.WriteLine(订单个数{0}, db.Orders.Count());Console.WriteLine(订单明细个数{0}, db.OrderDetails.Count());db.Dispose();Console.WriteLine(查询预热结束-------------------------\r\n);}private static void StartTest(){Console.WriteLine(单表查询);EFTest1();MoonTest1();MoonDyanimic();Console.WriteLine();Console.WriteLine(连接查询);EFTestJoin();MoonTestJoin();Console.WriteLine();Console.WriteLine(嵌套查询);EFTestQianTao();MoonTestQianTao();Console.Read();}private static void EFTest1(){Watch.Restart();var db new TestContext();db.Configuration.AutoDetectChangesEnabledfalse;var list db.OrderDetails.Where(mm.DetailId1m.UnitPrice0).ToList();db.Dispose();Watch.Stop();Console.WriteLine( EFTest1:Watch.Elapsed);}private static void MoonTest1(){Watch.Restart();using (Db dbDb.CreateDefaultDb()) {var mql2OrderDetailsSet.SelectAll().Where(OrderDetailsSet.UnitPrice.BiggerThan(0).And(OrderDetailsSet.DetailId.BiggerThan(1)));var list2db.GetEntitiesOrderDetails(mql2);}Watch.Stop();Console.WriteLine(MoonTest1:Watch.Elapsed);}private static void MoonDyanimic(){using (Db dbDb.CreateDefaultDb()) {var list2db.GetDynamicList(select * from OrderDetails where DetailId10 ,hi);}Watch.Restart();using (Db dbDb.CreateDefaultDb()) {var mqlOrderDetailsSet.SelectAll();var list2db.GetDynamicList(select * from OrderDetails where DetailId1 and UnitPrice0 ,hi);}Watch.Stop();Console.WriteLine(MoonDyanimic:Watch.Elapsed);}private static void EFTestJoin(){Watch.Restart();var db new TestContext();db.Configuration.AutoDetectChangesEnabledfalse;var list db.OrderDetails.Where(mm.DetailId3m.UnitPrice0).Select(m new{m.DetailId,m.UnitPrice,m.Product.ProductName}).ToList();foreach (var A in list) {Console.WriteLine(A.DetailId A.UnitPrice A.ProductName);break;}db.Dispose();Watch.Stop();Console.WriteLine( EFTestJoin:Watch.Elapsed);}private static void MoonTestJoin(){Watch.Restart();using (Db dbDb.CreateDefaultDb()) {var mql2OrderDetailsSet.Select(OrderDetailsSet.DetailId,OrderDetailsSet.UnitPrice);var mqlProductsSet.Select(ProductsSet.ProductName);var joinmql.LeftJoin(mql2).ON(OrderDetailsSet.ProductId.Equal(ProductsSet.ProductId)).Where(OrderDetailsSet.UnitPrice.BiggerThan(0).And(OrderDetailsSet.DetailId.BiggerThan(3)));var list2db.GetDictionaryList(join);foreach (var A in list2) {Console.WriteLine(A[DetailId] A[UnitPrice] A[ProductName]);break;}}Watch.Stop();Console.WriteLine(MoonTestJoin:Watch.Elapsed);}private static void MoonTestQianTao(){Watch.Restart();using (Db dbDb.CreateDefaultDb()) {var mqlProductsSet.SelectAll().Where(ProductsSet.CategoryId.In(CategoriesSet.Select(CategoriesSet.CategoryId).Where(CategoriesSet.CategoryName.Equal(分类00))));var sqlmql.ToDebugSQL();var listdb.GetEntitiesProducts(mql);}Watch.Stop();Console.WriteLine(MoonTestQianTao:Watch.Elapsed);}private static void EFTestQianTao(){Watch.Restart();var db new TestContext();db.Configuration.AutoDetectChangesEnabledfalse;var list db.Products.Where(mm.Category.CategoryName.Equals(分类00)).ToList();db.Dispose();Watch.Stop();Console.WriteLine( EFTestQianTao:Watch.Elapsed);}}
}执行文件下载地址http://pan.baidu.com/s/1i3khc0H先在sqlserver数据库中建一个名为:TestContext的数据库,您只需修改配置文件中的连接字符串然后运行即可 以下为网友运行截图 转载于:https://www.cnblogs.com/humble/p/3472764.html
