View Complete Post
I need help to make decision for making framework for new project.Project is financing (banking) project. It'll b using .net 3.5 sp1 with sql server 2005.I want to know what should be best approach for framework? Mean to use LINQ or go with Stored procedure way with 3 tier architecture?or anything else?
For current financing project the framework is done by one of MVP. He used LINQ to all things.But we facing problem of w3wp process hang. We cant go for web gardening or farming bcz LINQ objects cnt be serialized to store in Session etc.Difficult to use Transactions in LINQ. Have to use TransactionScope lead to MSDTC problems etc.
Please give your opinion.
For handy database interface, is it good to use SqldataSources exclusively intead of EntLib functions?
Thanks for any feedback.