Hi there,

Now that ClickOnce deals with databases as data files to be included in a project, we have a severe problem.

Our database is very huge. It’s actually 2.6 GB .

It isn’t possible to integrate it into the project, nor obtain the project Properties that’s available through Right Clicking the project in Solution Explorer Window.

Thus we’re stuck with build wizard and not able to fully customize it via the output project Properties.

We always keep getting 'Exception of type 'System.OutOfMemoryException' was thrown.' exception when we build the project with the database integrated into.

How to deal with such a problem in ClickOnce?

---

THosE wHo doN'T apPreCiATe LiFe, DOn't DeSerVe iT

Hi A.Ragab,

My suggestion is to create a Setup project to install the database and create a custom prerequisite redistributable component based on the resulted .msi file. Include the custom prerequisite redistributable component as a Prerequisite when publishing your application.

Thus, when the user runs the generated setup.exe, the prerequisite willbe launchedtoinstall the database on the client machine first, ifthe databasehas not been installed yet, and then the application will be installed.

Please visit the following link for more information on how to install database using MSI:
http://www.codeproject.com/KB/database/Deploy_your_database.aspx

Hope this helps.

---

Please remember to mark the replies as answers if they help and unmark them if they provide no help. end us any feedback you have about the help from MSFT at fbmsdn@microsoft.com.

Hi A.Ragab,

My suggestion is to create a Setup project to install the database and create a custom prerequisite redistributable component based on the resulted .msi file. Include the custom prerequisite redistributable component as a Prerequisite when publishing your application.

Thus, when the user runs the generated setup.exe, the prerequisite willbe launchedtoinstall the database on the client machine first, ifthe databasehas not been installed yet, and then the application will be installed.

Please visit the following link for more information on how to install database using MSI:
http://www.codeproject.com/KB/database/Deploy_your_database.aspx

Hope this helps.

---

Please remember to mark the replies as answers if they help and unmark them if they provide no help. end us any feedback you have about the help from MSFT at fbmsdn@microsoft.com.