Link to home
Start Free TrialLog in
Avatar of rmmarsh
rmmarshFlag for United States of America

asked on

Where is System.Data.SqlServerCe?

I am playing around with VS 2008 C# Express and .NET 3.5 and SQL Server Compact.  I can't find a reference to the above?  Anybody know where it is?
Avatar of Göran Andersson
Göran Andersson
Flag of Sweden image

Namespace: System.Data.SqlServerCe
Assembly: System.Data.SqlServerCe (in system.data.sqlserverce.dll)
Avatar of rmmarsh

ASKER

I saw that... system.data.sqlserverce.dll doesn't exist (and I've downloaded everything I could find)...
I haven't seen that in the VC# express edition, I have the Visual Studio Professional Edition Beta 2, and in the installer there is a separated option to  install Sql CE database support
Avatar of rmmarsh

ASKER

Hmmm... now I'm wondering if it's even supported under VS Express 2008...
as a general rule, C# EE doesn't support Mobile development, so I wouldn't expect to find SqlServerCE there.
Avatar of rmmarsh

ASKER

Sorry, Ghost... that's old stuff... I was able to create a new compact database, so I know it's supported under VS Express 2008... I guess I'm breaking new ground here, so I'll just keep plodding along, and will post the results here for others.

Thanks to both of you for your suggestions...

R
>> I was able to create a new compact database
How? from a VS Express project? or you have installed the engine separately?
ASKER CERTIFIED SOLUTION
Avatar of Göran Andersson
Göran Andersson
Flag of Sweden image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of rmmarsh

ASKER

Ghost... I think you got it... I was getting the error described... I'll try to remedy that and get back to you...

Thanks!
Avatar of rmmarsh

ASKER

Well... here's the definitive answer:

Visual Studio Standard, Pro, Enterprise or above required - Visual Studio Express SKUs will not work with SQL Server Compact Tools...

But, the good news is that I was able to reinstall VS 2008 and lo and behold the necessary connections, etc were there...

Thanks for the suggestions...
so, my answer was not true?
>>C# EE doesn't support Mobile development, so I wouldn't expect to find SqlServerCE there.
Avatar of rmmarsh

ASKER

Yes, it does, but not with the tools... I have been able to create a compact database and tables with ease (no code), and the using statements are there also to support the code.

Sorry, Jaime...
Just I am curious about this:
>>Where is System.Data.SqlServerCe?
>>I am playing around with VS 2008 C# Express and .NET 3.5 and SQL Server Compact.  I can't find a reference to the above?  Anybody know where it is?

Are you able to use the namespace and include the dll into your project with Visual C# EE 2008 ?
Avatar of rmmarsh

ASKER

Yep... but don't need the .dll... apparently it's automatically included in 2008... and you can even create the database and tables with a rudimentary tool...

R