Reputation: 6030
I know that SharePoint 2010 uses .net 3.5 and since .net 2 (3.5 with sp1) has different CLR than .net 4, what is the best practice to use Entity Framework 4 (4.2) with it? Is the web service (WCF service) the only solution for it?
If not, what is the best ORM similar to EF from simplicity and productivity prospective is recommended to use to connect to MS SQL Server? (may support oracle later)?
Upvotes: 0
Views: 532
Reputation: 364279
Is the web service (WCF service) the only solution for it?
Yes. You have to do cross process call because your main process is .NET 3.5 and you need another process running .NET 4.0.
What is the best ORM similar to EF from simplicity and productivity prospective is recommended to use to connect to MS SQL Server? (may support oracle later)?
Other alternatives are for example NHibernate or LLBGen Pro. Both are supported in .NET 3.5. You can also try Linq-To-Sql or SubSonic.
Upvotes: 1