I am just starting to look into this interesting piece of technology, but am a little confused on how this works. I apologize if this has been asked earlier. My question is with this specific SQL server distribution, what is being used as the front end (to create and view your database & tables)? I read that SQL Server Compact Edition RC1 will have runtime only - How will you then get an application to point to a database via SQL compact?
Hi AlexJR.,
The front end, when using SQL Server Compact Edition, is your application. In your application, you'll instantiate an object and pass it a connection string. The connection string will have all the information necessary for the database engine to do its work.
To initially design your database, you can use SQL Server Management Studio or write a little application that creates your database. Because SQL Server Compact Edition supports most of the SQL you're probably used to writing, scripting your database should be identical to what you'd do on a full-sized server.
Have fun!
No comments:
Post a Comment