How to include LocalDb in ClickOnce Prereq List.

Question

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

Answer 1

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: http://social.msdn.microsoft.com/Forums/en/winformssetup/thread/518b0648-9d6e-4d7b-8972-80a9c16d7b20 

http://msdn.microsoft.com/en-us/library/ms165429.aspx 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: http://www.microsoft.com/betaexperience/pd/SQLEXPCTAV2/enus/default.aspx 

http://blogs.msdn.com/b/sqlexpress/archive/2011/11/28/simple-installer-for-localdb-has-shipped.aspx 

---

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

Answer 2

Thanks for your feedback, I have the Localdb.msi file.  I have no experience with 'bootstrapers', so off to learn a new skill.

Thanks.

---

Ed Warren Raising sails on masts not masts on sails

Answer 3

You're welcome!

Best wishes,

---

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

Answer 4

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

http://www.SalonSoftwareSystem.com

---

Windows Vista .Net 3.0 XAML Evangelist www.xpectworld.net