SqlServer与MongoDB结合使用NHibernate资源-CSDN文库

196 浏览量 2020-12-16 09:47:49 上传评论收藏 81KB PDF 举报

资源推荐

资源详情

资源评论

SqlServer与与MongoDB结合使用结合使用NHibernate

本文实例为大家分享了SqlServer与MongoDB结合使用NHibernate的代码，供大家参考，具体内容如下

Program.cs代码内容:

class Program

{

private const string SqlServerConnectionString =

@"Data Source=.;Initial Catalog=SqlWithMongo;Persist Security Info=True;User ID=sa;Password=123456";

private const string MongoConnectionString = "mongodb://localhost:27017";

private const int NumberOfNodes = 1000;

private static void Main(string[] args)

{

Console.WriteLine("Clearing database...");

ClearDatabases();

Initer.Init(SqlServerConnectionString, MongoConnectionString);

Console.WriteLine("Completed");

Console.WriteLine("Creating nodes...");

//创建sqlserver的Node节点

CreateNodes();

Console.WriteLine("Completed");

Console.WriteLine("Linking nodes...");

long milliseconds1 = LinkSqlNodes(); //创建sqlserver的LinkNode节点

Console.WriteLine("SQL : " + milliseconds1);

long milliseconds2 = LinkMongoNodes(); //同时创建Node,LinkNode节点

Console.WriteLine("Mongo : " + milliseconds2);

Console.WriteLine("Completed");

Console.WriteLine("Fetching nodes...");

long milliseconds3 = FetchSqlNodes(); //取出sqlserver节点数据

Console.WriteLine("SQL : " + milliseconds3);

long milliseconds4 = FetchMongoNodes(); //取出Mongodb节点数据

Console.WriteLine("Mongo : " + milliseconds4);

Console.WriteLine("Completed");

Console.ReadKey();

}

private static long FetchMongoNodes()

{

var stopwatch = new Stopwatch();

stopwatch.Start();

for (int i = 0; i < NumberOfNodes; i++)

{

using (var unitOfWork = new UnitOfWork())

{

var repository = new MongoNodeRepository(unitOfWork);

MongoNode node = repository.GetById(i + 1);

IReadOnlyList<NodeLink> links = node.Links;

}

}

stopwatch.Stop();

return stopwatch.ElapsedMilliseconds;

}

private static long FetchSqlNodes()

{

var stopwatch = new Stopwatch();

stopwatch.Start();

for (int i = 0; i < NumberOfNodes; i++)

{

剩余8页未读，继续阅读

内容反馈

weixin_38700430

粉丝: 3
资源: 914

最新资源

资源上传下载、课程学习等过程中有任何疑问或建议，欢迎提出宝贵意见哦~我们会及时处理！点击此处反馈

feedback-tip