VS with LocalDB, ReadyRoll, Async Read/Writes and deployment RRS feed

  • Question

  • I want to learn to program a Windows Store Application.. I have several paid VS teaching video programs, have taken free tutorial with all of them they do not talk about working with SQL at all, but hard code in data or at best do a text file..  I have also tried surfing the web, and looking for a book that looks like it has more then a brush over on the subject..  I just find a piece here, a comment there, but nothing very detailed..   Nothing about how to connect and read/write using SQL in async..   I need to plug in something like "Select * from table where field = "whatever" and then read the records retrieved, or "Update Table etc" and Execute the command..  I have seen none of that explaining the new async methods you would need to use.. 

    What I read on the new LocalDB & readyRoll, I think this is what I want to use..  The little I picked up from it, it offers more tools (like Stored Procedure)  then Compact Edition, does not have the deployment headaches of SQL Express,  But even that left me with some questions.. Such as what I saw said the queries of changes were set up to run in a specific order, but to run only once..  Logically I would imagine this is during a single upgrade, but I am hoping it was per each tablets application.. So if person A is installing for the first time he gets query 1 - 20, if person B has the program and missed some upgrades he gets query 12 - 20 and if person C has the program is keeping up-to-date on the upgrades would just get queries  18-20..  Well this would be nice, if that is what was meant by the query only running once.. but I didn't see where it kept track of anything that would do that.. 

    Also with ReadyRoll I got the impression that a SQL Express must be on the Clients tablet, it will blow up if it doesn't find it (and the right version of SQLExpress)..

    So what Books, reading material or videos can anyone point me to so that I can get all these questions answered, rather then a lot of bits and pieces that still don't accumulate into a whole.??



    • Moved by Amanda Zhu Tuesday, June 4, 2013 5:59 AM not VS general forum issues and not sure which appropriate forum this thread can be moved to
    Monday, June 3, 2013 11:16 AM


All replies

  • Hi,

    Thank you for posting in the MSDN forum.

    I’m afraid that it is not the correct forum for this issue, since VS General Question forum mainly discusses WPF & SL designer, Visual Studio Guidance Automation Toolkit, Developer Documentation and Help System and Visual Studio Editor.

    I am moving your question to the moderator forum ("Where is the forum for..?"). The owner of the forum will direct you to a right forum.

    In addition, I did some search about ReadyRoll. It is a third party product which is not supported by us. I suggest that you can consult on the website provided by the author of ReadyRoll for better support if you have ReadyRoll-related issues.

    Anyway, I move it to the moderator forum. Thanks for your understanding.

    Best regards,

    Amanda Zhu [MSFT]
    MSDN Community Support | Feedback to us
    Develop and promote your apps in Windows Store
    Please remember to mark the replies as answers if they help and unmark them if they provide no help.

    Tuesday, June 4, 2013 5:59 AM
  • Look at http://build.windowsstore.com/#fbid=7dYTmHUvnJc

    And http://msdn.microsoft.com/en-us/windows/apps


    When you see answers and helpful posts, please click Vote As Helpful, Propose As Answer, and/or Mark As Answer

    My Blog: http://unlockpowershell.wordpress.com
    My Book: Windows PowerShell 2.0 Bible
    My E-mail: -join ("6B61726C6D69747363686B65406D742E6E6574"-split"(?<=\G.{2})",19|%{[char][int]"0x$_"})

    Thursday, June 6, 2013 8:01 PM
  • You need to start looking up more info about C# and SQL Server, best to do that by buying 1 or more books. Check out: http://www.amazon.com/s/ref=nb_sb_noss?url=search-alias%3Dstripbooks&field-keywords=c%23+sql+server+compact#/ref=nb_sb_noss?url=search-alias%3Dstripbooks&field-keywords=c%23+sql+server+&rh=n%3A283155%2Ck%3Ac%23+sql+server+

    Compact Edition is just a great way to deploy a minimal per person sql server database, great for windows store apps. SQL Server Express is a minimalized version of sql server that can be shared with multiple persons and is actually quite powerful. In this case, SQL Express has to be reachable on the Clients tablet (but doesn't have to be installed there), otherwise the app fails.

    Based on what you're writing, I don't feel SQL Express and ReadyRoll is the correct path for you.

    Kind regards,
    Margriet Bruggeman

    Lois & Clark IT Services
    web site: http://www.loisandclark.eu
    blog: http://www.sharepointdragons.com

    Wednesday, June 19, 2013 8:02 AM
  • thanks, but on a separate forum I was told that none of the MS SQL products will work and my best bet is to use something called SQLite, something about these products being to large in size and so MS does not even give you a way to reference Compact or Express when building an Window Store App...   SQLite seems to be so basic that the only way you can really work with it is by learning Linq to get some query ability back, so I am now elbow deep learning Linq so I can work with it..  Seems though like Linq will be helpful to learn for other type of programing also as it does have a lot of functions, so maybe in the long run this will be a good thing, although right now I feel like I am over my head in all I have to learn to be able to program an app.


    Wednesday, June 19, 2013 11:04 AM