Thursday, November 20, 2008

How CLR Manages execution of code

How CLR Manages execution of code?

When the application runs OS(windows) Checks whether the application contains .net headers . When Os finds .net header it starts CLR and load executable assemblies. find the entry point and it starts executing the code.Before it start executes it converts the code in to machinecode by JIT Complier.CLR stores these compiled code as workset and run the compiled code.

Monday, November 17, 2008

Difference Between VSS and TFS

Here is the link which explains the difference between VSS and TFS more specific

Here is the Crisp information about the difference between VSS and TFS

The choice between VSS and TFS depends on Project Complexity

1)When you want to control only your Solution Explorer then it is better to choose VSS whereas TFS supports control over documenting,auditing and SolutionExplorer

2)To Use VSS no extra tools are needed whereas for TFS need IIS,SqlServer

3)Multiple Checkin are allowed for the same file in TFS whereas it is not possible in VSS

4)Scalability is the main difference for VSS . Vss can support a team about 20 peoples whereas TFS supports around 2000 People

5)Visual SourceSafe does not store the merge history between two branches of files or folders. However, Team Foundation source control does have support for merge history

Thursday, November 13, 2008

Insert Select function:Insert Data From One Database to Another Database in sql

Here is the Query to insert the value from a table form one database in to a table in other database if the table is created manually

Insert into database1.dbo.TableName(FieldName1,FieldName2)Select FieldName1,FieldName2 from database2.dbo.TableName

For Ex :
Consider the DataBase Employee and Employee1
Now the Query will be

Insert into Employee.dbo.User(FirstName,LastName)Select FirstName,LastName from Employee1.dbo.User

It Fetches the Record from Employee1 and copy in to Employee

Here is the Query to create the table as same type and insert the values too

Select * into DatabaseName.dbo.NewTableName from DatabaseName.dbo.OldTableName(i.e the value from the table to be copied)

Select * into
Employee1.dbo.User from Employee.dbo.User

Monday, November 10, 2008

Difference between .net3.0 and .net 2.0

with .NET 2.0, the CLR works on a relatively simple concept: A common runtime model executes code for any system running the .NET Framework.
Version 3.0 of the .NET Framework is the first release that doesn’t improve on the Common Language Runtime.The .NET 3.0 Framework isn’t improving upon existing technologies but rather introducing four new foundation technologies:
* Windows Presentation Foundation (WPF)
* Windows Communication Foundation (WCF)
* Windows Workflow Foundation (WWF)
* Windows CardSpace (WCS)

Windows Presentation Foundation (WPF)

Windows Presentation Foundation (WPF) is arguably the most well-known of the four new foundation class sets. This is largely because of two things:

* You can actually see a WPF solution.
* WPF has been compared frequently to Adobe’s Flash
WPF is a consistent programming model for building solutions, and enables the use of richer controls, design, and development in Windows programs. A WPF program can be developed and released to desktops, the Web, and devices.Once interesting aspect of WPF is the XML standard programming language called XAML (pronounced "Zammel") that controls the layout of objects

Windows Communication Foundation

The core purpose of the Windows Communication Foundation (WCF) is to allow programs to talk to other programs on the same computer or network, or across the Internet. The WCF programming model unifies web services, .NET Remoting, distributed transactions, and message queues into a single service-oriented programming model for distributed computing.WCF is designed in accordance with service-oriented architecture principles to support distributed computing, in which services are used by consumers, clients can consume multiple services, and services can be consumed by multiple clients. Services typically have a WSDL interface that any WCF client can use to consume the service, irrespective of the platform on which the service is hosted.

Windows Workflow Foundation

Windows Workflow Foundation (WWF) is a Microsoft technology for defining, executing, and managing workflows. Workflows are composed of activities; developers can write their own domain-specific activities and then use them in workflows


Windows CardSpace, originally code-named "InfoCard," lets any Windows application, including Microsoft technologies such as the next release of Internet Explorer and those created by others, give its users a common way to work with digital identitiesThe goal is to let people on any machine, running any operating system, use digital identities as easily, as effectively, and as securely as they today use their identities in the physical world.

Find All Stored Procedure in SqlTable

Following code will help to find all the Stored Procedures (SP) which are related to one or more specific tables. sp_help and sp_depends does not always return accurate results.

   ----Option 1
FROM syscomments sc
INNER JOIN sysobjects so ON
WHERE sc.TEXT LIKE '%tablename%'
----Option 2
FROM syscomments c
INNER JOIN sysobjects o ON
WHERE c.TEXT LIKE '%tablename%'