Open Source C# Development Framework

DevFramework is an open source solution for complete enterprise application development. These features will be at your disposal : Logging, Caching, Authorization, Performance Management, Exception Handling, Transaction Management, Data Access, Business Development, and hard solid tools. All these features do come with DEMO APPLICATION. It is completely OPEN SOURCE and 100% SOLID.

http://www.devframework.net/

Deleting all tables in a database

DECLARE @Sql NVARCHAR(500) DECLARE @Cursor CURSOR

SET @Cursor = CURSOR FAST_FORWARD FOR
SELECT DISTINCT sql = 'ALTER TABLE [' + tc2.TABLE_NAME + '] DROP [' + rc1.CONSTRAINT_NAME + ']'
FROM INFORMATION_SCHEMA.REFERENTIAL_CONSTRAINTS rc1
LEFT JOIN INFORMATION_SCHEMA.TABLE_CONSTRAINTS tc2 ON tc2.CONSTRAINT_NAME =rc1.CONSTRAINT_NAME

OPEN @Cursor FETCH NEXT FROM @Cursor INTO @Sql

WHILE (@@FETCH_STATUS = 0)
BEGIN
Exec SP_EXECUTESQL @Sql
FETCH NEXT FROM @Cursor INTO @Sql
END

CLOSE @Cursor DEALLOCATE @Cursor
GO

EXEC sp_MSForEachTable 'DROP TABLE ?'
GO

How to reinstall NuGet packages?

Sometimes you need to reinstall your Nuget Packages in Visual Studio.


You can use following command with Package Manager Console

update-package -reinstall