tags:

views:

171

answers:

1
+1  Q: 

Distributing an application that uses a SQL Server database

If I create a .NET application that uses a small SQL Server database that I create, can I then give that application to other people to run on their PCs even if they're not running SQL Server?

If so, is there anything special I have to do in the way I create/distribute it? And are there any special requirements for the PC's it is installed on?

I'm using VisualStudio 2008 and SQL Server 2008.

Edited to add: using LINQ to SQL (so need to use SQL Server)

+4  A: 

You can use the free SQL Server 2008 Express Edition which is redistributable.

Mitch Wheat  2009-10-03 16:57:30
Thanks. So do I install Express Edition on my dev pc (along with the full edition)? Or does the express edition just need to be installed on the PCs I distribute it to? And do I bundle it with my app or do I have them download it?
Abby Fichtner  2009-10-03 17:10:58
@Abby Fichtner: For testing purposes, you would be better off connecting to the same edition of SQL Server as your taget production environment. SO, I would install express edition. Note, since this is a second install locally, it will be a named instance, so your connection string will need the full name of the named instance on your machine.
Mitch Wheat  2009-10-03 17:16:42
Alright, and then I include the full blown 82MB (yikes) runtime in my application's installation?
Abby Fichtner  2009-10-03 17:35:51
@Abby Fichtner: yup!
Mitch Wheat  2009-10-03 18:18:06
Got it, thanks!
Abby Fichtner  2009-10-03 18:30:00
How do you include the runtime in th applications installation?
cmaduro  2010-06-03 18:14:14

related questions

Subsonic Vs NHibernate
How to check For File Lock in C# ?
Is nAnt still supported and suitable for .net 3.5/VS2008?
Limit size of Queue<T> in .NET?
Viewstate invalid when using Safari
Free OCR library
Unhandled Exception Handler in .NET 1.1
Localising date format descriptors
Get a new object instance from a Type in C#
VFP .NET OLEdb provider does not work in Win 64-Bits. Help
.NET Testing Framework Advice
Embedded Database for .net that can run off a network
Automatically update version number
Homegrown consumption of web services
How do you migrate a large app from VB6 to VB .net ?
.NET Migrations Engine
Adding Scripting functionality to .NET applications
SQLite and XSD
Floating Point Number parsing: Is there a Catch All algorithm?
How do I programmatically create a PDF in my .NET application?
How do I sync the SVN revision number with my ASP.NET web site?
XSD DataSets and ignoring foreign keys
Anatomy of a "Memory Leak"
Reliable Timer in a Console Application
How do I calculate relative time?