Any good guidance to data access strategy in .NET?
-
Hi, CP people. I'm developing a xml web service on .NET platform. Our team is on the line of start of project and I thought we should arrange some good strategy about data access on .NET platform. To all of us, this is the first project on .NET platform, so we feel the lack of know-how. Many choices are under progress. Ex> 1.Where we should locate the business logic? Client or server or where? 2.Should we write some wrapper classes encapsulating data objects in ado.net? 3.How we should connect to DB server and how to manage the connection? Of course, these choices depends on situation and differs to every one. So I'm questioning your answer on case of these 1,2,3 questions. Also any pointing to good guidance would be appreciated. TIA. Regards, Ryan. :)
-
Hi, CP people. I'm developing a xml web service on .NET platform. Our team is on the line of start of project and I thought we should arrange some good strategy about data access on .NET platform. To all of us, this is the first project on .NET platform, so we feel the lack of know-how. Many choices are under progress. Ex> 1.Where we should locate the business logic? Client or server or where? 2.Should we write some wrapper classes encapsulating data objects in ado.net? 3.How we should connect to DB server and how to manage the connection? Of course, these choices depends on situation and differs to every one. So I'm questioning your answer on case of these 1,2,3 questions. Also any pointing to good guidance would be appreciated. TIA. Regards, Ryan. :)
1. typical answer is on the server. that way you can write multiple clients easily. 2,3 I don't know, with .NET. -c
-
Hi, CP people. I'm developing a xml web service on .NET platform. Our team is on the line of start of project and I thought we should arrange some good strategy about data access on .NET platform. To all of us, this is the first project on .NET platform, so we feel the lack of know-how. Many choices are under progress. Ex> 1.Where we should locate the business logic? Client or server or where? 2.Should we write some wrapper classes encapsulating data objects in ado.net? 3.How we should connect to DB server and how to manage the connection? Of course, these choices depends on situation and differs to every one. So I'm questioning your answer on case of these 1,2,3 questions. Also any pointing to good guidance would be appreciated. TIA. Regards, Ryan. :)
You are in luck, visit MSDN and there is a new article just on the topics you want. .NET Data Access Architecture Guide I found it very useful regards, Paul Watson Bluegrass Cape Town, South Africa "The greatest thing you will ever learn is to love, and be loved in return" - Moulin Rouge Martin Marvinski wrote: Unfortunatly Deep Throat isn't my cup of tea Do you Sonork? I do! 100.9903 Stormfront
-
You are in luck, visit MSDN and there is a new article just on the topics you want. .NET Data Access Architecture Guide I found it very useful regards, Paul Watson Bluegrass Cape Town, South Africa "The greatest thing you will ever learn is to love, and be loved in return" - Moulin Rouge Martin Marvinski wrote: Unfortunatly Deep Throat isn't my cup of tea Do you Sonork? I do! 100.9903 Stormfront