Re: Using MS SQL Express in my C# App

[Todd Carnes]

Peter Bromberg [C# MVP] wrote:

As long as your application doesn't require the use of stored
procedures, you might want to consider shipping your app with SQL Server
Compact 3.5 edition. It can be deployed by simply including the 7
required assemblies and your database "SDF" file with your app; no
special installation is required. It also takes up *Way* less space.
--Peter

I need to study the topic more before deciding which way to go, but the
"compact" version sounds more like what I'm looking for so far.

Thank you everyone for taking the time to share your suggestions, links,
etc. with me. :)

Todd

[BlackWasp]

The compact edition is pretty good but check out the limitations first,
particularly if you are considering porting a database across from SQL
Server (Express) to CE.

--

BlackWasp
www.blackwasp.co.uk
"Todd Carnes" <to********@gmail.comwrote in message
news:g0**********@aioe.org...

Peter Bromberg [C# MVP] wrote:

>As long as your application doesn't require the use of stored procedures,
you might want to consider shipping your app with SQL Server Compact 3.5
edition. It can be deployed by simply including the 7 required assemblies
and your database "SDF" file with your app; no special installation is
required. It also takes up *Way* less space.
--Peter

I need to study the topic more before deciding which way to go, but the
"compact" version sounds more like what I'm looking for so far.

Thank you everyone for taking the time to share your suggestions, links,
etc. with me. :)

Todd

[Todd Carnes]

BlackWasp wrote:

The compact edition is pretty good but check out the limitations first,
particularly if you are considering porting a database across from SQL
Server (Express) to CE.

I realize this may not really be the proper group for this question, but
this thread has made me wonder about something else. So,...

If you use the compact version, can a table in one *.sdf file have
foreign keys that reference items in a table in a different *.sdf file?

Or do all the tables I use in my program have to reside in the same file?

Todd

[=?ISO-8859-1?Q?Arne_Vajh=F8j?=]

Todd Carnes wrote:

BlackWasp wrote:

>The compact edition is pretty good but check out the limitations
first, particularly if you are considering porting a database across
from SQL Server (Express) to CE.

I realize this may not really be the proper group for this question, but
this thread has made me wonder about something else. So,...

If you use the compact version, can a table in one *.sdf file have
foreign keys that reference items in a table in a different *.sdf file?

Or do all the tables I use in my program have to reside in the same file?

I think so.

1 SELECT -1 Command -1 Connection -1 .SDF file

Arne