2

I'm developing C# standalone client application which requires me to have a database/ and 2-3 tables and I don't want to install SQL Server 2008 R2 on client machine for a small piece of software?

Is there anything within Visual Studio I can use it and after installing I can use that database / tables without installing SQL Server 2008 R2 software on client?

Improve this question
1
  • 1
    Your project could use any kind of database with an ADO.NET provider. So SQLite, MS-Access, SQL Server Compact ...... are all good to go Commented Feb 19, 2014 at 7:44

1 Answer 1

Reset to default
3

What you are looking for is SQL Server CE (Compact Edition)

This is not a standalone full fledged database server, but an embedded database which resides in your application folder.

You might want to read into some further information:

http://www.microsoft.com/en-us/sqlserver/editions/2012-editions/compact.aspx

Improve this answer
Sign up to request clarification or add additional context in comments.

3 Comments

I don't need to install visual studio & SQL server right on client machine?
@RegisteredUser - you can deploy SQL CE either via a bootstrapper or you just drop the files in your app folder, see technet.microsoft.com/en-us/library/gg213826.aspx But please be avare, sql-ce has some (minor) limitations, see erikej.blogspot.dk/2011/01/…
Registered User: The only thing you need to make sure of, is that your compiled/deployed application contains all required assemblies and you're good to go.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.