Re: ClickOnce

You can definitely create the database objects and load data using a custom action in an MSI package, but this would defeat the purpose of Click-Once deployment. The Click-Once way of doing this would be to deploy the mdf database file with ClickOnce specifying "Data" in the dropdown. You can also mount the database dynamically using a specially constructed connection string like ASP.Net does:

"data source=.\SQLEXPRESS;Integrated Security=SSPI;AttachDBFilename=|DataDirectory|mydatabase.mdf;User Instance=true"

|DataDirectory| will be the data directory under the directory where your application is deployed.

Bryan Phillips
MCSD, MCDBA, MCSE
Blog: http://bphillips76.spaces.live.com




"MMA" <MMA@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message news:F6E6C923-E499-442C-AA52-AD2B58DFC380@xxxxxxxxxxxxx:

After the prerequisite .net 2.0 framework and SQL Server Express 2005 has
been installed as part of my click once deployment, how do I create the db,
tables and load the data. Can I do it as done with a MSI project by creating
a custom action?

Thanks in advance

.

Relevant Pages

  • RE: Advice on how to create deployment package
    ... Regarding on the ASP.NET web application deployment question, ... In addition, for database creating, ... #Deployment of a Web Setup Project ... Using a Custom Action to Create a Database at Installation ...
    (microsoft.public.dotnet.framework.aspnet)
  • Re: Help : Access denied ???
    ... well - you can always set up a directory during deployment and ACL it appropriately - the System.Security.AccessControl namespace provides everything to do that programmatically. ... Dominick Baier - DevelopMentor ... That database contains the application configuraton setting based on ... For that I store the log file ...
    (microsoft.public.dotnet.security)
  • Re: VS2008 DBE (GDR)
    ... I am developing a database and the results of my efforts will eventually be ... In other words, when the other developers use my delivered script, they ... comments in the generated script that refer to pre and post deployment ... Microsoft Online Community Support ...
    (microsoft.public.vsnet.general)
  • The process could not bulk copy into table "dbo"."MSmerge_contents". Field size too large.
    ... I am getting the following error when trying a merge replication: ... bulk copies data into the main database tables and then says ... subscriber" and follows on with the error message above. ... used the mdf file as the basis for the deployment (I have a feeling ...
    (microsoft.public.sqlserver.replication)
  • Re: Problem with SQL Server 2005 Express Edition
    ... Windows Authentication and changed my connection string. ... deployment goes smoothly after all, since when installating the SQL Server ... It uses a SQL Server 2005 Express Edition database to store data. ...
    (microsoft.public.sqlserver.security)