Monday, December 31, 2012

MVC Database Migration.

Add: Connection String:
In the Package Manager Console window at the PM> prompt enter "Enable-Migrations -ContextTypeName MvcMovie.Models.MovieDBContext".
In the Package Manager Console window, enter the command "add-migration Initial" to create the initial migration.
In the Package Manager Console, enter the command "update-database" to create the database and run the Seed method.

Wednesday, October 10, 2012

Backup and Restore SharePoint Sites using Power Shell:

Backup/Restore from one server to another or from one Site Collection to another (with PowerShell command)
In SharePoint 2010, PowerShell command Backup-SPSite is used for taking backup. you can get details of the command from the msdn link. The following command will backup the site collection ‘http://myserver’.
Backup Command: Restore-SPSite -Identity http://myserver -Path "c:\backup\file.bak"
Restore Command for new site: Restore-SPSite -Identity http://myserver -Path "c:\backup\file.bak"
Restore Command for existing site: Restore-SPSite -Identity http://myserver -Path "c:\backup\file.bak" -force

Wednesday, September 26, 2012

Multi Tenant SaaS Application

http://msdn.microsoft.com/en-us/library/aa479086.aspx
http://www.devx.com/webdev/Article/44977
http://dba.stackexchange.com/questions/16745/handling-growing-number-of-tenants-in-multi-tenant-database-architecture
http://www.ibm.com/developerworks/webservices/library/ws-middleware/

Tuesday, September 4, 2012

Factory Design Pattern

http://www.c-sharpcorner.com/UploadFile/db2972/factory-design-pattern/

Inversion of Control and Dependency Injection

http://www.c-sharpcorner.com/UploadFile/db2972/inversion-of-control-and-dependency-injection/

Wednesday, March 21, 2012

Inventory Costing

http://publib.boulder.ibm.com/infocenter/sfsf/v9r1/index.jsp?topic=%2Fcom.ibm.help.prod.concepts.doc%2Fc_AverageCostingMethodInventoryCostingForDrop-ShipProducts.html

Sunday, March 4, 2012

Bulk import csv insert command

BULK INSERT productprices FROM 'E:\RnD Projects\SmartGIngram\MSSQL Sample Package\MSSQL\PRICE.csv' WITH ( FIELDTERMINATOR = ',', ROWTERMINATOR = '\n' ) GO

Sunday, January 15, 2012

How do I download code using SVN/Tortoise from Google Code?

EXP:
# Non-members may check out a read-only working copy anonymously over HTTP.

svn checkout http://extnet-mvc.googlecode.com/svn/trunk/ extnet-mvc-read-only



Install Tortoise (separate SVN client not required), create a new empty folder for the project somewhere and right click it in Windows. Click "SVN Checkout". Choosing that option will open a dialog box. Paste the URL "http://extnet-mvc.googlecode.com/svn/trunk/" in the first textbox of that dialog box and click "OK".