Here's a whitepaper by MSDN on Embedding SQL Server Express in Applications.