MSDE (Microsoft Data Engine) is the answer. It comes with your VS.NET product, with free redistribution rights and it's the full SQL Server 2000 engine with some limitations (concurrent connections and maximum DB size as far as I can remember). See the product spec to learn what are the specific limits and if they fit your needs. The great thing of MSDE is that your client effortlesly upgrade to the full SQL Server 2000 package if needed.
Related Q&A from Daniel Cazzulino
Here Daniel Cazzulino explains how to load a DSL (domain specific language) domain model instance file programmatically. This requires the .NET type ...continue reading
Here we offer a glimpse at 12 of .NET development expert Danny Cazzulino's top ASP.NET questions and answers.continue reading
C# developers should NOT be modifying InitializeComponent method in the code-behind (or any of the variable definitions) by hand.continue reading
Have a question for an expert?
Please add a title for your question
Get answers from a TechTarget expert on whatever's puzzling you.