VB.NET (2005); Sqlce ?

[Titeuf]

ok I start programming mobile application with VB.NET (VS 2005)
I am interested work with Sqlce
Also I look for add reference in my project

I search "System.Data.SqlServerCe" but not found.
Where is? Sqlce is not installed by default?

Thanks

 

[Ken Tucker [MVP]]

Hi,

VB 2005 should come with sql server 2005 mobile the version for sql
server 2005.

Ken

 

[Cor Ligthert [MVP]]

Titeuf,

What version of VB.Net

Cor

 

[Cor Ligthert [MVP]]

Titeuf,

What version of VB.Net(2005)

Cor

 

[Titeuf]

I use last MSDN Visual Studio 2005 (I have no exact version here)
But, I suppose I would reinstal (?)

 

[Titeuf]

ok I start programming mobile application with VB.NET (VS 2005)
I am interested work with Sqlce
Also I look for add reference in my project

I search "System.Data.SqlServerCe" but not found.
Where is? Sqlce is not installed by default?

Thanks

Ok. My probleme is solved.
In fact.
First not use Microsoft Desktop Search for search "System.Data.SqlServerCe"
Just use the old search with Explorer ;-)
After, I found - just Projet/Add Reference with Browse - etc. for others
*.dll

Last, my big problem:
I have problem with System.Data.Sqlce.common.dbConnection
Il juste create a small program and compare *.vbproj file:


*.vbproj (GOOD project)
----------------------------------
<ItemGroup>
<Reference Include="System" />
<Reference Include="System.Data" />
<Reference Include="System.Data.SqlClient, Version=3.0.3600.0,
Culture=neutral, PublicKeyToken=3be235df1c8d2ad3,
processorArchitecture=MSIL" />
<Reference Include="System.Data.SqlServerCe, Version=3.0.3600.0,
Culture=neutral, PublicKeyToken=3be235df1c8d2ad3,
processorArchitecture=MSIL" />
<Reference Include="System.Drawing" />
<Reference Include="System.Windows.Forms" />
</ItemGroup>

*.vbproj (BAD)
---------------------
<ItemGroup>
<Reference Include="CustomMarshalers" />
<Reference Include="System" />
<Reference Include="System.Data.Common, Version=1.0.5000.0,
Culture=neutral, PublicKeyToken=969db8053d3322ac">
<SpecificVersion>False</SpecificVersion>
<HintPath>..\..\..\..\Program Files\Microsoft Visual Studio
8\SmartDevices\SDK\SQL Server\Mobile\v2.0\System.Data.Common.dll</HintPath>
</Reference>
<Reference Include="System.Data.SqlClient, Version=3.0.3600.0,
Culture=neutral, PublicKeyToken=3be235df1c8d2ad3,
processorArchitecture=MSIL">
<SpecificVersion>False</SpecificVersion>
<HintPath>..\..\..\..\Program Files\Microsoft SQL Server 2005 Mobile
Edition\Device\Client\v2.0\System.Data.SqlClient.dll</HintPath>
</Reference>
<Reference Include="System.Data.SqlServerCe, Version=3.0.3600.0,
Culture=neutral, PublicKeyToken=3be235df1c8d2ad3,
processorArchitecture=MSIL">
<SpecificVersion>False</SpecificVersion>
<HintPath>..\..\..\..\Program Files\Microsoft SQL Server 2005 Mobile
Edition\Device\Mobile\v3.0\System.Data.SqlServerCe.dll</HintPath>
</Reference>
<Reference Include="System.Drawing" />
<Reference Include="System.Windows.Forms" />
</ItemGroup>

The difference is probably because I start with a project created with VS
2003.
I gess replace the BAD ItemGroup with GOOD ItemGroup
Bingo!
I create database, table etc. with Sqlce