The .NET Framework API's are entirely satisfactory except in terms of error returns. We don't check for he existenece of a database in the custom action code as we deploy to cloaked SQL servers (browsing disabled, servers operating on non-standard, high number ports, no DNS to remote SQL server assumed, etc.) We allow the SQL script to do the detection and handle the case where the database already exists or needs repair. SqlPackage.exe is used for the actual deployment, although .NET framework calls are used to construct and validate the connection string. A master table-driven custom action is then used to deploy one or more databases to one or more instances/connection strings in one pass.
-- John Merryweather Cooper Build & Install Engineer - ESA Jack Henry & Associates, Inc.® Shawnee Mission, KS 66227 Office: 913-341-3434 x791011 jocoo...@jackhenry.com www.jackhenry.com -----Original Message----- From: Levi Wilson [mailto:l...@leviwilson.com] Sent: Thursday, January 23, 2014 8:33 AM To: wix-users@lists.sourceforge.net Subject: [WiX-users] C# Custom Actions / SQL Being out of the WiX installer world for a handful of years, I was used to writing all of my custom actions in C++. Getting back into this I noticed that it is now acceptable to write them in C# and the DTF. That being said, I have a custom action that is currently written in C++ that checks for the existence of a database as well as to verify if a particular table exists. For that, I am using the sqlutil.lib to make that easier. In C# custom actions, is there an equivalent or do most people just use SqlConnection / SqlCommand out of the .NET framework? Apologies if this is an obvious question, I just didn't want to re-invent the wheel if WiX had a helper library to assist with this. I didn't see any SQL related classes in DTF. Thanks in advance, Levi ------------------------------------------------------------------------------ CenturyLink Cloud: The Leader in Enterprise Cloud Services. Learn Why More Businesses Are Choosing CenturyLink Cloud For Critical Workloads, Development Environments & Everything In Between. Get a Quote or Start a Free Trial Today. http://pubads.g.doubleclick.net/gampad/clk?id=119420431&iu=/4140/ostg.clktrk _______________________________________________ WiX-users mailing list WiX-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/wix-users NOTICE: This electronic mail message and any files transmitted with it are intended exclusively for the individual or entity to which it is addressed. The message, together with any attachment, may contain confidential and/or privileged information. Any unauthorized review, use, printing, saving, copying, disclosure or distribution is strictly prohibited. If you have received this message in error, please immediately advise the sender by reply email and delete all copies. ------------------------------------------------------------------------------ CenturyLink Cloud: The Leader in Enterprise Cloud Services. Learn Why More Businesses Are Choosing CenturyLink Cloud For Critical Workloads, Development Environments & Everything In Between. Get a Quote or Start a Free Trial Today. http://pubads.g.doubleclick.net/gampad/clk?id=119420431&iu=/4140/ostg.clktrk _______________________________________________ WiX-users mailing list WiX-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/wix-users
