471,342 Members | 1,835 Online
Bytes | Software Development & Data Engineering Community
Post +

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 471,342 software developers and data experts.

Re: Using MS SQL Express in my C# App

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
Jun 27 '08 #1
3 1497
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
Jun 27 '08 #2
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
Jun 27 '08 #3
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
Jun 27 '08 #4

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

1 post views Thread by John | last post: by
42 posts views Thread by (PeteCresswell) | last post: by
2 posts views Thread by =?Utf-8?B?NWV1cm9wZWFuY3Vwcw==?= | last post: by
reply views Thread by rosydwin | last post: by

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.