Where is your SQL Server CE Database?

Look at Ruby on Rails. It has simple database handling that works. OK, you are going to have to modify that code eventually; and I accept that database apps have an inherent complexity that no amount of wizards, O/R layers or even "Convention over Configuration” can remove. I still think that simple, single table, single user apps should be, well, simple. Not in VB, unfortunately.

Page 2 of 2 | Previous page

Related posts:

  1. Full circle for Microsoft database APIs as OLEDB for SQL Server is deprecated
  2. Amazon SimpleDB: a database server for the internet
  3. Very simple VB 2008 database app with databinding
  4. Sample code for a very very simple VB database application
  5. Small Business Server “Aurora” based on Windows Home Server and will have hooks to the cloud

4 comments on this post.
  1. Edward Royce:


    What is your opinion of RoR vs PHP?

    Just curious as I finally have some time to really get into a new dev language and I am trying to choose between RoR and PHP/Prado.

    One project I was considering was writing a UI designer for Prado to simplify page design. But if I go for RoR then I’ll shelve it for the moment.

  2. tim:


    I guess this is maturity (PHP) vs productivity (RoR).

    I’d suggest you try both and let us know what you think 🙂


  3. Leslie:

    Thank you. MSDN mentions that Access doesn’t work with “Refresh the Data Table” but they never really come out and say that SQL Server Compact 3.5 doesn’t support it either. I’m not a newbie but am trying to switch from larger server app to small client side app…
    Gosh, was I spoiled with my views, stored procedures, and ability to automatically get my identity columns. Thanks for the black and white. And yes I was a misfortunate one that hit the “Ok” to the copy local question as well.

  4. Greg:

    This is the only msg I have found that actually says what is going on. Several posts on other sites, including those sponsered from MS have a lot of false information and guesses. I thank you for this post for the fix was instant even though I had to redo all the associations which as you stated shows how painful this implementation of accessing data is. I was wondering if you are aware of other posts or information that clearly shows what is going on. I have figured things out by trial and error, running code and checking what is in memory versus what is written to disk but that is really a waste of time. I figured since this product has had several versions there should be some good documentation but I can’t find it. Every example uses different syntax and a clear explanation of how it is working or what is needed is never given. For example, people throw in code but don’t explain why the line of code is needed.

    I now understand some of the layers but am not 100% sure for I have been comparing the dataset data to the table adapter data to the database table. It is interesting to see how many copies of the data are maintained and which would allow a programmer to check if the record has changed or if the underlying data has changed.

    One thing that is missing in your article is … where is the mdf created and how can one access it from MSSQL Server. I tried to put the file in a specific directory but I was ignored .. some files were created where I wanted them but the MDF was not.