Hi Guys,
In this post we are going to list out the differences between Sandboxed and Farm based Solutions.
Farm based Solutions:
Farm solutions are hosted in the IIS worker process (W3WP.exe).It runs the code that can affect the whole farm.So whenever you deploy a farm solution you must restart the application pool or ISS Server.
If you deploy any feature or retract any feature the whole application pool got recycled.
W3WP is the worker process to which you should attach while debugging Farm based solutions.
Sandboxed Solutions:
Sandboxed solutions are hosted in the SharePoint user code solution worker process (SPUCWorkerProcess.exe).It runs the code that can only affect the site collection of the solution.
Whenever you deploy a sandbox solution, no need of restarting neither the IIS application pool nor the IIS server as sandboxed solutions do not run in the IIS worker process.
SPUCWorkerProcess is the worker process to which you should attach while debugging sandbox solutions.
Points to be noted:
•One major difference is we can't create Aplication pages in Sandbox solutions.Beacuse Application pages are stored in the 14\TEMPLATES\_LAYOUTS and when we deploy as sandbox we dont have permissions to the physical folder.
•Also we cant create VISUAL web parts in Sandbox soultions.
•We cant use code to connect to the external web services or to database in the sandbox soltion
•Farm solutions are installed and deployed. Sandboxed solutions are uploaded and activated.
• runwithelevatedprivileges doesn't work in Sandboxed solutions.
• Site collection adminstrator can deploy a Sandboxed solutions, where as Farm administrator can only deploy Farm based Solutions.
Hope this helps...