Questions about local database vs service-based da

问题:

I have a some questions about local and service-based databases: Does using a service-based database require the user to have SQL Server installed? If so, is there ANY way around it? Does a local database require the user to have SQL Server installed? What is the difference between a local database and a service-based database. (I am talking about the items in Visual Studio)

回答1:

Clients do not need SQL installed to programatically connect to a database located elsewhere. Whatever mechanism contains the code to connect to databases in general will create the connection. For example, the System.Data namespace of .NET takes care of this for .NET programs. SQL installation is not necessary. Management tools, of course, will not be present on the client.