Friday, April 11, 2014

Difference between .NET Framework 4.5 and .NET Framework 4.0

.NET Framework 4.0 support fallowing features:-

Web.config File Refactoring
Extensible Output Caching
Auto-Start Web Applications
Permanently Redirecting a Page
Shrinking Session State
Expanding the Range of Allowable URLs
Extensible Request Validation
Object Caching and Object Caching Extensibility
Extensible HTML, URL, and HTTP Header Encoding
Performance Monitoring for Individual Applications in a Single Worker Process
Multi-Targeting .... etc

.NET Framework 4.5 support fallowing improvement features:-

Asynchronously Reading and Writing HTTP Requests and Responses
Improvements to HttpRequest handling
Asynchronously flushing a response
Support for await and Task-Based Asynchronous Modules and Handlers

 What is new in .NET Framework 4.5 

.NET Framework 4.5 Support for Windows Runtime
.NET Framework 4.5 Support for Metro Style Applications
.NET Framework 4.5 Support for Async Programming
 Garbage Collector Improvements
.NET Framework 4.5 is Faster ASP.NET Startup
.NET Framework 4.5 Support Better Data Access
.NET Framework 4.5 Support WebSockets                         
 Workflow Support - BCL Support

Tuesday, April 1, 2014

connect to an MDF database file asp.net

con.ConnectionString = @"Data Source=.\SQLEXPRESS;
                          AttachDbFilename=c:\folder\SampleDatabase.mdf;
                          Integrated Security=True;
                          Connect Timeout=30;
                          User Instance=True";

Get table name and its SCHEMA NAME from database sql server

SELECT Distinct TABLE_NAME,SCHEMA_NAME() FROM information_schema.TABLES

C# / SQL Get all Stored Procedures and their Code

SELECT    sysobjects.name, syscomments.text
FROM    sysobjects
JOIN    syscomments
    ON    sysobjects.id = syscomments.id
WHERE    xtype='p'

Opps Part 1 : Abstraction

  Abstraction in C# is a fundamental concept of object-oriented programming (OOP) that allows developers t...