SharpDevelop Community

I am creating a Compact Framework application in sharpDevelop 2.1.

I want to work with SQL Server 2005 Compact Edition. When I create a SqlCeConnection object the compiler complains:

The type 'System.Data.Common.DbConnection' is defined in an assembly that is not referenced. You must add a reference to assembly 'System.Data, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089'. (CS0012) - C:\Documents and Settings\Paulus Janssen\My Documents\SharpDevelop Projects\pdaApp\MainForm.cs:131,4

I have a reference to System.Data.

This does not happen in a normal windows application.

It should be possible to work with SqlServerCe in a Compact Framework application, or am I wrong?

Paulus.

As this post dont get to bug tracking database (at least I dont find it) I like to reinforce this issue.

I have same problem but with SharpDevelop 2.2.1.

I found this post: http://forums.microsoft.com/msdn/ShowPost.aspx?PostID=1439620&SiteID=1 where the user submit a possible solution he finded, but his solution do not work for me, prossible that he uses #Dev 2.1 and #Dev 2.2 has some increased capabilities with compact framework development making his sugestion not functional.

I think that I found a workaround for this.

I was using SQLCE 3.1, than I remove it and installed a new SQLCE 3.5.
SQLCE 3.5 do not created an entry on GAC for System.Data.SqlServerCE, than I make a direct reference to "System.Data.SqlServerCe.dll" located on "...\Microsoft SQL Server Compact Edition\v3.5\Devices" and now the error messages was gone.

I can compile e run a simple test program, and it works ok.

I do not know if it is a #D bug with references of files, or a MS bug on internal relationship of archives.

I also do not know if this aproach is correct, but I hope that my experience help somebody.