473,233 Members | 2,284 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,233 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 1564
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 thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

1
by: Matt Alanzo | last post by:
On another newsgroup an Access knowledgable party posted: >You should be able to connect an Access ADP to an existing SQLExpress >database running in SQLS 2000 compatibility mode. The only thing...
1
by: John | last post by:
1. can I use RewritePath in global.asax workin on Dev 2005 express? the self IIS using some port So I dont know if thats make the problam of 404 2. can i make new project in Dev 2005 express...
1
by: Peter | last post by:
I've purchased VS.NET 2005 Standard and have tried to install SQL Server 2005 Express, but get the following error in the error log. Please could someone help me.... Microsoft SQL Server 2005...
4
by: Andrew Robinson | last post by:
My main dev machine has WinXp and VS2005 (pro). 1. I need to install VWD Express Edition so that I can do some instruction on this. Any issues with both on the same machine. Installation order?...
42
by: (PeteCresswell) | last post by:
I skimmed the MS spiel at http://msdn.microsoft.com/sql/express, and noted the part about "all inside the Visual Studio 2005 environment". Do the older SQL server tools for security and stored...
3
by: Carl M. | last post by:
Okay, I'm 18 hours into this now and am at a loss. What I've done is create an application on my local workstation using VWD Express using the membership/roles provider and SQL Server Express...
1
by: dotnet | last post by:
Hi, I need to develop web application using vs.net I've started with asp.net I've books for asp.net and C#. But any book or sites deal only with note pad. How do I learn how to use vs.net to...
2
by: John | last post by:
I have a data file with proprietary database formatting from an old DOS programme and want to extract data from it and import it into SQL Server Express using C# Express. I've managed to work out...
7
by: Olegus | last post by:
Hello, in order to perform backup/restore MSSQL database using SMO, one needs to reference several namespaces in a backup class : using Microsoft.SqlServer.Management.Common; using...
2
by: =?Utf-8?B?NWV1cm9wZWFuY3Vwcw==?= | last post by:
just picked up a new laptop and want to use my main email account on this machine + my desktop. I use outlook express on the desktop and wondered whether it was possible to view my main email...
3
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 3 Jan 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). For other local times, please check World Time Buddy In...
0
by: jianzs | last post by:
Introduction Cloud-native applications are conventionally identified as those designed and nurtured on cloud infrastructure. Such applications, rooted in cloud technologies, skillfully benefit from...
0
by: abbasky | last post by:
### Vandf component communication method one: data sharing ​ Vandf components can achieve data exchange through data sharing, state sharing, events, and other methods. Vandf's data exchange method...
0
by: fareedcanada | last post by:
Hello I am trying to split number on their count. suppose i have 121314151617 (12cnt) then number should be split like 12,13,14,15,16,17 and if 11314151617 (11cnt) then should be split like...
0
by: stefan129 | last post by:
Hey forum members, I'm exploring options for SSL certificates for multiple domains. Has anyone had experience with multi-domain SSL certificates? Any recommendations on reliable providers or specific...
0
Git
by: egorbl4 | last post by:
Скачал я git, хотел начать настройку, а там вылезло вот это Что это? Что мне с этим делать? ...
1
by: davi5007 | last post by:
Hi, Basically, I am trying to automate a field named TraceabilityNo into a web page from an access form. I've got the serial held in the variable strSearchString. How can I get this into the...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
by: Aftab Ahmad | last post by:
Hello Experts! I have written a code in MS Access for a cmd called "WhatsApp Message" to open WhatsApp using that very code but the problem is that it gives a popup message everytime I clicked on...

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.