Print Page | Close Window

DevForce using SQL Server 2005 CE

Printed From: IdeaBlade
Category: DevForce
Forum Name: DevForce Classic
Forum Discription: For .NET 2.0
URL: http://www.ideablade.com/forum/forum_posts.asp?TID=328
Printed Date: 11-Jun-2026 at 4:35pm


Topic: DevForce using SQL Server 2005 CE
Posted By: 3stan
Subject: DevForce using SQL Server 2005 CE
Date Posted: 26-Jul-2007 at 3:14am
Hi,
 
Do DevForce support the SQL Server 2005 CE as its main Data Source? Because from your Object Mapper in choosing Data Source I cannot see the SQL Server Modile as a provider.
 
Thanks,
Mark


Replies:
Posted By: pkarsh
Date Posted: 31-Jul-2007 at 1:22pm
The Object Mapper (OM) connection requires an OLEDB provider as the OLEDB provider supports the data definition language (DDL) commands that OM needs to discover tables and columns in order to generate business object classes. I installed SQL Server Compact Edition on one of my (virtual) machines. I could see that the install included a dll whose name strongly suggested that it was an OLEDB provider, but the CE install did not do what needs to be done to make this provider visible to the system. If I open up a UDL file (totally outside the scope of DevForce) a list of OLEDB providers is shown but not one for SQL Server CE. Does anyone have any idea what I need to do to make this provider visible to the system?

Posted By: Linguinut
Date Posted: 31-Jul-2007 at 1:34pm
To program against SSCE, you use an ADO.NET managed provider with data access coding patterns similar to what you use for other managed providers, such as the SQL Server SQLClient managed provider. You can also access SSCE from unmanaged clients by using OLE DB.
 
from http://msdn2.microsoft.com/en-us/library/bb380177.aspx - http://msdn2.microsoft.com/en-us/library/bb380177.aspx
 
Not sure if that helps, but it might mean something to you,
Bill

Posted By: rbblack
Date Posted: 22-Aug-2007 at 10:01am
Is this the official answer for this thread?  I'd also like to know.  Sorry, I'm a newb, does the Devforce team answer these posts?

Posted By: pkarsh
Date Posted: 22-Aug-2007 at 11:27am
We do answer these posts. We have a project underway to evaluate the use of SQL Server CE with DevForce but we haven't gotten any positive results yet. As noted above, we require an OLEDB provider to do the data object mapping that is the foundation for DevForce application development, and we haven't yet been able to bring up an OLEDB provider that connects to the CE server.

Posted By: davidklitzke
Date Posted: 19-Oct-2007 at 1:57pm
SQL Server CE will be supported in DevForce 3.5.5.1 which is projected to release on November 1, 2007.

Posted By: Linguinut
Date Posted: 19-Oct-2007 at 2:00pm
David,
 
Please enter this as an announcement under a new thread.  Some may not follow this thread, so may not become aware of the good news.
 
Thanks,
Bill


Print Page | Close Window