>Hi All,
>
>Would you recommend ClickOnce deployment for a medium-size WPF application (SQL Server, PRISM)?

Depends on your requirements.
If the install is likely to be complex (i.e. requiring the user to make a lot of decisions and having the install options vary depending on choices) then ClickOnce may not be flexible enough.

OTOH using it for an on-line install process can work well - benefits include the option of pushing out automatic updates (obligatory or discretional) plus the option to role back to an earlier version (which can be great it the new version introduced a bug :-} ).
You can also specify that required components (for example SQL Express) be downloaded and installed directly from the suppliers (MS in the example) site.