How to include LocalDb in ClickOnce Prereq List.


  • So, I've got an application working with Vs2010, and using the new Localdb.  But when I go to the ClickOnce publish wizard, I cannot determine how to include LocalDb as a prereq.  Any SIMPLE answers??

    Ed Warren Raising sails on masts not masts on sails

    Tuesday, April 10, 2012 10:37 AM


All replies

  • There's no a LocalDB bootstrapper published, so you will need to make it yourself and add it to your installer as a prerequisite component.

    You can ref my this post: or make it manually. You also can ref the ready-made ones(such as this: C:\Program Files (x86)\Microsoft SDKs\Windows\v7.0A\Bootstrapper\Packages\DotNetFX40) to manual generate yours.

    And for the LocalDB msi file, you can download it here: 

    Mike Zhang[MSFT]
    MSDN Community Support | Feedback to us

    • Marked as answer by Edward Warren Wednesday, April 11, 2012 10:20 AM
    Wednesday, April 11, 2012 3:10 AM
  • Thanks for your feedback, I have the Localdb.msi file.  I have no experience with 'bootstrapers', so off to learn a new skill.


    Ed Warren Raising sails on masts not masts on sails

    Wednesday, April 11, 2012 10:20 AM
  • You're welcome!

    Best wishes,

    Mike Zhang[MSFT]
    MSDN Community Support | Feedback to us

    Thursday, April 12, 2012 3:18 AM
  • hi,

    I hope Ed is now sorted out but to any like me reading this thread

    it needs a little update:

    Firstly, thanks for LocalDb it may just be a life saver to ISVs who rely on their salon software demo downloads working first time.

    As localDb is 32 and 64 bit and never the twain shall meet it is not a good idea

    to create two different installers with exactly the same contents but a single LocalDb.msi (32 and 64).

    Instead use one small installer to get your master code on their machines,

    next to establish the architecture

    then control the download and installing of the correct LocalDB

    We have found that trusting the MSI/prerequisites and the terrible failures that SQL Express seems

    to have even on completely fresh machines to be a real money-loser.

    Was about to switch to another provider but this may have saved the day.

    Craig Salon Software

    Windows Vista .Net 3.0 XAML Evangelist

    Sunday, August 26, 2012 5:14 AM
  • Hi Mike,

    This post is rather dated so I thought I'd ask you .. since this is 2014, does an installer exist yet for localdb or do we still need to install it as you suggest in this post?



    Monday, November 03, 2014 7:03 PM