关于.net下的Data Access技术

flyspirit

权威人士Scott Hanselman最近写了一个关于Data Access方法。包括

DataReader, DataSet, LINQ to SQL, EF 4 and Nhibernate.

他的建议是使用EF4和NHibernate

Conclusion

There's lots of choices for Database Access on .NET. You'll run into DataReaders in older or highly tuned code, but there's no reason it can't be hidden in a Repository and still be pleasant to use. LINQ to SQL is nice, lightweight and fast and has dozens of bug fixes in .NET 4, but Entity Framework is the way they are heading going forward. Plus, Entity Framework 4 is *way* better than EF 3.5, so I'm using it for any "larger than small" projects I'm doing and I'm not having much trouble. NHibernate is very mature, actively developed and has a great community around it and it's not going anywhere.

In my opinion, if you're doing database access with .NET you should be using Entity Framework 4 or NHibernate.

原贴连接：http://www.hanselman.com/blog/Ex ... +ComputerZen.com%29

dalaohu

Since when did Scott hanselman become a 权威人士 ??  He's no body but a diabetic with a black wife.

Every souround him is way better than him.  

Love his podcast thought.

coolioo

谢谢，有空研究一下

阿Ka

原帖由 dalaohu 于 2010-6-3 11:13 发表
Since when did Scott hanselman become a 权威人士 ??  He's no body but a diabetic with a black wife.

Every souround him is way better than him.  

Love his podcast thought.

i服了u

dalaohu

原帖由 阿Ka 于 2010-6-3 11:22 发表


i服了u

he interviewed one of my colleague. I know him well

he's loud person. Only thing him good at is making noise

o2h2o

原帖由 dalaohu 于 2010-6-3 11:13 发表
Since when did Scott hanselman become a 权威人士 ??  He's no body but a diabetic with a black wife.

Every souround him is way better than him.  

Love his podcast thought.

太歧视了吧

flyspirit

原帖由 dalaohu 于 2010-6-3 11:13 发表
Since when did Scott hanselman become a 权威人士 ??  He's no body but a diabetic with a black wife.

Every souround him is way better than him.  

Love his podcast thought.

I don't think your discrimination will be welcomed here.

How you can declare you know somebody well just because your colleague was interviewed by him?

dalaohu

U got me wrong.
I love him personally

But in tech world u don't want to quote anything he says. Make yourself look bad

flyspirit

原帖由 dalaohu 于 2010-6-3 12:00 发表
U got me wrong.
I love him personally

But in tech world u don't want to quote anything he says. Make yourself look bad

Maybe you are stronger then him technically. But don't use discriminative words, it makes you look immature.

Anyway, do you have some blogs to recommendation, how about ScottGu?

dalaohu

Yes scottgu is way official

and the actually product manager. Tech leaders

coin_king

Entity Framework 是将来的趋势, LINQ to Entities converts Language-Integrated Queries (LINQ) queries to command tree queries, executes the queries against the Entity Framework, and returns objects that can be used by both the Entity Framework and LINQ.

flyspirit

Any other guys you think good and has blog worthy to read?

dhcnec

Every souround him is way better than him.   什么意思？

dalaohu

原帖由 flyspirit 于 2010-6-3 12:15 发表
Any other guys you think good and has blog worthy to read?

my blog

乱码

个人习惯问题吧,我个人就很不喜欢用linq 去query database,在.net developer这个角度来说可以说是一种query的方式，但dba能找出N条理由来拒绝。

把sp看作database的api来consume对我来说更加make sense

用linq对其他的都还行，object/xml...或者其他的任意的3rd party..amazon什么的.
但对database,我很抵制。

乱码

原帖由 flyspirit 于 2010-6-3 12:15 发表
Any other guys you think good and has blog worthy to read?

给你推荐一个大牛的，如果你对key value store database比较感兴趣的话。

http://alpha.mixi.co.jp/blog/?author=3

反正我基本上是看不懂

flyspirit

原帖由 dalaohu 于 2010-6-3 12:36 发表


my blog

link?

flyspirit

原帖由 乱码 于 2010-6-3 13:31 发表


给你推荐一个大牛的，如果你对key value store database比较感兴趣的话。

http://alpha.mixi.co.jp/blog/?author=3

反正我基本上是看不懂

你这是日文的，怎么看啊。

乱码

我个人觉得如果把眼光放宽些，如很多open source的frame work，可能更加有利有developer素质的修养，毕竟当今top tier web sites除了stackoverflow(asp.net mvc)&msdn的论坛（速度实在不敢恭维）,没有几个用.net开发的，看看几个上千万用户的网站，如facebook,twitter,他们的sign,对我们还是很有借鉴意义的。asp.net尽管商业上很成功，但对我的感觉始终是面对中小网站，stackoverflow也是刚成名没多久。

同行的.net developer别跟我急啊，我也是瞎说滴

[ 本帖最后由 乱码 于 2010-6-3 13:50 编辑 ]

乱码

原帖由 flyspirit 于 2010-6-3 13:46 发表


你这是日文的，怎么看啊。

我说过我也看不懂.

但这哥们是Tokyo Cabinet/Tyrant的author，极其牛B的人.

咱们中国人就没有这个级别的人物。

flyspirit

原帖由 乱码 于 2010-6-3 13:47 发表
我个人觉得如果把眼光放宽些，如很多open source的frame work，可能更加有利有developer素质的修养，毕竟当今top tier web sites除了stackoverflow(asp.net mvc)&msdn的论坛（速度实在不敢恭维）,没有几个用.net开发 ...

这只是表面现象。你举的例子都是社区网站，这些网站出于成本考虑没法去买微软的产品。facebook如果用微软，早就把钱烧光了。

但如果你看公司网站，用.net的并不少，而且有增加趋势。

其实问题就是你想自己创业还是打工，创业的话肯定用open source, 打工就去用微软的东西。

cdfei

八哥压路
EF4是要比EF3.5好很多，我正在用，特别是对POPC的支持，让你可以仅仅在数据访问层使用它，比以前灵活。

原帖由 flyspirit 于 2010-6-3 13:46 发表


你这是日文的，怎么看啊。

cdfei

还是能节约不少写SQL语句的时间的。。。。。。

原帖由 乱码 于 2010-6-3 13:26 发表
个人习惯问题吧,我个人就很不喜欢用linq 去query database,在.net developer这个角度来说可以说是一种query的方式，但dba能找出N条理由来拒绝。

把sp看作database的api来consume对我来说更加make sense

用linq ...

flyspirit

原帖由 cdfei 于 2010-6-3 14:04 发表
还是能节约不少写SQL语句的时间的。。。。。。

Yes, improve productivity.

乱码

原帖由 flyspirit 于 2010-6-3 13:52 发表


这只是表面现象。你举的例子都是社区网站，这些网站出于成本考虑没法去买微软的产品。facebook如果用微软，早就把钱烧光了。

但如果你看公司网站，用.net的并不少，而且有增加趋势。

其实问题就是你想自己 ...

community website才能很明显看出traffic/用户，我是从这个意义上才说的facebook&twitter，而且他们从来也不缺钱，而且ms是facebook最大的投资伙伴(paid $240 million in 2007 for a 1.6% stake)
http://money.cnn.com/2009/04/15/ ... k.fortune/index.htm
从技术上来说合作就更加是水到渠成的事，为什么不用.net，我觉得还是由它自己的原因吧.

公司网站用.net不少，但有特定功能的网站，.net就少很多了，而且对于大集群数据量的distributed database的支持，sql server只牵强的提供linked server,连入门级都算不上。

在澳洲这地方，看看咱们坛子里的兄弟就知道了，除了c#就是delphi,真正做到成功的framework这个级别的有多少？（可能我眼光受限，除了dalaohu ,没有看到其他大牛）全都是用人家现成的framework作app,这没什么错，但反映澳洲的定位就是二级开发，没有实力作自己的东西。

至于创业，我自认为还真没这个技术能力，也就是跟着人家嚷嚷两声，凑个热闹，还是老老实实打工来的实在。

dalaohu

原帖由 乱码 于 2010-6-3 13:47 发表
我个人觉得如果把眼光放宽些，如很多open source的frame work，可能更加有利有developer素质的修养，毕竟当今top tier web sites除了stackoverflow(asp.net mvc)&msdn的论坛（速度实在不敢恭维）,没有几个用.net开发 ...

Stackoverflow is nothing. Only 12 tables.

You forgot to mention hotmail

Is it just me   Mark Suckerberg looks like a retarded dumbass.

乱码

原帖由 cdfei 于 2010-6-3 14:04 发表
还是能节约不少写SQL语句的时间的。。。。。。

它肯定是能工作，我主要是指它的性能。

dalaohu

原帖由 flyspirit 于 2010-6-3 14:06 发表


Yes, improve productivity.

improve how? If u hv a dedicated SQL team sitting there

dalaohu

I hv to admit that my SQL skill is going downhill in recent years.

All the multi million projects have a big SQL team. I hvnt written any queries for long time.

cdfei

用的当，性能不是大问题，你可以监控它生成的SQL语句，基本上是精炼的。
配合做一些缓存方面的设计，我个人认为可以一用。

原帖由 乱码 于 2010-6-3 14:16 发表

它肯定是能工作，我主要是指它的性能。