tags:

views:

314

answers:

1
Q: 

ORM for Compact Framework 3.5 winforms app with external ms sql server 2005

Hello,

I'm building a .NET CF 3.5 application that will communicate with an server based MS SQL server 2005.

The communication will happen trough the devices's WiFi connection.

I've been looking for a good O/R mapper and am a bit lost. Most sites/people assume that you're going to work with a local compact database and not with an external "normal" SQL server.

In the past, I've worked with entityspaces (but that seems to be commercial now?) and lately with linq-to-sql.

What good easy to learn & implement O/R mappers run on a .NET CF app with normal MS SQL database?

+1  A: 

I did this a few years ago with .NET 1.1 and LLBLGen with great success.

Bob  2009-05-26 14:31:56
hmmm, is also not free to use. :(
Thomas Stock  2009-05-26 14:57:31
Nope, but it is well worth the price in my opinion. Give it a try though, the code that gets generated isn't limited in the trial. The designer will expire and you won't be able to regen, but you can continue to use what ever was generated in the past.
Bob  2009-05-26 15:24:46
@bob: although in the demo EULA it says that you can't use the generated code after the trial expired ;) I'm not THAT generous, Bob ;)
Frans Bouma  2009-05-26 19:16:26
Frans, how, HOW do you do it? Do you ever sleep? Do you have clones? How are you everywhere like this and still have time to write LLBLGen, which is awesome product by the way.
CJCraft.com  2009-05-27 14:38:39

related questions

SQL Server, convert a named instance to default instance?
Natural (human alpha-numeric) sort in Microsoft SQL 2005
In MS SQL Server 2005, is there a way to export, the complete maintenance plan of a database as a SQL Script?
Does ReadUncommitted imply NoLock
Query to list all tables that contain a specific column with SQL Server 2005.
Can I maintain state between calls to a SQL Server UDF?
What are the benefits of using partitions with the Enterprise edition of SQL 2005
Upgrading Sharepoint 3.0 to SQL 2005 Backend?
What's the simplest way to execute a query in Visual C++
Can you perform an AND search of keywords using FREETEXT() on SQL Server 2005?
Create a database from another database?
What's the fastest way to bulk insert a lot of data in SQL Server (C# client)
SQL 2005 Book For Optimization Techniques
How do I create a mapping table in SQL Server Management Studio?
Cannot Add a Sql Server Login
SQL Server 2005 - Export table programatically (run a .sql file to rebuild it)
Diagnosing Deadlocks in SQL Server 2005
SQL2005: Linking a table to multiple tables and retaining Ref Integrity?
How to create a new instance of Sql Server 2005
SQL Server 2008 vs 2005 Linq integration
How do you kill all current connections to a SQL Server 2005 database?
Conditional Visibility and Page Breaks with SQL Server 2005 Reporting Services
SQL Server 2005 and 2008 on same developer machine?
Paging SQL Server 2005 Results
SQL 2005 For XML Explicit - Need help formatting