Take the 2-minute tour ×
Programmers Stack Exchange is a question and answer site for professional programmers interested in conceptual questions about software development. It's 100% free, no registration required.

Iam new with .Net technology and i need a help with choosing correct path of creating application. I want to create application that get its data from web-service and small part from local SQLCE database.

Mainly I have problems with database access and making database access clean in code.

What .Net technology should i choose to accomplish that in good way with clean and easy to maintained code.

share|improve this question
1  
You probably need to do a search on the term 'ORM' or 'OR Mapper'. You'll find some popular ways to make a relative clean DAL. (hint: NHibernate, LLBLGEN, EF4.0) –  Jan_V Mar 22 '11 at 12:09
    
Which version of CE are you leaning towards: 3.5 or 4.0? –  JeffO Mar 22 '11 at 12:21

1 Answer 1

Database access in .NET is done through ADO.NET layer. You can access your data directly with pure ADO.NET (sending SQL commands) or use ORM tools like LINQ to SQL or Entity Framework. I would recommend to choose the ORM tool (for example LINQ to SQL - there are lots of tutorials around the web) if you want to do/learn things faster and you don't want to mess with SQL.

share|improve this answer
    
I would also add that since some data is coming from a web service and some from a local database, you want an ORM that supports POCO entities. That way, the entity can potentially be persisted to either place. I know that both NHibernate and (supposedly v4 of) Entity Framework support POCO entities. –  Scott Whitlock Mar 22 '11 at 12:24

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.