Anish Varghese - My World of Microsoft Technologies

Web Platform Installer

2011-04-28T23:12:00.001+05:30

Web platform Installer is a free tool from Microsoft, which will help you to find what are the latest you have to install and available in market.

If you want to download click here

To Hide a file in C#

2011-02-14T00:07:00.002+05:30

Hi this is a basic sample shows how to create and hide a Directory in C#

How to Write a Macro in VS 2010

2011-01-30T23:59:00.001+05:30

We all knows that how much friendly the macros are. Here I am showing a small example of how to write macro to Disable and Enable macros.

When debugging projects.Its difficult to add and remove break points all the time. This is a simple macro which enable and disable the Breakpoints

First thing is how to write a macro

Step1: Select Tools –> Options –> Macros –> Macro Explorer (Alt+F8)

Step2: Double click on the module created.(Here it is Module2)

Step3: Write your Macro Code

Step4 : Build the Macro code

How to add the Macro created to VS10

Step 5: go to vs10 Project(Take a new one not in Macro) Tools –> Options

Step 6: Under Environment Variables –> Keyboard –> in Show Commands containing –> Select the macro you created.

Step 7: Type the key combination then click Assign and then Ok

Finally: Go to VS and Press the key combination (in the example I shown only for Enable, for disable also do the same step)

Hope this will help you.

Import and Export Break Points in VS 2010

2011-01-10T21:53:00.001+05:30

VS2010 has so many features. One of the best thing is import and export the break point.

Steps to Follow

Step 1: Put the break point

Step 2: Click on Export all Break Points

Step 3: Select the location and save the XML

Step 4: Remove all break points and Click on Import Breakpoints from a file

Step 5: Select the saved XML File.

All the breakpoints will reappear

Track Changes in Visual Studio

2010-09-15T19:17:00.001+05:30

Today I have noticed a nice future in visual studio Track Changes.

When you change some code portion in visual studio in says whether you saved it or not. Here is the example for the same.

First I enable the Track Changes in Visual studio. For that go to Tools –> Options –> Text Editor –> General –> (Select) Track Changes.

If you type something in code without saving it will come with a yellow line in the margin.

Once you save this yellow changes to Green.

Summary: This is a nice feature in Visual studio to help us to where we have done the changes in the code before saving the code (Comes as yellow). As well as we come to know which is the last saved one ( comes in green)

How to get the deleted file in Windows

2010-07-06T21:37:00.000+05:30

Last day i deleted one file from my pc.i recovered the file by using Restoration Version 2.5.14 and i successfully recovered the file. Following are the steps i used to recover the deleted files.

I am using windows 7 as my OS.

Download Restoration Version 2.5.14
extract the file if required, else run the exe.it will popup with a screen as shown below.

3. Select the drive from where you want to recover the data.Here i am selecting Drive as K.

4.Click the Search Deleted Files button.

5.it will display the deleted files .select the file you want and click on Restore by Copying button.

6. Select the location where you want to recover the files.

Note: here i tried for a word document to recover. i don’t know what all files it will recover.

Square selection in Visual studio 2010

2010-06-09T09:01:00.001+05:30

In visual studio 2010 we can easily select the items in square manner and replace those things.Here is one example.

Here i have three private variable and i need to change it to public all at a time, press Alt Key and select the square area where you want.

Then type the thing what you want is select in the square where you selected and type.I changed private to internal.

Enable javascript Debugging in IE

2010-06-09T08:45:00.001+05:30

To enable javascript in IE, do the following steps

Open IE –> Tools –> Internet Options –> Go to Advanced Tab –> uncheck Disable script debugging(Internet Explore)

Note: uncheck Disable script debugging(other) to enable debugging in other scripts.

Now open visual studio and put break point in the javascript where you want and runt it once the scripts fire the break point also will hit.

Unable to load DLL ‘FileTracker.dll’

2010-05-20T20:01:00.001+05:30

Last two days i am getting the error Unable to load DLL ‘FileTracker.dll’ when i create windows application ,getting this error not for other projects.

I am using visual studio 2010 B2 in a Windows 7 machine.

How i resolved the issue

I installed in visual studio 2010 B2 in C:\Windows\Microsoft.NET\Framework

There where two folders v4.0.21006 and v4.0.3004. I deleted the v4.0.3004(which is not required). If you want to come out from this problem delete the higher version of v4.0.21006 folder,Which is not required.

Now it is working fine.

operation could not be completed – Visual studio 2010

2010-05-19T22:00:00.001+05:30

Today i was working on visual studio i got one error: operation could not be completed

how i resolved

open the run(windows + r) type

C:\Program Files\Microsoft Visual Studio 10.0\Common7\IDE\devenv.exe /resetuserdata

Press enter –> now its working fine :)

How to clear the temp folder in windows start up using C#

2010-05-19T19:50:00.001+05:30

Today i decided to create an application using C# which clears the temp folder when ever windows startup.So no need to clear your temp file always.

Here is the code what i have tried:

RegistryKey regKey = Registry.CurrentUser.OpenSubKey(@"Software\Microsoft\Windows\CurrentVersion\Run", true);
           regKey.SetValue(Application.ProductName, Application.ExecutablePath);
          
          string path = Path.GetTempPath();
           if (!string.IsNullOrWhiteSpace (path))
           {
               DirectoryInfo d = new DirectoryInfo(path);
               Array.ForEach(Directory.GetFiles(path), s => 
               { try { label1.Text = s; File.Delete(s); } catch (Exception ex) { } });
               label1.Text = "Done";
              }

If any exception will come it wont show that exception,it will proceed from the next

If put the application in "Software\Microsoft\Windows\CurrentVersion\Run" when ever the windows starts it automatically runs.

Twitter API in C#

2010-05-18T06:57:00.001+05:30

Today i have seen a thread in my favorite site Stackoverflow on Twitter. So i decided to create a small Twitter API WCF application.

Twitter is designed on REST architecture. Here is a sample code to integrate the Twitter in C#.

Download the TweetSharp

To Authenticate user in the Twitter:

ITwitterLeafNode twitter =FluentTwitter.CreateRequest()
                          .AuthenticateAs(StaticProperties.Username,   StaticProperties.Password)
                          .Account().VerifyCredentials().AsJson();

if (twitter.Request().ResponseHttpStatusDescription == "OK")
{
}

To Update new Tweet:

ITwitterLeafNode twitter =FluentTwitter.CreateRequest()
                          .AuthenticateAs(StaticProperties.Username,StaticProperties.Password)
                          .Statuses().Update("Hello World).AsJson();
var request = twitter.Request();

Note: By using this API you will get all the Twitter related things,Like all Followers,To ReTweet etc.

Zip Extension

2010-05-11T20:27:00.003+05:30

Today i was going through some of the blogs.I have seen the Zip extension method in .Net 4.0 .
I like this very much here is the one sample example of Zip extension.

int[] numberArray = { 0, 1, 2, 3, 4 };
string[] nameArray = { "zero", "one" };

var combinedArray = numberArray.Zip(nameArray, (number, name) => number.ToString() + "(" + name + ")").ToArray();

Array.ForEach(combinedArray, s => Console.WriteLine(s));

K-MUG Session on 19th Saturday at Technopark

2009-12-17T23:10:00.001+05:30

K-MUG Session on 19th Saturday

Topics

Social Media
Search Engine Optimization / Search Engine Marketing
Social Media Marketing
Blogging

C# 4.0 and Silverlight
What is new in C# 4.0 and Silverlight.

Venue
UST Global, Bhavani,
Technopark, Trivandrum, Kerala

More Details : http://k-mug.org/content/UGMeet181209.aspx

How to install Chrome OS ?

2009-12-06T17:16:00.001+05:30

Few months back i was blogged about Chrome OS .Now it is released .

Today i decided to install the chrome os on my Laptop.Here are the steps that i followed to installed my Chrome OS.

Step 1 : download the VMware player and Chrome OS from here.

Step 2 : Install VMware player and Restart your machine and start your VMware player.you can see the below screen.

Step 2 : click Create a New Virtual Machine.

Step 3 : select “I will install the operating system later” and Click Next.

Step 4 : Guest operating system as other and version as other .

Step 5 : Enter Virtual machine name ,here i used Google Chrome OS.

Step 6 : Specify the disk capacity. Here i used as default setting.

Step 7 : Click the Customize Hardware .

Step 8 : Change the Network Adapter settings as shown below and click OK.

Step 9 : Click Finish . Now you can see the below image.

Step 10 : Now the Chrome OS image(VMware virtual disk file) that download

is copy to the installed location as same in the step 5.The name of VMware virtual disk file should be same as the virtual machine name. If not change the VMware virtual disk file to Directory name.

Here my location is C:\Users\anishmarokey\Documents\Virtual Machines\Google Chrome OS.

.When you copy it will ask like the below image.

Step 11 : go to VMware Player and click play Virtual Machine.

At last you can see the below screen ,Enter your username and password and click Enter.So you can see the magical world of Chromium OS.

Bing Driving Directions

2009-12-03T23:47:00.001+05:30

Today i have noticed a nice feature in Bing Map.This help me to find the root for travel , time taken and other nice things also

If i need to travel from Bangalore to Trivandrum .

I entered the Start and End Location

The Bing shows the output for us is as shown below

Waiting for Bing Maps Beta . To see the next Magic in Bing world :)

Introducing Closure Tools

2009-11-16T23:18:00.001+05:30

Millions of Google users worldwide use JavaScript-intensive applications such as Gmail, Google Docs, and Google Maps. Like developers everywhere, Googlers want great web apps to be easier to create, so we've built many tools to help us develop these (and many other) apps. We're happy to announce the open sourcing of these tools, and proud to make them available to the web development community.Read More

CLR via C#, Third Edition

2009-11-15T21:49:00.003+05:30

I am a person who loves to read technical books. I like to study more on compiler concepts, Jeffrey Richter CLR via C# second edition is an excellent book to study the concepts of internal of compiler C# .Now CLR via C# third edition is available,Order It.

MVC

2009-11-15T18:48:00.003+05:30

MVC(Model View Controller)

MVC(model view controller) is use for project more secure and easy to maintain.

Module: contains the database related operations.

View : contains all the aspx,ascx pages

Controller : is used for connecting module and view.if a view want to contact with model it can go through only controller and vice versa.

The latest MVC update package for visual studio 2008 is available in Click Here

Script Data in SQL SERVER 2008

2009-11-15T13:34:00.001+05:30

The script data is the new add-on feature on SQL SERVER 2008. Which helps to generate data along with the structure of database.

Steps to follow :

Step 1 : Right click on Database –> select Tasks –> Generate Script –> Select script options

-> select script data as True (as shown in figure) –> Do the rest of operation and Click Finish.It will generate the insert script along with the script generaed.

Here is the example of AdventureWorks –> table -> [HumanResources].[Employee]

USE [AdventureWorks]
GO
/****** Object:  Table [HumanResources].[Employee]    Script Date: 11/15/2009 08:00:17 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [HumanResources].[Employee](
	[EmployeeID] [int] IDENTITY(1,1) NOT NULL,
	[NationalIDNumber] [nvarchar](15) NOT NULL,
	[ContactID] [int] NOT NULL,
	[LoginID] [nvarchar](256) NOT NULL,
	[ManagerID] [int] NULL,
	[Title] [nvarchar](50) NOT NULL,
	[BirthDate] [datetime] NOT NULL,
	[MaritalStatus] [nchar](1) NOT NULL,
	[Gender] [nchar](1) NOT NULL,
	[HireDate] [datetime] NOT NULL,
	[SalariedFlag] [dbo].[Flag] NOT NULL,
	[VacationHours] [smallint] NOT NULL,
	[SickLeaveHours] [smallint] NOT NULL,
	[CurrentFlag] [dbo].[Flag] NOT NULL,
	[rowguid] [uniqueidentifier] ROWGUIDCOL  NOT NULL,
	[ModifiedDate] [datetime] NOT NULL,
 CONSTRAINT [PK_Employee_EmployeeID] PRIMARY KEY CLUSTERED 
(
	[EmployeeID] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Primary key for Employee records.' , @level0type=N'SCHEMA',@level0name=N'HumanResources', @level1type=N'TABLE',@level1name=N'Employee', @level2type=N'COLUMN',@level2name=N'EmployeeID'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Unique national identification number such as a social security number.' , @level0type=N'SCHEMA',@level0name=N'HumanResources', @level1type=N'TABLE',@level1name=N'Employee', @level2type=N'COLUMN',@level2name=N'NationalIDNumber'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Identifies the employee in the Contact table. Foreign key to Contact.ContactID.' , @level0type=N'SCHEMA',@level0name=N'HumanResources', @level1type=N'TABLE',@level1name=N'Employee', @level2type=N'COLUMN',@level2name=N'ContactID'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Network login.' , @level0type=N'SCHEMA',@level0name=N'HumanResources', @level1type=N'TABLE',@level1name=N'Employee', @level2type=N'COLUMN',@level2name=N'LoginID'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Manager to whom the employee is assigned. Foreign Key to Employee.M' , @level0type=N'SCHEMA',@level0name=N'HumanResources', @level1type=N'TABLE',@level1name=N'Employee', @level2type=N'COLUMN',@level2name=N'ManagerID'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Work title such as Buyer or Sales Representative.' , @level0type=N'SCHEMA',@level0name=N'HumanResources', @level1type=N'TABLE',@level1name=N'Employee', @level2type=N'COLUMN',@level2name=N'Title'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Date of birth.' , @level0type=N'SCHEMA',@level0name=N'HumanResources', @level1type=N'TABLE',@level1name=N'Employee', @level2type=N'COLUMN',@level2name=N'BirthDate'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'M = Married, S = Single' , @level0type=N'SCHEMA',@level0name=N'HumanResources', @level1type=N'TABLE',@level1name=N'Employee', @level2type=N'COLUMN',@level2name=N'MaritalStatus'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'M = Male, F = Female' , @level0type=N'SCHEMA',@level0name=N'HumanResources', @level1type=N'TABLE',@level1name=N'Employee', @level2type=N'COLUMN',@level2name=N'Gender'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Employee hired on this date.' , @level0type=N'SCHEMA',@level0name=N'HumanResources', @level1type=N'TABLE',@level1name=N'Employee', @level2type=N'COLUMN',@level2name=N'HireDate'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Job classification. 0 = Hourly, not exempt from collective bargaining. 1 = Salaried, exempt from collective bargaining.' , @level0type=N'SCHEMA',@level0name=N'HumanResources', @level1type=N'TABLE',@level1name=N'Employee', @level2type=N'COLUMN',@level2name=N'SalariedFlag'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Number of available vacation hours.' , @level0type=N'SCHEMA',@level0name=N'HumanResources', @level1type=N'TABLE',@level1name=N'Employee', @level2type=N'COLUMN',@level2name=N'VacationHours'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Number of available sick leave hours.' , @level0type=N'SCHEMA',@level0name=N'HumanResources', @level1type=N'TABLE',@level1name=N'Employee', @level2type=N'COLUMN',@level2name=N'SickLeaveHours'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'0 = Inactive, 1 = Active' , @level0type=N'SCHEMA',@level0name=N'HumanResources', @level1type=N'TABLE',@level1name=N'Employee', @level2type=N'COLUMN',@level2name=N'CurrentFlag'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'ROWGUIDCOL number uniquely identifying the record. Used to support a merge replication sample.' , @level0type=N'SCHEMA',@level0name=N'HumanResources', @level1type=N'TABLE',@level1name=N'Employee', @level2type=N'COLUMN',@level2name=N'rowguid'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Date and time the record was last updated.' , @level0type=N'SCHEMA',@level0name=N'HumanResources', @level1type=N'TABLE',@level1name=N'Employee', @level2type=N'COLUMN',@level2name=N'ModifiedDate'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Employee information such as salary, department, and title.' , @level0type=N'SCHEMA',@level0name=N'HumanResources', @level1type=N'TABLE',@level1name=N'Employee'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Primary key (clustered) constraint' , @level0type=N'SCHEMA',@level0name=N'HumanResources', @level1type=N'TABLE',@level1name=N'Employee', @level2type=N'CONSTRAINT',@level2name=N'PK_Employee_EmployeeID'
GO
SET IDENTITY_INSERT [HumanResources].[Employee] ON
INSERT [HumanResources].[Employee] ([EmployeeID], [NationalIDNumber], [ContactID], [LoginID], [ManagerID], [Title], [BirthDate], [MaritalStatus], [Gender], [HireDate], [SalariedFlag], [VacationHours], [SickLeaveHours], [CurrentFlag], [rowguid], [ModifiedDate]) VALUES (1, N'14417807', 1209, N'adventure-works\guy1', 16, N'Production Technician - WC60', CAST(0x0000674000000000 AS DateTime), N'M', N'M', CAST(0x000089CB00000000 AS DateTime), 0, 21, 30, 1, N'aae1d04a-c237-4974-b4d5-935247737718', CAST(0x0000953500000000 AS DateTime))
INSERT [HumanResources].[Employee] ([EmployeeID], [NationalIDNumber], [ContactID], [LoginID], [ManagerID], [Title], [BirthDate], [MaritalStatus], [Gender], [HireDate], [SalariedFlag], [VacationHours], [SickLeaveHours], [CurrentFlag], [rowguid], [ModifiedDate]) VALUES (2, N'253022876', 1030, N'adventure-works\kevin0', 6, N'Marketing Assistant', CAST(0x00006E7500000000 AS DateTime), N'S', N'M', CAST(0x00008A9D00000000 AS DateTime), 0, 42, 41, 1, N'1b480240-95c0-410f-a717-eb29943c8886', CAST(0x0000953500000000 AS DateTime))
INSERT [HumanResources].[Employee] ([EmployeeID], [NationalIDNumber], [ContactID], [LoginID], [ManagerID], [Title], [BirthDate], [MaritalStatus], [Gender], [HireDate], [SalariedFlag], [VacationHours], [SickLeaveHours], [CurrentFlag], [rowguid], [ModifiedDate]) VALUES (3, N'509647174', 1002, N'adventure-works\roberto0', 12, N'Engineering Manager', CAST(0x00005CAA00000000 AS DateTime), N'M', N'M', CAST(0x00008BBE00000000 AS DateTime), 1, 2, 21, 1, N'9bbbfb2c-efbb-4217-9ab7-f97689328841', CAST(0x0000953500000000 AS DateTime))
INSERT [HumanResources].[Employee] ([EmployeeID], [NationalIDNumber], [ContactID], [LoginID], [ManagerID], [Title], [BirthDate], [MaritalStatus], [Gender], [HireDate], [SalariedFlag], [VacationHours], [SickLeaveHours], [CurrentFlag], [rowguid], [ModifiedDate]) VALUES (4, N'112457891', 1290, N'adventure-works\rob0', 3, N'Senior Tool Designer', CAST(0x00005CD300000000 AS DateTime), N'S', N'M', CAST(0x00008BD600000000 AS DateTime), 0, 48, 80, 1, N'59747955-87b8-443f-8ed4-f8ad3afdf3a9', CAST(0x0000953500000000 AS DateTime))
INSERT [HumanResources].[Employee] ([EmployeeID], [NationalIDNumber], [ContactID], [LoginID], [ManagerID], [Title], [BirthDate], [MaritalStatus], [Gender], [HireDate], [SalariedFlag], [VacationHours], [SickLeaveHours], [CurrentFlag], [rowguid], [ModifiedDate]) VALUES (5, N'480168528', 1009, N'adventure-works\thierry0', 263, N'Tool Designer', CAST(0x000046D900000000 AS DateTime), N'M', N'M', CAST(0x00008BDC00000000 AS DateTime), 0, 9, 24, 1, N'1d955171-e773-4fad-8382-40fd898d5d4d', CAST(0x0000953500000000 AS DateTime))
INSERT [HumanResources].[Employee] ([EmployeeID], [NationalIDNumber], [ContactID], [LoginID], [ManagerID], [Title], [BirthDate], [MaritalStatus], [Gender], [HireDate], [SalariedFlag], [VacationHours], [SickLeaveHours], [CurrentFlag], [rowguid], [ModifiedDate]) VALUES (6, N'24756624', 1028, N'adventure-works\david0', 109, N'Marketing Manager', CAST(0x00005D2900000000 AS DateTime), N'S', N'M', CAST(0x00008BE500000000 AS DateTime), 1, 40, 40, 1, N'e87029aa-2cba-4c03-b948-d83af0313e28', CAST(0x0000953500000000 AS DateTime))
INSERT [HumanResources].[Employee] ([EmployeeID], [NationalIDNumber], [ContactID], [LoginID], [ManagerID], [Title], [BirthDate], [MaritalStatus], [Gender], [HireDate], [SalariedFlag], [VacationHours], [SickLeaveHours], [CurrentFlag], [rowguid], [ModifiedDate]) VALUES (7, N'309738752', 1070, N'adventure-works\jolynn0', 21, N'Production Supervisor - WC60', CAST(0x000041CF00000000 AS DateTime), N'S', N'F', CAST(0x00008BEB00000000 AS DateTime), 0, 82, 61, 1, N'2cc71b96-f421-485e-9832-8723337749bb', CAST(0x0000953500000000 AS DateTime))
INSERT [HumanResources].[Employee] ([EmployeeID], [NationalIDNumber], [ContactID], [LoginID], [ManagerID], [Title], [BirthDate], [MaritalStatus], [Gender], [HireDate], [SalariedFlag], [VacationHours], [SickLeaveHours], [CurrentFlag], [rowguid], [ModifiedDate]) VALUES (8, N'690627818', 1071, N'adventure-works\ruth0', 185, N'Production Technician - WC10', CAST(0x0000425B00000000 AS DateTime), N'M', N'F', CAST(0x00008BF600000000 AS DateTime), 0, 83, 61, 1, N'3e3b6905-209e-442e-b8a8-9a0980241c6a', CAST(0x0000953500000000 AS DateTime))
INSERT [HumanResources].[Employee] ([EmployeeID], [NationalIDNumber], [ContactID], [LoginID], [ManagerID], [Title], [BirthDate], [MaritalStatus], [Gender], [HireDate], [SalariedFlag], [VacationHours], [SickLeaveHours], [CurrentFlag], [rowguid], [ModifiedDate]) VALUES (9, N'695256908', 1005, N'adventure-works\gail0', 3, N'Design Engineer', CAST(0x00003D1900000000 AS DateTime), N'M', N'F', CAST(0x00008BF600000000 AS DateTime), 1, 5, 22, 1, N'ec84ae09-f9b8-4a15-b4a9-6ccbab919b08', CAST(0x0000953500000000 AS DateTime))
INSERT [HumanResources].[Employee] ([EmployeeID], [NationalIDNumber], [ContactID], [LoginID], [ManagerID], [Title], [BirthDate], [MaritalStatus], [Gender], [HireDate], [SalariedFlag], [VacationHours], [SickLeaveHours], [CurrentFlag], [rowguid], [ModifiedDate]) VALUES (10, N'912265825', 1076, N'adventure-works\barry0', 185, N'Production Technician - WC10', CAST(0x0000421500000000 AS DateTime), N'S', N'M', CAST(0x00008BF700000000 AS DateTime), 0, 88, 64, 1, N'756a60ae-378f-43d8-9f93-1e821d1eaf52', CAST(0x0000953500000000 AS DateTime))
INSERT [HumanResources].[Employee] ([EmployeeID], [NationalIDNumber], [ContactID], [LoginID], [ManagerID], [Title], [BirthDate], [MaritalStatus], [Gender], [HireDate], [SalariedFlag], [VacationHours], [SickLeaveHours], [CurrentFlag], [rowguid], [ModifiedDate]) VALUES (11, N'998320692', 1006, N'adventure-works\jossef0', 3, N'Design Engineer', CAST(0x0000464D00000000 AS DateTime), N'M', N'M', CAST(0x00008C0800000000 AS DateTime), 1, 6, 23, 1, N'e39056f1-9cd5-478d-8945-14aca7fbdcdd', CAST(0x0000953500000000 AS DateTime))
INSERT [HumanResources].[Employee] ([EmployeeID], [NationalIDNumber], [ContactID], [LoginID], [ManagerID], [Title], [BirthDate], [MaritalStatus], [Gender], [HireDate], [SalariedFlag], [VacationHours], [SickLeaveHours], [CurrentFlag], [rowguid], [ModifiedDate]) VALUES (12, N'245797967', 1001, N'adventure-works\terri0', 109, N'Vice President of Engineering', CAST(0x000057FB00000000 AS DateTime), N'S', N'F', CAST(0x00008C0F00000000 AS DateTime), 1, 1, 20, 1, N'45e8f437-670d-4409-93cb-f9424a40d6ee', CAST(0x0000953500000000 AS DateTime))
INSERT [HumanResources].[Employee] ([EmployeeID], [NationalIDNumber], [ContactID], [LoginID], [ManagerID], [Title], [BirthDate], [MaritalStatus], [Gender], [HireDate], [SalariedFlag], [VacationHours], [SickLeaveHours], [CurrentFlag], [rowguid], [ModifiedDate]) VALUES (13, N'844973625', 1072, N'adventure-works\sidney0', 185, N'Production Technician - WC10', CAST(0x000042B200000000 AS DateTime), N'M', N'M', CAST(0x00008C1100000000 AS DateTime), 0, 84, 62, 1, N'40d603d9-7f99-48b7-a580-b17cf429bed2', CAST(0x0000953500000000 AS DateTime))
INSERT [HumanResources].[Employee] ([EmployeeID], [NationalIDNumber], [ContactID], [LoginID], [ManagerID], [Title], [BirthDate], [MaritalStatus], [Gender], [HireDate], [SalariedFlag], [VacationHours], [SickLeaveHours], [CurrentFlag], [rowguid], [ModifiedDate]) VALUES (14, N'233069302', 1067, N'adventure-works\taylor0', 21, N'Production Supervisor - WC50', CAST(0x0000421B00000000 AS DateTime), N'M', N'M', CAST(0x00008C1700000000 AS DateTime), 0, 79, 59, 1, N'28f7ef89-2793-4989-b67d-25046543c1e3', CAST(0x0000953500000000 AS DateTime))
INSERT [HumanResources].[Employee] ([EmployeeID], [NationalIDNumber], [ContactID], [LoginID], [ManagerID], [Title], [BirthDate], [MaritalStatus], [Gender], [HireDate], [SalariedFlag], [VacationHours], [SickLeaveHours], [CurrentFlag], [rowguid], [ModifiedDate]) VALUES (15, N'132674823', 1073, N'adventure-works\jeffrey0', 185, N'Production Technician - WC10', CAST(0x0000428000000000 AS DateTime), N'S', N'M', CAST(0x00008C2300000000 AS DateTime), 0, 85, 62, 1, N'6e086f41-b81d-4bdc-9f13-0eec488dc43e', CAST(0x0000953500000000 AS DateTime))
INSERT [HumanResources].[Employee] ([EmployeeID], [NationalIDNumber], [ContactID], [LoginID], [ManagerID], [Title], [BirthDate], [MaritalStatus], [Gender], [HireDate], [SalariedFlag], [VacationHours], [SickLeaveHours], [CurrentFlag], [rowguid], [ModifiedDate]) VALUES (16, N'446466105', 1068, N'adventure-works\jo0', 21, N'Production Supervisor - WC60', CAST(0x000042D900000000 AS DateTime), N'S', N'F', CAST(0x00008C2A00000000 AS DateTime), 0, 80, 60, 1, N'83ffaac6-b895-481f-b897-14f965d4da47', CAST(0x0000953500000000 AS DateTime))
INSERT [HumanResources].[Employee] ([EmployeeID], [NationalIDNumber], [ContactID], [LoginID], [ManagerID], [Title], [BirthDate], [MaritalStatus], [Gender], [HireDate], [SalariedFlag], [VacationHours], [SickLeaveHours], [CurrentFlag], [rowguid], [ModifiedDate]) VALUES (17, N'565090917', 1074, N'adventure-works\doris0', 185, N'Production Technician - WC10', CAST(0x0000421E00000000 AS DateTime), N'M', N'F', CAST(0x00008C3600000000 AS DateTime), 0, 86, 63, 1, N'692b8826-03b4-4c3b-82fc-1fc6f1409689', CAST(0x0000953500000000 AS DateTime))
INSERT [HumanResources].[Employee] ([EmployeeID], [NationalIDNumber], [ContactID], [LoginID], [ManagerID], [Title], [BirthDate], [MaritalStatus], [Gender], [HireDate], [SalariedFlag], [VacationHours], [SickLeaveHours], [CurrentFlag], [rowguid], [ModifiedDate]) VALUES (18, N'494170342', 1069, N'adventure-works\john0', 21, N'Production Supervisor - WC60', CAST(0x0000429B00000000 AS DateTime), N'M', N'M', CAST(0x00008C3D00000000 AS DateTime), 0, 81, 60, 1, N'd4ed1f78-7c28-479b-bfef-a73228ba2aaa', CAST(0x0000953500000000 AS DateTime))
INSERT [HumanResources].[Employee] ([EmployeeID], [NationalIDNumber], [ContactID], [LoginID], [ManagerID], [Title], [BirthDate], [MaritalStatus], [Gender], [HireDate], [SalariedFlag], [VacationHours], [SickLeaveHours], [CurrentFlag], [rowguid], [ModifiedDate]) VALUES (19, N'9659517', 1075, N'adventure-works\diane0', 185, N'Production Technician - WC10', CAST(0x0000421800000000 AS DateTime), N'M', N'F', CAST(0x00008C4800000000 AS DateTime), 0, 87, 63, 1, N'c334b2d2-0c56-4906-9095-f1d07a98cbec', CAST(0x0000953500000000 AS DateTime))
INSERT [HumanResources].[Employee] ([EmployeeID], [NationalIDNumber], [ContactID], [LoginID], [ManagerID], [Title], [BirthDate], [MaritalStatus], [Gender], [HireDate], [SalariedFlag], [VacationHours], [SickLeaveHours], [CurrentFlag], [rowguid], [ModifiedDate]) VALUES (20, N'443968955', 1129, N'adventure-works\steven0', 173, N'Production Technician - WC30', CAST(0x0000603C00000000 AS DateTime), N'M', N'M', CAST(0x00008D4000000000 AS DateTime), 0, 41, 40, 1, N'0a8937c9-68aa-4d48-ba4e-b40493d764aa', CAST(0x0000953500000000 AS DateTime))
INSERT [HumanResources].[Employee] ([EmployeeID], [NationalIDNumber], [ContactID], [LoginID], [ManagerID], [Title], [BirthDate], [MaritalStatus], [Gender], [HireDate], [SalariedFlag], [VacationHours], [SickLeaveHours], [CurrentFlag], [rowguid], [ModifiedDate]) VALUES (21, N'277173473', 1231, N'adventure-works\peter0', 148, N'Production Control Manager', CAST(0x0000680B00000000 AS DateTime), N'M', N'M', CAST(0x00008D4000000000 AS DateTime), 1, 43, 41, 1, N'69d5d162-e817-45e7-9dec-5d9b8310e7b1', CAST(0x000095E80099062F AS DateTime))
INSERT [HumanResources].[Employee] ([EmployeeID], [NationalIDNumber], [ContactID], [LoginID], [ManagerID], [Title], [BirthDate], [MaritalStatus], [Gender], [HireDate], [SalariedFlag], [VacationHours], [SickLeaveHours], [CurrentFlag], [rowguid], [ModifiedDate]) VALUES (22, N'835460180', 1172, N'adventure-works\stuart0', 197, N'Production Technician - WC45', CAST(0x00004B4F00000000 AS DateTime), N'S', N'M', CAST(0x00008D4100000000 AS DateTime), 0, 84, 62, 1, N'4f361b4f-7920-4037-9a0a-46d616f9b9c7', CAST(0x0000953500000000 AS DateTime))
INSERT [HumanResources].[Employee] ([EmployeeID], [NationalIDNumber], [ContactID], [LoginID], [ManagerID], [Title], [BirthDate], [MaritalStatus], [Gender], [HireDate], [SalariedFlag], [VacationHours], [SickLeaveHours], [CurrentFlag], [rowguid], [ModifiedDate]) VALUES (23, N'687685941', 1173, N'adventure-works\greg0', 197, N'Production Technician - WC45', CAST(0x000056DC00000000 AS DateTime), N'S', N'M', CAST(0x00008D4100000000 AS DateTime), 0, 85, 62, 1, N'a36b5d6b-72a5-47f8-9f6b-5d922130e760', CAST(0x0000953500000000 AS DateTime))
INSERT [HumanResources].[Employee] ([EmployeeID], [NationalIDNumber], [ContactID], [LoginID], [ManagerID], [Title], [BirthDate], [MaritalStatus], [Gender], [HireDate], [SalariedFlag], [VacationHours], [SickLeaveHours], [CurrentFlag], [rowguid], [ModifiedDate]) VALUES (24, N'498138869', 1113, N'adventure-works\david1', 184, N'Production Technician - WC30', CAST(0x000063C200000000 AS DateTime), N'S', N'M', CAST(0x00008D4100000000 AS DateTime), 0, 25, 32, 1, N'ed7ee92e-a9d0-4e3a-8dee-4b143e459f7e', CAST(0x0000953500000000 AS DateTime))
INSERT [HumanResources].[Employee] ([EmployeeID], [NationalIDNumber], [ContactID], [LoginID], [ManagerID], [Title], [BirthDate], [MaritalStatus], [Gender], [HireDate], [SalariedFlag], [VacationHours], [SickLeaveHours], [CurrentFlag], [rowguid], [ModifiedDate]) VALUES (25, N'360868122', 1054, N'adventure-works\zheng0', 21, N'Production Supervisor - WC10', CAST(0x0000697000000000 AS DateTime), N'S', N'M', CAST(0x00008D4200000000 AS DateTime), 0, 66, 53, 1, N'c75f2740-ace3-4ebf-91c5-7ab352e1095f', CAST(0x0000953500000000 AS DateTime))
INSERT [HumanResources].[Employee] ([EmployeeID], [NationalIDNumber], [ContactID], [LoginID], [ManagerID], [Title], [BirthDate], [MaritalStatus], [Gender], [HireDate], [SalariedFlag], [VacationHours], [SickLeaveHours], [CurrentFlag], [rowguid], [ModifiedDate]) VALUES (26, N'964089218', 1097, N'adventure-works\ivo0', 108, N'Production Technician - WC20', CAST(0x000066DB00000000 AS DateTime), N'M', N'M', CAST(0x00008D4300000000 AS DateTime), 0, 9, 24, 1, N'd83a26f3-7ea7-477b-a5bb-7eaadfc13a09', CAST(0x0000953500000000 AS DateTime))
INSERT [HumanResources].[Employee] ([EmployeeID], [NationalIDNumber], [ContactID], [LoginID], [ManagerID], [Title], [BirthDate], [MaritalStatus], [Gender], [HireDate], [SalariedFlag], [VacationHours], [SickLeaveHours], [CurrentFlag], [rowguid], [ModifiedDate]) VALUES (27, N'384162788', 1156, N'adventure-works\paul0', 87, N'Production Technician - WC40', CAST(0x0000653B00000000 AS DateTime), N'S', N'M', CAST(0x00008D4300000000 AS DateTime), 0, 68, 54, 1, N'0217049e-1566-42b6-8027-41b751e2b00b', CAST(0x0000953500000000 AS DateTime))
INSERT [HumanResources].[Employee] ([EmployeeID], [NationalIDNumber], [ContactID], [LoginID], [ManagerID], [Title], [BirthDate], [MaritalStatus], [Gender], [HireDate], [SalariedFlag], [VacationHours], [SickLeaveHours], [CurrentFlag], [rowguid], [ModifiedDate]) VALUES (28, N'749389530', 1258, N'adventure-works\ashvini0', 150, N'Network Administrator', CAST(0x0000600C00000000 AS DateTime), N'S', N'M', CAST(0x00008D4300000000 AS DateTime), 0, 70, 55, 1, N'2e680c1c-7c02-4343-9626-6f97273414c0', CAST(0x0000953500000000 AS DateTime))
INSERT [HumanResources].[Employee] ([EmployeeID], [NationalIDNumber], [ContactID], [LoginID], [ManagerID], [Title], [BirthDate], [MaritalStatus], [Gender], [HireDate], [SalariedFlag], [VacationHours], [SickLeaveHours], [CurrentFlag], [rowguid], [ModifiedDate]) VALUES (29, N'571658797', 1199, N'adventure-works\kendall0', 14, N'Production Technician - WC50', CAST(0x00006D2300000000 AS DateTime), N'M', N'M', CAST(0x00008D4400000000 AS DateTime), 0, 11, 25, 1, N'65207627-5521-4a8e-ad3c-b2f1b5226b85', CAST(0x0000953500000000 AS DateTime))
INSERT [HumanResources].[Employee] ([EmployeeID], [NationalIDNumber], [ContactID], [LoginID], [ManagerID], [Title], [BirthDate], [MaritalStatus], [Gender], [HireDate], [SalariedFlag], [VacationHours], [SickLeaveHours], [CurrentFlag], [rowguid], [ModifiedDate]) VALUES (30, N'535145551', 1242, N'adventure-works\paula0', 140, N'Human Resources Manager', CAST(0x00005E7200000000 AS DateTime), N'M', N'F', CAST(0x00008D4500000000 AS DateTime), 1, 54, 47, 1, N'65028f15-4149-4de5-b203-9d7ec86baf87', CAST(0x0000953500000000 AS DateTime))
INSERT [HumanResources].[Employee] ([EmployeeID], [NationalIDNumber], [ContactID], [LoginID], [ManagerID], [Title], [BirthDate], [MaritalStatus], [Gender], [HireDate], [SalariedFlag], [VacationHours], [SickLeaveHours], [CurrentFlag], [rowguid], [ModifiedDate]) VALUES (31, N'761597760', 1140, N'adventure-works\alejandro0', 210, N'Production Technician - WC40', CAST(0x000070BB00000000 AS DateTime), N'S', N'M', CAST(0x00008D4500000000 AS DateTime), 0, 52, 46, 1, N'8c7321d2-2c64-4902-9d64-8f5c1eb7f747', CAST(0x0000953500000000 AS DateTime))
INSERT [HumanResources].[Employee] ([EmployeeID], [NationalIDNumber], [ContactID], [LoginID], [ManagerID], [Title], [BirthDate], [MaritalStatus], [Gender], [HireDate], [SalariedFlag], [VacationHours], [SickLeaveHours], [CurrentFlag], [rowguid], [ModifiedDate]) VALUES (32, N'271438431', 1122, N'adventure-works\garrett0', 184, N'Production Technician - WC30', CAST(0x00006AA000000000 AS DateTime), N'S', N'M', CAST(0x00008D4600000000 AS DateTime), 0, 34, 37, 1, N'a6f5f72f-aa03-41b7-8b6e-b123bd360753', CAST(0x0000953500000000 AS DateTime))
INSERT [HumanResources].[Employee] ([EmployeeID], [NationalIDNumber], [ContactID], [LoginID], [ManagerID], [Title], [BirthDate], [MaritalStatus], [Gender], [HireDate], [SalariedFlag], [VacationHours], [SickLeaveHours], [CurrentFlag], [rowguid], [ModifiedDate]) VALUES (33, N'160739235', 1124, N'adventure-works\jianshuo0', 135, N'Production Technician - WC30', CAST(0x0000691500000000 AS DateTime), N'S', N'M', CAST(0x00008D4600000000 AS DateTime), 0, 36, 38, 1, N'6fff136a-9664-4eb9-9243-fac76e21b9dd', CAST(0x0000953500000000 AS DateTime))
INSERT [HumanResources].[Employee] ([EmployeeID], [NationalIDNumber], [ContactID], [LoginID], [ManagerID], [Title], [BirthDate], [MaritalStatus], [Gender], [HireDate], [SalariedFlag], [VacationHours], [SickLeaveHours], [CurrentFlag], [rowguid], [ModifiedDate]) VALUES (34, N'586486572', 1285, N'adventure-works\susan0', 85, N'Stocker', CAST(0x0000615300000000 AS DateTime), N'S', N'F', CAST(0x00008D4600000000 AS DateTime), 0, 97, 68, 1, N'923ecfd6-e202-429a-9141-6cb183531439', CAST(0x0000953500000000 AS DateTime))
INSERT [HumanResources].[Employee] ([EmployeeID], [NationalIDNumber], [ContactID], [LoginID], [ManagerID], [Title], [BirthDate], [MaritalStatus], [Gender], [HireDate], [SalariedFlag], [VacationHours], [SickLeaveHours], [CurrentFlag], [rowguid], [ModifiedDate]) VALUES (35, N'337752649', 1283, N'adventure-works\vamsi0', 85, N'Shipping and Receiving Clerk', CAST(0x0000600300000000 AS DateTime), N'M', N'M', CAST(0x00008D4600000000 AS DateTime), 0, 95, 67, 1, N'a8838ab2-99de-415c-8675-d82ebf1c4752', CAST(0x0000953500000000 AS DateTime))
INSERT [HumanResources].[Employee] ([EmployeeID], [NationalIDNumber], [ContactID], [LoginID], [ManagerID], [Title], [BirthDate], [MaritalStatus], [Gender], [HireDate], [SalariedFlag], [VacationHours], [SickLeaveHours], [CurrentFlag], [rowguid], [ModifiedDate]) VALUES (36, N'113695504', 1183, N'adventure-works\alice0', 38, N'Production Technician - WC50', CAST(0x0000613D00000000 AS DateTime), N'M', N'F', CAST(0x00008D4600000000 AS DateTime), 0, 95, 67, 1, N'7e632b21-0d11-4bba-8a68-8cae14c20ae6', CAST(0x0000953500000000 AS DateTime))
INSERT [HumanResources].[Employee] ([EmployeeID], [NationalIDNumber], [ContactID], [LoginID], [ManagerID], [Title], [BirthDate], [MaritalStatus], [Gender], [HireDate], [SalariedFlag], [VacationHours], [SickLeaveHours], [CurrentFlag], [rowguid], [ModifiedDate]) VALUES (37, N'276751903', 1226, N'adventure-works\simon0', 7, N'Production Technician - WC60', CAST(0x000072CB00000000 AS DateTime), N'S', N'M', CAST(0x00008D4700000000 AS DateTime), 0, 38, 39, 1, N'f734d38a-56b5-471e-8ded-a682e958a9b3', CAST(0x0000953500000000 AS DateTime))
INSERT [HumanResources].[Employee] ([EmployeeID], [NationalIDNumber], [ContactID], [LoginID], [ManagerID], [Title], [BirthDate], [MaritalStatus], [Gender], [HireDate], [SalariedFlag], [VacationHours], [SickLeaveHours], [CurrentFlag], [rowguid], [ModifiedDate]) VALUES (38, N'630184120', 1065, N'adventure-works\jinghao0', 21, N'Production Supervisor - WC50', CAST(0x000070F900000000 AS DateTime), N'S', N'M', CAST(0x00008D4700000000 AS DateTime), 0, 77, 58, 1, N'2bca07d3-f2ac-4406-904f-e09156f3eb3e', CAST(0x0000953500000000 AS DateTime))
INSERT [HumanResources].[Employee] ([EmployeeID], [NationalIDNumber], [ContactID], [LoginID], [ManagerID], [Title], [BirthDate], [MaritalStatus], [Gender], [HireDate], [SalariedFlag], [VacationHours], [SickLeaveHours], [CurrentFlag], [rowguid], [ModifiedDate]) VALUES (39, N'545337468', 1108, N'adventure-works\michael0', 182, N'Production Technician - WC20', CAST(0x00006AF400000000 AS DateTime), N'S', N'M', CAST(0x00008D4800000000 AS DateTime), 0, 20, 30, 1, N'4fd6fe82-535a-4dd1-beb1-154a8b5e42f0', CAST(0x0000953500000000 AS DateTime))
INSERT [HumanResources].[Employee] ([EmployeeID], [NationalIDNumber], [ContactID], [LoginID], [ManagerID], [Title], [BirthDate], [MaritalStatus], [Gender], [HireDate], [SalariedFlag], [VacationHours], [SickLeaveHours], [CurrentFlag], [rowguid], [ModifiedDate]) VALUES (40, N'713403643', 1167, N'adventure-works\yvonne0', 159, N'Production Technician - WC45', CAST(0x0000713E00000000 AS DateTime), N'M', N'F', CAST(0x00008D4800000000 AS DateTime), 0, 79, 59, 1, N'83c6dabf-fd7d-4f5b-bb22-eb7eebb9a772', CAST(0x0000953500000000 AS DateTime))
INSERT [HumanResources].[Employee] ([EmployeeID], [NationalIDNumber], [ContactID], [LoginID], [ManagerID], [Title], [BirthDate], [MaritalStatus], [Gender], [HireDate], [SalariedFlag], [VacationHours], [SickLeaveHours], [CurrentFlag], [rowguid], [ModifiedDate]) VALUES (41, N'885055826', 1269, N'adventure-works\peng0', 200, N'Quality Assurance Supervisor', CAST(0x00005E9600000000 AS DateTime), N'M', N'M', CAST(0x00008D4800000000 AS DateTime), 1, 81, 60, 1, N'e249d613-36c9-4544-9b6f-6ce50e5e0da5', CAST(0x0000953500000000 AS DateTime))
INSERT [HumanResources].[Employee] ([EmployeeID], [NationalIDNumber], [ContactID], [LoginID], [ManagerID], [Title], [BirthDate], [MaritalStatus], [Gender], [HireDate], [SalariedFlag], [VacationHours], [SickLeaveHours], [CurrentFlag], [rowguid], [ModifiedDate]) VALUES (42, N'441044382', 1253, N'adventure-works\jean0', 109, N'Information Services Manager', CAST(0x00005E3600000000 AS DateTime), N'S', N'F', CAST(0x00008D4A00000000 AS DateTime), 1, 65, 52, 1, N'794a0b1f-c46a-401c-984d-008996fc7092', CAST(0x0000953500000000 AS DateTime))
INSERT [HumanResources].[Employee] ([EmployeeID], [NationalIDNumber], [ContactID], [LoginID], [ManagerID], [Title], [BirthDate], [MaritalStatus], [Gender], [HireDate], [SalariedFlag], [VacationHours], [SickLeaveHours], [CurrentFlag], [rowguid], [ModifiedDate]) VALUES (43, N'718299860', 1194, N'adventure-works\russell0', 74, N'Production Technician - WC50', CAST(0x000059DD00000000 AS DateTime), N'M', N'M', CAST(0x00008D4B00000000 AS DateTime), 0, 6, 23, 1, N'6b10192f-d570-47c4-82c9-3d979b1efdc1', CAST(0x0000953500000000 AS DateTime))
INSERT [HumanResources].[Employee] ([EmployeeID], [NationalIDNumber], [ContactID], [LoginID], [ManagerID], [Title], [BirthDate], [MaritalStatus], [Gender], [HireDate], [SalariedFlag], [VacationHours], [SickLeaveHours], [CurrentFlag], [rowguid], [ModifiedDate]) VALUES (44, N'685233686', 1232, N'adventure-works\ascott0', 148, N'Master Scheduler', CAST(0x000053E300000000 AS DateTime), N'S', N'M', CAST(0x00008D4B00000000 AS DateTime), 0, 44, 42, 1, N'13909262-4136-492f-bca3-0b0e3773b03e', CAST(0x000095E80099062F AS DateTime))
INSERT [HumanResources].[Employee] ([EmployeeID], [NationalIDNumber], [ContactID], [LoginID], [ManagerID], [Title], [BirthDate], [MaritalStatus], [Gender], [HireDate], [SalariedFlag], [VacationHours], [SickLeaveHours], [CurrentFlag], [rowguid], [ModifiedDate]) VALUES (45, N'295971920', 1135, N'adventure-works\fred0', 210, N'Production Technician - WC40', CAST(0x0000718500000000 AS DateTime), N'S', N'M', CAST(0x00008D4B00000000 AS DateTime), 0, 47, 43, 1, N'45358ae8-0b0e-4c11-90bb-dac3ec0d5c82', CAST(0x0000953500000000 AS DateTime))
INSERT [HumanResources].[Employee] ([EmployeeID], [NationalIDNumber], [ContactID], [LoginID], [ManagerID], [Title], [BirthDate], [MaritalStatus], [Gender], [HireDate], [SalariedFlag], [VacationHours], [SickLeaveHours], [CurrentFlag], [rowguid], [ModifiedDate]) VALUES (46, N'95958330', 1033, N'adventure-works\sariya0', 6, N'Marketing Specialist', CAST(0x00006E8700000000 AS DateTime), N'S', N'M', CAST(0x00008D4B00000000 AS DateTime), 0, 45, 42, 1, N'af21f1b7-0691-48ad-b325-b8f2d7b2268a', CAST(0x0000953500000000 AS DateTime))
INSERT [HumanResources].[Employee] ([EmployeeID], [NationalIDNumber], [ContactID], [LoginID], [ManagerID], [Title], [BirthDate], [MaritalStatus], [Gender], [HireDate], [SalariedFlag], [VacationHours], [SickLeaveHours], [CurrentFlag], [rowguid], [ModifiedDate]) VALUES (47, N'332040978', 1237, N'adventure-works\willis0', 30, N'Recruiter', CAST(0x000061EA00000000 AS DateTime), N'S', N'M', CAST(0x00008D4C00000000 AS DateTime), 0, 49, 44, 1, N'a1d86ecc-ea17-4b1b-8369-f1d07ab0a469', CAST(0x0000953500000000 AS DateTime))
INSERT [HumanResources].[Employee] ([EmployeeID], [NationalIDNumber], [ContactID], [LoginID], [ManagerID], [Title], [BirthDate], [MaritalStatus], [Gender], [HireDate], [SalariedFlag], [VacationHours], [SickLeaveHours], [CurrentFlag], [rowguid], [ModifiedDate]) VALUES (48, N'857651804', 1178, N'adventure-works\jun0', 38, N'Production Technician - WC50', CAST(0x0000634B00000000 AS DateTime), N'S', N'M', CAST(0x00008D4D00000000 AS DateTime), 0, 90, 65, 1, N'9c5f84d1-fb96-4d82-92a1-f932903deaad', CAST(0x0000953500000000 AS DateTime))
INSERT [HumanResources].[Employee] ([EmployeeID], [NationalIDNumber], [ContactID], [LoginID], [ManagerID], [Title], [BirthDate], [MaritalStatus], [Gender], [HireDate], [SalariedFlag], [VacationHours], [SickLeaveHours], [CurrentFlag], [rowguid], [ModifiedDate]) VALUES (49, N'553069203', 1280, N'adventure-works\christian0', 218, N'Maintenance Supervisor', CAST(0x00005E5A00000000 AS DateTime), N'M', N'M', CAST(0x00008D4D00000000 AS DateTime), 1, 92, 66, 1, N'4611c7c5-90a0-407f-b054-93bd51533609', CAST(0x0000953500000000 AS DateTime))
INSERT [HumanResources].[Employee] ([EmployeeID], [NationalIDNumber], [ContactID], [LoginID], [ManagerID], [Title], [BirthDate], [MaritalStatus], [Gender], [HireDate], [SalariedFlag], [VacationHours], [SickLeaveHours], [CurrentFlag], [rowguid], [ModifiedDate]) VALUES (50, N'351069889', 1119, N'adventure-works\susan1', 184, N'Production Technician - WC30', CAST(0x000068A100000000 AS DateTime), N'S', N'F', CAST(0x00008D4D00000000 AS DateTime), 0, 31, 35, 1, N'f73d75d5-b47b-46ee-ad11-7bf13dd6c55d', CAST(0x0000953500000000 AS DateTime))
INSERT [HumanResources].[E

separating multiple lines of data to insert with comma –SQL Server 2008

2009-11-02T09:22:00.001+05:30

Multiple insert in a single query by using comma separator.

insert into dbo.tbl_Demo
(id,name)
values
('1','anish'),
('2','varghese')

Coding Heroes - Present

2009-11-01T23:34:00.003+05:30

Few days back i saw a book “Coders at Work” ,which says about the grate programmers in current century.I am listing all there names only.

Visual Studio 2010 and .NET Framework 4 Beta 2

2009-10-19T22:41:00.001+05:30

For MSDN subscribers VS10 .NET framework 4 Beta 2 is available on this wednesday .

Download it from here

An anonymous type cannot have multiple properties with the same name

2009-10-18T23:16:00.002+05:30

If the query is like this

adventureworksEntities dbEntities = new adventureworksEntities();
            var query = from PC in dbEntities.productcategory
                        join PSC in dbEntities.productsubcategory
                      on PC.ProductCategoryID equals PSC.ProductSubcategoryID
                        select new { PC.Name, PC.ModifiedDate, PSC.Name, PSC.ModifiedDate };

The compiler will throw the error,”An anonymous type cannot have multiple properties with the same name” .Because the compiler can’t able to find a proper Name.So we want to modify the query with alias name ,some thing like this.

  var query = from PC in dbEntities.productcategory
                        join PSC in dbEntities.productsubcategory
                      on PC.ProductCategoryID equals PSC.ProductSubcategoryID
                        select new { PCName1 = PC.Name, PCModifiedDate1 = PC.ModifiedDate, PSCName1 = PSC.Name, PSCModifiedDate1 = PSC.ModifiedDate };

Entity Framework for MSSQL and MYSQL

2009-10-18T22:53:00.003+05:30

As we all know that Entity Frame work supports multiple databases.Here i am converting MSSQL database to MYSQL,Without changing the query.That is the power of linq.

First i am doing one sample on MSSQL.

I am using AdventureWorks Database, and using 2 tables ,Production.ProductCategory and Production.ProductSubcategory.

The ER Diagram for Production.ProductCategory and Production.ProductSubcategory is shown below

Steps to Add Entity Frame Work for MSSQL

Step 1 : Right Click on Solution Explorer –> Add –> New Item –> Select ADO.NET Entity Data Model.

Step 2 : Select sever name and AdventureWorks as DataBase and Click ok

Step 3 : Click Next

Step 4 : Select two tables Production.ProductCategory and Production.ProductSubcategory and Click Finish

So your Edmx Looks like

Code for getting the data

 AdventureWorksEntities dbEntities = new AdventureWorksEntities();
            var query = from PC in dbEntities.ProductCategory
                        join PSC in dbEntities.ProductSubcategory
                      on PC.ProductCategoryID equals PSC.ProductSubcategoryID
                        select new { PCName = PC.Name, PCModifiedDate = PC.ModifiedDate, PSCName = PSC.Name, PSCModifiedDate = PSC.ModifiedDate };
            GridView1.DataSource = query;
            GridView1.DataBind();

Here i cannot use Debug Visualizer.Entity Frame work wont support Debug Visualizer.So i am using one gridview and dispaly the data.

Note : If you are getting the error “An anonymous type cannot have multiple properties with the same name “ Read this

Output shown in Gridview.

The same result i am getting from MYSQL without changing the query.Only i am changing the database from MSSQL to MYSQL.

Converting MSSQL to MYSQL by using Full Convert Enterprise .

Steps to Covert

Step 1 : Already created AdventureWorks DataBase in MYSQL.

Step 2 : Enter username and Password

Step 3 : I selected all tables selected to convert MYSQL.

Step 4 :Click Convert.

Step 5 : Click Continue.

After Convert It shows a result like

Steps to Add Entity Frame Work for MYSQL.

Step 1 : install Connector/ NET 6.0 Windows Binaries,it automatically install mysql.data.dll and mysql.data.entity.dll to GAC.

Step 2 : Right Click on Solution Explorer –> Add –> New Item –> Select ADO.NET Entity Data Model.

Step 3 : Select New Connection.

Step 4 : Change the Data Source from MSSQL to MYSQL.

Step 5 : Select MySQL .if you install Connector/ NET 6.0 Windows Binaries ,only it will come.

Step 6 : Enter the necessary Details and click ok.

Step 7 : Select the necessary fields and click next.

Step 8 : Select two tables Production.ProductCategory and Production.ProductSubcategory.

The edmx will be same as previous MSSQL edmx.

Use the same query in MSSQL .

 adventureworksEntities dbEntities = new adventureworksEntities();
            var query = from PC in dbEntities.productcategory
                        join PSC in dbEntities.productsubcategory
                      on PC.ProductCategoryID equals PSC.ProductSubcategoryID
                        select new { PCName = PC.Name, PCModifiedDate = PC.ModifiedDate, PSCName = PSC.Name, PSCModifiedDate = PSC.ModifiedDate };
            GridView1.DataSource = query;
            GridView1.DataBind();

The result will display as same result.

Note it is easy to convert from one database to another database. But still some errors are there in EDMX Framework ( it wont support some joins ,Math operations etc).All the bugs will overcome on .NET 4.0 . Wait and see.

ALTER ALL TABLE,Procedure and UDF SCHEMA IN A SINGLE QUERY

2009-10-16T10:40:00.001+05:30

By using this query we can alter the schema to SCHEMANAME .

select 'ALTER SCHEMA SCHEMANAME transfer ['+SCHEMA_NAME(schema_id)+'].['+name +']' from sys.tables

OUTPUT

select all the query and execute in query window.All the schema will automatically changes to SCHEMANAME

Note :sys.tables – Returns a row for each table object ,currently only with

sys.objects.type =U

SCHEMA_NAME(schema_id) – Returns the schema name associated with schema_id

schema_id – ID of the schema.Schema_id is a int. If schema is not defined schema name of default will return

E.g : select SCHEMA_NAME() from sys.tables

OUTPUT

For Procedure

select 'ALTER SCHEMA SCHEMANAME transfer ['+SCHEMA_NAME(schema_id)+'].['+name +']' from sys.procedures

For UDF

select 'ALTER SCHEMA SCHEMANAME transfer ['+specific_schema+'].['+specific_name +']'
FROM information_schema.routines
WHERE routine_type='function'

Note : routines - Returns one row for each stored procedure and function that can be accessed by the current user in the current database.

NDepend – Part 1

2009-10-07T16:20:00.002+05:30

Its a .NET Static analysis tool for Architecture and developers to analyze the code structure,specify design rules , do some massive code review , compare different versions of code etc . This tool is developed by Patrick Smacchia(C# MVP).

Main features of NDepend are as follows as

Code Query Language(CQL)
Compare Builds
82 Code metrics
Manage Complexity and Dependencies
Detect Dependency Cycles
Harness Test Coverage Data
Enforce Immutability and purity
Warning about the health of your Build Process
Generate custom report from your Build Process
Diagrams
Facilities to cope with real-world environment

To read more

This is the sample program i am going to analyze by using NDepend.

using System;
using System.IO;
using System.Collections.Generic;
interface IFirst
{
    int AgeFirst { get; set; }
    string NameFirst { get; set; }
}
interface ISecond
{
    int AgeSecond { get; set; }
    string NameSecond { get; set; }
}
abstract class abstractClass
{
    int Ageabstract { get; set; }
    string Nameabstract { get; set; }
}
class Program
{
    static void Main(string[] args)
    {
    }
}

As we all know that the interface is not derived from System.Object.

and the abstract is derived from System.Object.

The Dependency Matrix in NDepend helps to See things graphically.

For IL Instruction for abstract class can be find out with the help of Metrics in NDepend as follows.

There are lot of things like Code Query Language(CQL), Detect Dependency Cycles,Compare Builds etc are there to explore in NDepend tool.That i will cover the the upcoming parts.

If any one interested in this tool, have a look on NDepend and order it Now.

Note : Thanks Patrick Smacchia, for given a free licence of NDepend to write a review.

New MVPs Announced – October 2009

2009-10-01T22:44:00.001+05:30

Microsoft MVPs are awarded every quarter and recognise the contributions of an individual to technical communities over the past year. read more

Microsoft Visual C# 2008 Compiler could not be created

2009-09-30T13:18:00.001+05:30

Today i got the error(‘Microsoft Visual C# 2008 Compiler could not be created. QueryService for '{7D960B16-7AF8-11D0-8E5E-00A0C911005A} failed’) when i try to open my existing project in Visual Studio.I repaired my Visual Studio 2008 using VS 2008 CD.But the same error :(.

Then i googled it . i got the solution .

Solution

open command prompt
Navigate to C:\Program Files\Microsoft Visual Studio 9.0\Common7\IDE (if your visual studio is installed in the corresponding location)
type devenv /ResetSkipPkgs

Note ResetSkipPkgs

Now my problem is solved :)

C# New Features – Till Visual Studio 2008 SP1

2009-09-27T23:08:00.002+05:30

1) Implicitly Typed Local Variables

Local variable can be declared as var instead of explicit type.The compiler automatically takes the necessary type.This example shows this.

private void Bind()
        {
            DataClassesDataContext db = new DataClassesDataContext();
            var sString = "anishmarokey";
            var query = from n in db.tblNames
                        select n;
        }

Result for var query;

By using ILDASM ,See the result for var sString and var query

2) Object and Collection Initializers

Object Initializers

With out invoking the constructor ,values can be accessible to fileds or properties

in .NET 2.0 invoking constructor value

using System;
class objectInitializers
{
    public int Age { get; set; }
    public string Name { get; set; }
}
class Application
{
    static void Main()
    {
        objectInitializers o = new objectInitializers();
        o.Age = 24;
        o.Name = "anishmarokey";
    }
}

The compiler takes it as

In .NET 3.5 without invoking constructor

using System;
class objectInitializers
{  
    public int Age { get; set; }
    public string Name { get; set; } 
}

class Application
{
    static void Main()
    {
         objectInitializers obj = new objectInitializers { Age = 24, Name = "anishmarokey" };
    }
}

The compiler takes it as

Note : Code size is different,for .NET 3.5 Code size is little higher.All the other things are same

Collection Initializers

When we want to initialize a collection class that class should initialize IEnumerable.

in .NET 2.0

static void Main()
    {
        List<string> l = new List<string>();
        l.Add("A");
        l.Add("B");
        l.Add("C");
    }

The compiler takes it as

in .NET 3.5

static void Main()
    {
        List<string> l = new List<string> { "A", "B", "C" };
    }

The compiler takes it as

Note : Code size is different,for .NET 3.5 Code size is little higher.All the other things are same

3) Extension Method

As per ScottGU - Extension methods allow developers to add new methods to the public contract of an existing CLR type, without having to sub-class it or recompile the original type.

using System;
public static class NewFeature
{
    public static int TointNewFeature(this int i, int j)
    {
        return i + j;
    }
    public static int TointOldFeature(int i, int j)
    {
        return i + j;
    }
}
class App
{
    static void Main()
    {
        int iDemo = 2.TointNewFeature(3);
        Console.WriteLine(iDemo);
        iDemo = NewFeature.TointOldFeature(2, 3);
        Console.WriteLine(iDemo);
    }
}

4) Anonymous Type

A convenient way to encapsulate a set of read only properties into a single object without having to first explicitly define type.

 DataClassesDataContext db = new DataClassesDataContext(); 
            var query = from n in db.tblNames
                        select new { n.name };

5) Lambda Expression( => )
It can be used to create a delegate or a expression type
Example taken from MSDN

delegate int del(int i);
    static void Main(string[] args)
    {
        del myDelegate = x => x * x;
        int j = myDelegate(5); //j = 25
    }

6) Auto Implemented Properties

If we declare this the compiler automatically adds the get accessor method and set accessor method to the corresponding properties.

in .NET 3.5

class Test
{
    public int Age { get; set; }
}

The compiler takes it as

Page Events – MasterPage + WebUserControl + Page + WebUserControl

2009-09-27T18:58:00.001+05:30

The page events Life Cycle in ASP.NET in Web Form application is a follows as .

Each Box are stands for

Page

WebUserControl Registered in Page

Master page

WebUserControl Registered in Master Page

ASP.NET Page Life Cycle

2009-09-23T23:10:00.003+05:30

Step 1 : Asp page consist of both .aspx and .cs page . When the page hits first the Asp.Net engine coverts the HTML portion into a structured series of programmatically created web controls.

E.g : I created a page Default.aspx page and place a TextBox1 in .aspx page.When the page compiles for the first time.A auto generated class file created(WINDOWS\Microsoft.NET\Framework\version\Temporary ASP.NET Files) its look like as follows

Consider a aspx page created like this.

<html xmlns="http://www.w3.org/1999/xhtml">
<head runat="server">
    <title></title>
</head>
<body>
    <form id="form1" runat="server">
    </br>
    What is your gender?
    <asp:TextBox ID="txtName" runat="server"></asp:TextBox>
    </form>
</body>
</html>

  Corresponding .CS page is

using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
public partial class _Default : System.Web.UI.Page
{
    protected void Page_Load(object sender, EventArgs e)
    {
    }
}

The Compiled page after first hit

Note : the TextBox1 is created in the class file.

During the second hit onwards it takes from the corresponding page(i.e it won’t create a .cs page again)

The purpose of auto generated class is to create a control hierarchy.The control hierarchy for the previous page is

If you set Trace="true" .You can see the below image.

Step 2 : PreInit

Checks the IsPostBack property to determine whether this is the first time page is load.

Page event to set Theme , ie when the page before initialize.

Step 3 : Init

All control has been initialized in the order of controls in the control Hierarchy

Step 4 : InitComplete

After the page is been initialized.

Step 5 : PreLoad

Event before the page is loaded

Step 6 : Load

calls the onload() event method and set properties for all controls in the page

Step 7 : Control Events

button click ,SelectedIndexChanged etc

Step 8 : LoadComplete

All the controls in the page has been loaded.

Step 9 : PreRender

Event to take final changes to the content of the page or its control.After this event all the control moves to the IOStream into a HTML format

Step 10 : SaveStateComplete

View sate is changed for all controls and page for postback purpose by calling SaveViewState().

Step 11 : Render

This is not an event ,but control’s markup to send to browser.

Step 12 : UnLoad

Final clean up is happens

Windows Live Writer - For Better Blogging

2009-09-13T14:41:00.001+05:30

In my last post i wrote how to copy a Code Snippet form visual studio to a blog . Today when i gone through some of the sites which says Windows live writer helps to write better blogs.

Steps that i followed to write a blog

step 1 : Download

Step 2 : After installation go to start –> programs –> Windows Live –> Windows Live Writer

Step 3 : Windows Live write ask for the details about your Blog details .After all the windows live writer open as shown below

Now you can write and publish your post :)

For Copying code from visual studio to blog is as follows

Step 1 : Go to Visual studio and copy the code that you want

Step 2 : Select Code Snippet from Windows Live Writer

Step 3 : Which opens a new window as shown below.From there select Edit –> Paste then Click Insert.

Step 4 : the output is displayed in your blog,when you click you publish in windows live writer.

WPF(Windows Presentation Foundation)

2009-09-11T21:23:00.003+05:30

Which helps to develop rich windows and smart client user interfaces with 2-D ,3-D,animations,Styles etc .Which offers a new markup language known as XAML (Extensible Application Markup Language ),to define UI elements,databinding,eventing and other features.

Const Vs Fields

2009-09-09T22:39:00.007+05:30

Constant : constant is stored in module's metadata after compilation, so it cannot change at the runtime .

E.g :

10 const int i = 9;

Note : Only primitive types(int,boolean,char etc ) can be Constants.Then the compiler takes const as literal(The value is hardcode in source code ) as shown below.

Fields: Are dynamic memory allocation, so value can be allocated at runtime only.

E.g :

   10  static readonly int i = 9;

Readonly – fields can be written only with in constructor method.

Note: No need to be primitive type and it support both static and non-static fields

Note : Any datatype the compiler directly supports are called primitive datatype .

E.g : in C# an int maps directly to a System.Int32

How to copy code from Visual studio to Html page

2009-09-06T14:26:00.012+05:30

When i am give some code snippets its not a good way to read for readers.And when i go to see some other blogs they are given the code in very easily and neat way.Today i got the solution,am sharing the same with you all.

Steps to follow

Step 1 : Get the Addins from here

Step 2 :Extract it to your Visual studio Addins folder(C:\Users\anishmarokey\Documents\Visual Studio 2008\Addins) ,if the Addins folder is not there create it.

Step 3 : Open visual studio,click in Tools -> Add-in Manager

Step 4 :Add-in Manager a message box will come.Checked the check box for "Copy as HTML" and click ok.

Step 5 :Now you can select any code and when rigth click "Copy As HTML" as shown

Step 6 : Paste in your blog.It looks like as shown below

static void Main(string[] args)
   { 
   }  

Applied Microsoft NET_Framework_Programming by Jeffrey Richter

2009-09-03T14:35:00.006+05:30

I am really interested in compiler.So i checked with different book which one is good.At last i got a good one "Applied Microsoft NET_Framework_Programming"

The following are the main topics in the book Applied Microsoft NET_Framework_Programming.

Part I: Basics of the Microsoft .NET Framework
Chapter 1 : The Architecture of the .NET Framework Development Platform

Overview of .NET Frame work is architected.CLR,CLS ,and a good understanding of ILDASM(intermediate laguage de assembler tool)

Chapter 2: Building, Packaging, Deploying, and Administering Applications and Types
This chapter gives a good understanding of how the assembly is build and how the version number is given and also gives a better understanding of Culture.

Chapter 3: Shared Assemblies
This chapter gives a better understanding of week and strong assembly.Why the public key is used etc . The main point in this chapter is GAC,what is the main function of GAC

Part II: Working with Types and the Common Language Runtime

Chapter 4: Type Fundamentals
This chapter gives a good understanding of Type safe and type casting
Chapter 5: Primitive, Reference, and Value Types
Primitive Type -Any dataType compiler directly and a good understanding of value type and Reference type

Chapter 6: Common Object Operations
How to compare objects ,object cloning etc

Part III: Designing Types
Chapter 7: Type Members and Their Accessibility
This chapter gives a better understanding of type member and different predefined attribute .

Chapter 8: Constants and Fields
This chapter say what happends in metadata when declare a constant and fields.

Chapter 9: Methods

This chapter gives me a better understanding of constructor,type constructor ,Operator overloading,ref and out ,virtual method

Chapter 10: Properties

This explains properties and indexers

Chapter 11: Events

This explains me How the delegate is Doing its action in events

Part IV: Essential Types

Chapter 12: Working with Text

This explains why the string is immutable ,says how the string is doing its operation with culture

Chapter 13: Enumerated Types and Bit Flags

This chapter goes through the idea of Enum in metadata

Chapter 14: Arrays

The array ,and says array is a reference type and various other methodologies in array

Chapter 15: Interfaces

This chapter goes through the idea of inferface in CLR . Gives me a better idea on the interface.

Chapter 16: Custom Attributes

This gives a better undersatanding of arrtibutes ,how to define user created custom attribute

Chapter 17: Delegates

The Microsoft .NET Framework exposes a callback function mechanism using delegates.

and lot of other various thing of delegates

Part V: Managing Types

Chapter 18: Exceptions

This chapter gives a better understanding of Exceptions.how to write user created exceptions

Chapter 19: Automatic Memory Management (Garbage Collection)

This chapter says how the GC is working.

Chapter 20: CLR Hosting, AppDomains, and Reflection

This chapter says how the CLR is hosting in Windows,what is the use of application domain etc

About author Jeffrey Richter

entity framework model

2009-08-22T14:57:00.010+05:30

Entiry FrameWorkModel

.edmx is an xml file that defines an Entity Data Model (EDM) ,Describe the target database schema ,and defines the mapping between the EDMI and the database.An .edmx file also contains information that is used by the ADO.NET entry datamodel Designer to render a model graphically.

How to Add .edmx File in a visual Studio project ?

Right Click on Solution Explorer -> New Item -> Select ADO.NET Entity Data Model .As shown in the figure

Note : In MVC application the .edmx file can be added in the Model .So it act as a Model for MVC

In Entity framework model it is same as LINQ to SQL .But here we can mix and match a number of different database vendors ,application servers or protocols to design an aggregated mash-up of objects which are constructed from a variety of tables,sources services etc.ADO.NET is released with .Net Framework 3.5 service pack 1.

HTTP Error 500.19 - Internal Server Error iis

2009-08-19T23:22:00.003+05:30

When i started to work IIS 7.0 in vista . I got an error HTTP Error 500.19 - Internal Server Error iis. I checked with the IIS features(control panel -> programs and Features -> Turn windows features on or off ) There the Internet Information Services -> World Wide Web -> Services Application Features are not selected. When i selected as shown in the below image.Now evey thing is working.

Note : World Wid Publishing Service - provides web connectivity and adminstration through the internet information Service Manager

My problem got solved . Now every thing is working.

Dynamic LINQ

2009-08-19T00:30:00.003+05:30

Linq Example :

var query = from g in db.Goan_Classifications
orderby g.Goan_Classification_Name
select g;

Dynamic Linq Example :

var query = db.Goan_Classifications.OrderBy("Goan_Classification_Name");

So it makes more easy.But the thing is that we need to use the system.Linq.Dymaic class,Which makes the development more easy.

Read More

Linq to Sql Debug Visualizer

2009-08-15T15:59:00.001+05:30

Probably the biggest programming model improvement being made in .NET 3.5 is the work being done to make querying data a first class programming concept. We call this overall querying programming model "LINQ", which stands for .NET Language Integrated Query.Read More

Assembly Binding Log Viewer (Fuslogvw.exe)

2009-08-12T23:12:00.000+05:30

The Assembly Binding Log Viewer displays details for assembly binds. This information helps you diagnose why the .NET Framework cannot locate an assembly at run time. Read more

TimeZoneInfo vs TimeZone

2009-08-11T00:30:00.006+05:30

The TimeZone class is new in 3.5 . This contains the information of Time zone in the world.
E.g :
static void Main(string[] args)
{
TimeZoneInfo tInfo = TimeZoneInfo.FindSystemTimeZoneById("India Standard Time");
DateTime dTime = DateTime.UtcNow;
DateTime localTime = TimeZoneInfo.ConvertTimeFromUtc(dt, mountain);
}

MSDN link
Finding the Time Zones

TimeZone

TimeZone(.Net 1.0) is to get the CurrentTimeZone(ie local time zone only) . So based on local time zone only we can convert it into necessary DateTime. But in TimeZoneinfo class helps to convert into DateTime based on any TimeZone in the World.

E.g : for TimeZone



static void Main(string[] args)
   {
       TimeZone tZ = TimeZone.CurrentTimeZone;
       DateTime dT = DateTime.UtcNow;
   }

Windows 8

2009-08-10T00:24:00.002+05:30

Few days back windows 7 released(July-22-2009) into market.But the thing is that Microsoft is working on Windows 8 .To read more

Visual studio Background Images

2009-08-03T23:30:00.003+05:30

Try this out to change the style of visual studio and Get Coding reports and related.

Mutable vs Immutable

2009-08-03T20:31:00.005+05:30

Why string is immutable and StringBuilder is mutable ?

string builder is mutable .Ie it is pure reference type.The following example the 'foo' is passed as a reference type .So the output is helloanish:
E.g:
class Program
{
static void Main(string[] args)
{
StringBuilder y =new StringBuilder();
y.Append("hello");

Program p = new Program();
p.foo( y);
Console.WriteLine(y );
}

void foo(StringBuilder sb)
{
sb .Append("anish:");
}
}

Stirng is immutable .In some ways it to be value types .These are known as immutable .The following example the 'foo' is passed is a string but this act as a value type .So the output is 'hello'

E.g:

class Program
{
static void Main(string[] args)
{
string y =string.Empty;
y="hello";

Program p = new Program();
p.foo( y);
Console.WriteLine(y );
}

void foo(string sb)
{
sb +="anish:";
}
}

Note : note only string .Some of the other types also.

Rather than creating a new storage location for the function member declaration,the same storage location can be used with the help of ref type.

E.g : class Program
{
static void Main(string[] args)
{
string y ="";
y="hello";

Program p = new Program();
p.foo(ref y);
Console.WriteLine(y );
}

void foo(ref string sb)
{
sb="anish:";
}
}

Output is not hello,its anish

Out type :Same a ref .The thing is that initially the variable is unassigned.

Web site vs Web Application

2009-07-31T11:56:00.008+05:30

visual studio 2003 : Introduced Web Application model .
Note :It has static Compilation

Visual studio 2005 : Introduced WebSite project type was introduced .
Note :

It contains both web Application Model and webSite model.

Visual studio 2008 : Supports both types of project

Web Site model and Web Application

And is based on folder model .After SP1 project file was introduced in visual studio 2005.
WebApplication project is more structured than web site project.
Class file shuuld be placed inside the App_Code.
Web Application project type is restricted to one language .Where as web site supports multiple languages,Because web site is compiled dynamically.
web site supports multiple lanuages files ,but those files need to be in the same folder .So the changes required in the webconfig.

E.g:

When deploy web Applicaton you can just copy the compiled elements and visual elements to the iis folder..Where as website we need to copy everything to the iis to work.
Code behind pages was introduced in visual studio 2005.Where we can create both the files(with code behind and with out code behind paes)
Partial class was also introduced in visual studio 2005

Dynamic compilation in Website

When you sent a request for a ASP.Net page,Frame work checks for the corresponding page and if the class is not exists ,Frame work compiles the page into a new .Net class and the stored the compiled class into the temporary ASP.Net folder located at

C:\WINDOWS\Microsoft.NET\Framework\v2.0.50727\Temporary ASP.NET Files

In future if a request comes to the same page ,the page is not compiled again .The previously compiled class is executed and returns to the browser.This process is called ASP.Net dynamic compilation.
If Asp.Net page is modified corresponding to .Net class is automatically deleted and when a new request comes for that page it compiles the modified page into a new .Net class.

To change compiled in Web site are as follows as

change the compilation mode using the page

E.g:

To change compilation mode using webconfig

E.g :

To get the microsecond in C#

2009-07-30T21:10:00.001+05:30

"ffffff" format string is to represent microseconds in C#

E.g :DateTime.Now.ToString("HH:mm:ss.ffffff")

To find server address using sql server 2005

2009-07-30T09:47:00.002+05:30

@@ServerName :returns the name of the local server that is running in sql server.

more details

Common Table Expression(CTE) and ROW_NUMBER()

2009-07-27T20:26:00.003+05:30

can be thought of as a temporary result set that is defined with in the execution of the scope of a single select,insert,update,delete or create view statement.

A CTE can be used to :

create a recursive query .
substitute for a view when the general use of a view is not required ,that is you dont have to store the definition in metadata
enable grouping by a column that is derived from a scalar subset ,or a function that is not deterministic or has extrenal access.
reference the resulting table multiple time in the same statement.

Syntax

with expression_name [(column name [,....n])]
AS
(CTE query definition)

E.g :with [EMP_SCHED order by rowid] as
(select row_number() over (order by emp_id asc) as rowid ,* from EMP_SCHED)
select * from [EMP_SCHED order by rowid] where rowid=3

Row_Number()

Returns the sequential number of a row with in a partition of a result set ,starting at 1 for the first in each partition

Syntax
ROW_NUMBER() OVER ([ ] )

E.g :with [EMP_SCHED order by rowid] as
(select row_number() over (order by emp_id asc) as rowid ,* from EMP_SCHED)
select * from [EMP_SCHED order by rowid] where rowid=3

Collections in C# 2 Part 1

2009-07-26T20:55:00.005+05:30

Collections is introduced in C# 2 . To make the strongly typed collections

C#1 : it contains array list not collections class

Disadvantage of Arraylist

arraylist has no compile time information.If any mismatch type is there error will throw at runtime only.(It is weekly typed collection)

E.g :public class Employee
{
string name;
public string Name
{
get{return name;}

}
decimal salary;
public decimal Salary
{
get{return salary;}
}
public Employee(string name, decimal salary)
{
this.name = name;
this.salary = salary;
}
}
public class program
{
public static void Main()
{
ArrayList al = new ArrayList();
al.Add(new Employee("Anish", 20000m));
al.Add(new Employee("marokey",30000m));

foreach (Employee emp in al)
{
Console.Write(emp.Name);
Console.Write(emp.Salary);
Console.WriteLine();
}
}
}
Result : Anish20000
marokey30000

Just look the below code produce no error at compile time but throws error at runtime
public class Employee
{
string name;
public string Name
{
get{return name;}

}
decimal salary;
public decimal Salary
{
get{return salary;}
}
public Employee(string name, decimal salary)
{
this.name = name;
this.salary = salary;
}
}
public class program
{
public static void Main()
{
ArrayList al = new ArrayList();
al.Add(new Employee("Anish", 2000m));
al.Add(new Employee("marokey",30000m));
al.Add("Error");

foreach (Employee emp in al)
{
Console.Write(emp.Name);
Console.Write(emp.Salary);
Console.WriteLine();
}
}
}

Error : Unable to cast object of type 'System.String' to type 'dummy.Employee

Array list allows all items .It doesnot consider about the item

To avoid these types of error collection class is introduced .

public class Employee
{
string name;
public string Name
{
get{return name;}

}
decimal salary;
public decimal Salary
{
get{return salary;}
}
public Employee(string name, decimal salary)
{
this.name = name;
this.salary = salary;
}

public Employee(string name)
{
this.name = name;
}
}
public class program
{
public static void Main()
{
List empList = new List();
empList.Add(new Employee("Anish", 2000m));
empList.Add(new Employee("marokey", 30000m));
empList.Add("Error");
}
}

During compile time itself it throws error
Error 1 :The best overloaded method match for 'System.Collections.Generic.List.Add(dummy.Employee)' has some invalid arguments
Error 2 : cannot convert from 'string' to 'dummy.Employee'

Note : This is known as strongly typed collections

Collection Class

1)ArrayList : A simple resizeable ,indexbased collection of objects

2)SortedList : A sorted Collection of name/value pairs.And accessible by key and by index

E.g : static void Main()
{
SortedList sl = new SortedList();
sl.Add("maorkey",0);
sl.Add("Anish",1);

Console.WriteLine( sl.GetKey(1));
}

Note :When it creates a list it automatically sort the data based on the object key.
It wont allow redundant values.

E.g: static void Main()
{
SortedList sl = new SortedList();
sl.Add("Anish",0);
sl.Add("Anish",1);

Console.WriteLine( sl.GetKey(1));
}

//Error (Item is has already been added)

3)Queue : Represent the first-in-first-out collection of objects

static void Main()
{
Queue myQ = new Queue();
myQ.Enqueue("a");
myQ.Enqueue("n");
myQ.Enqueue("i");

Console.WriteLine(myQ.Dequeue());
Console.WriteLine(myQ.Dequeue());
Console.WriteLine(myQ.Dequeue());
}

Result : ani (FIFO manner)

Better way of using Queue is generic Queue

E.g : static void Main()
{
Queue smyQ = new Queue();
smyQ.Enqueue("a");
smyQ.Enqueue("n");
smyQ.Enqueue("i");

Console.WriteLine(smyQ.Dequeue());
Console.WriteLine(smyQ.Dequeue());
}

Note : This queue allows only sting to iterate.
4)Stack : Last in First out non generic collection of objects

static void Main()
{
Stack sTack = new Stack();
sTack.Push("a");
sTack.Push("n");
sTack.Push("i");

Console.WriteLine(sTack.Pop());
Console.WriteLine(sTack.Pop());
Console.WriteLine(sTack.Pop());
}

Result : ina(LIFO manner)

Generic Stack is the better way of using

static void Main()
{
Stack sTack = new Stack();
sTack.Push("a");
sTack.Push("n");
sTack.Push("i");

Console.WriteLine(sTack.Pop());
Console.WriteLine(sTack.Pop());
Console.WriteLine(sTack.Pop());
}

5)HashTable : A collection of name/value pair of objects that allow retrieval of name or index

E.g: static void Main()
{
Hashtable openWith = new Hashtable();
openWith.Add("txt", "notepad.exe");
openWith.Add("bmp", "paint.exe");
openWith.Add("dib", "paint.exe");
openWith.Add("rtf", "wordpad.exe");

Console.WriteLine();
foreach (DictionaryEntry de in openWith)
{
Console.WriteLine("Key = {0}, Value = {1}", de.Key, de.Value);
}
}

Generic HashTable is not there .Because it takes Object as value and key.Dictionary class can act as generic hashTable not Exactly.Because there we can set the object key and value.

6)BitArray :compact array of bit values ,Which as represent as Boolean.

static void Main()
{

BitArray myBA1 = new BitArray(5);
Console.WriteLine("myBA1");
Console.WriteLine(" Count: {0}", myBA1.Count);
Console.WriteLine(" Length: {0}", myBA1.Length);
Console.WriteLine(" Values:");
PrintValues(myBA1, 8);
}

public static void PrintValues(IEnumerable myList, int myWidth)
{
int i = myWidth;
foreach (Object obj in myList)
{
if (i <= 0)
{
i = myWidth;
Console.WriteLine();
}
i--;
Console.Write("{0,8}", obj);
}
Console.WriteLine();
}
}

7)Stirng Collection : It allows null and duplicate values

static void Main()
{

StringCollection myCol = new StringCollection();

// Add a range of elements from an array to the end of the StringCollection.
String[] myArr = new String[] { "RED", "orange", "yellow", "RED", "green", "blue", "RED", "indigo", "violet", "RED" };
myCol.AddRange(myArr);
PrintValues1(myCol);
}

public static void PrintValues1(StringCollection myCol)
{
foreach (Object obj in myCol)
Console.WriteLine(" {0}", obj);
Console.WriteLine();
}

8) StringDictionary :collection of name/value pair .It can retrieve by name or index.It is strongly typed .

static void Main()
{

StringDictionary myCol = new StringDictionary();

// Add a range of elements from an array to the end of the StringCollection.
myCol.Add("red", "0");
myCol.Add("blue", "1");
myCol.Add("green", "2");
PrintKeysAndValues1(myCol);
}

public static void PrintKeysAndValues1(StringDictionary myCol)
{
Console.WriteLine(" KEY VALUE");
foreach (DictionaryEntry de in myCol)
Console.WriteLine(" {0,-25} {1}", de.Key, de.Value);
Console.WriteLine();
}
9) List directory :An efficient collection to store small list of objects .
It is smaller and faster than the HashTable .If the number of element is 10 or less.

10)HybridDictionary :Using a ListDictionary while collection is small and it switches to HashTable when he collection is large.

11)NameValueCollection :Collection of name/ value pairs . It is less performance than HashTable.

Set single user mode in sql server 2oo5

2009-07-25T13:36:00.003+05:30

The single user-mode specifies that only one user at a time can access the database and is generally used for maintenance actions

To set by using SQL query
Set single user mode

ALTER DATABASE [DATABASENAME] SET SINGLE_USER WITH NO_WAIT

Set back to multi user

ALTER DATABASE [DATABASENAME] SET MULTI_USER WITH NO_WAIT

Implict vs explict

2009-07-24T20:38:00.002+05:30

Implicit : something is being done automatically
Explicit : have to write something in the source code to indicate what to happen

E.g: int i =20;
long y =i // Implicit conversion from int to long
int z = (long)y // Explicit conversion from long to int

Guidelines for Names(taken from MSDN)

2009-07-24T11:45:00.003+05:30

Cast Style

Pascal Casting : First letter in the identifier and the first letter of each subsequent concatenated word are capitalize.Use Pascal case for identifiers for three or more characters .

E.g: BlackColor

Camel Casting : first letter of identifier is lowercase and first letter of each subsequent concatenated word is capitalize

E.g: blackColor

UpperCase :All the letters in the identifiers are capitalized.

E.g : IO

For more details MSDN

Change schema on table and proc in SQL SERVER 2005

2009-07-23T14:40:00.004+05:30

To change the schema table from one to another is by executing the query

select 'ALTER SCHEMA dbo TRANSFER ' + s.Name+ '.' + p.Name
FROM sys.tables p
inner join
sys.Schemas s on p.schema_id = s.schema_id

Result :

ALTER SCHEMA dbo TRANSFER aniSchema.video_master
ALTER SCHEMA dbo TRANSFER aniSchema.enquiry_master
ALTER SCHEMA dbo TRANSFER aniSchema.blog_master

Copy the result and execute the result in new query then the schema(aniSchema) is changed to dbo .

OR
For tables and views

SELECT 'ALTER SCHEMA dbo TRANSFER ' + TABLE_SCHEMA + '.' + TABLE_NAME FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_SCHEMA = 'aniSchema'

And do the above step after getting the result

Visual Studio Short Cut Keys

2009-07-19T12:57:00.009+05:30

Shortcut keys are easy to navigate,Increase productivity ,etc .... :)

These are the short cut keys i like in visual studio

To understanding the code

Class view : [ctrl-w] ,[ctrl -c]
Note : helps to see the class view.
Create Class diagram (by adding .cd file to the project)
Note : This will display the class diagram created.copy and paste the necessary methods ,properties from one class to another class.

Navigate through code

F12 : GoTODefinition
shift -F12 : Show all the reference to a symbol
F8:Cycle through list of items in the currently active output window
shift - F8 : same as F8 but opposite in direction

ctrl - m ,ctrl- m: collapses /expand the method the cursor is currently in
ctrl -m,ctrl-o : collapse all methods to the outline view

ctrl - -(minus) : moves to the cursor previous location
ctrl - shift - -(minus) :moves to the cursor last location

ctrl - F :find menu
ctrl - H : find and replace
ctrl - i :incremental search
ctrl - shift - F : find in all files

Modify code

ctrl -k, ctrl - c : command out the selected code
ctrl -k ,ctrl - u : uncommand out the selected code
ctrl-k ,ctrl -f :auto format the selected code

ctrl - R ,ctrl - M :extract method
ctrl -R,ctrl - E :encapsulate field
ctrl- R ,ctrl -l :extract interface
F2 :Rename

Debugging code

F10 :step over
ctrl - F10 :Run to cursor
F11 :step into
shift - F11 : step out
F9:toggle a break point
F5 :Run with debugging
Shift - F5 :stop debugging
ctrl-F5 :Run without Debugging

ER Diagram in Sql server 2005

2009-07-18T22:33:00.004+05:30

To see the ER diagram for sql server 2005.

Right click the Database Diagrams on the particular table and select new database diagram

Error i Got

Database diagram support objects cannot be installed because this database does not have a valid owner. To continue, first use the Files page of the Database Properties dialog box or the ALTER AUTHORIZATION statement to set the database owner to a valid login, then add the database diagram support objects.

How i Solved

Right on database ,Choose properties
Go to options menu
check whether the compatibility level :SQL Server 2005(90)
Click ok

Still i got the same error . After that i executed
ALTER AUTHORIZATION ON DATABASE::DatabaseName TO sa

Every thing working fine and i got ER diagram

Joining two tables Using UNION

2009-07-18T12:51:00.004+05:30

two tables

//No Error

select Fname,Lname from tbl_Master

union

select Fname,Lname from tbl_Master

Two proc

//Error

exec SPtbl_Master1

union

exec SPtbl_Master2

Two Table-valued Functions

//No Error

select * from Fntbl_Master1('p')

union

select * from Fntbl_Master2('p')

charindex Vs patindex

2009-07-18T11:45:00.002+05:30

charindex : Returns the starting position of the first occurrence of a pattern in a specified expression ,or zero if the pattern is not matched

E.g: select charindex('+','anish+varghese')

Result : 6

patindex:Returns the starting position if found.And it can use wildcard characters

E.g: select patindex('%+%','anish+varghese')

Result : 6

Where is the difference ?

Actually patindex act as a like operator .

% : any string of zero or more characters

E.g : select charindex('%+%','anish+varghese')

Result : 0

E.g: select patindex('%+%','anish+varghese')

Result : 6

E.g :select patindex('%+','anishvarghese+')

Result :14

E.g:select patindex('+%','+anishvarghese')

Result :1

_(underScore) :any single character

E.g:select patindex('%_r%','anishvarghese')

Result :7

[ ] : Any single character with in the specified range [a-z] or ser [abcd]

E.g:select patindex('%[0-9]%','anish4varghese')

Result:6

[^] :Any sigle character not with in the specified range [^a-z] or set [^abcd]

E.g:select patindex('%h%','anish4varghese')

Result :5

E.g:select patindex('%h[^4]%','anish4varghese')

Result :11

Implicitly Type local variable

2009-07-13T23:52:00.002+05:30

The Implicitly Type local variable being declared is inferred from the expression used to initialize variable.

E.g : var i =10;
var s="anish";

Note : it can be a anonymous type ,user defined type or FCL(frame work class library) type etc.But the compiler determines the type.

E.g: var i =10//implicitly typed
int i=10//Explicitly typed

collection Initializers in .Net 3.0

2009-07-13T23:00:00.004+05:30

.Net offers a new features of initializing objects.

class people
{
public string FirstName { get; set; }
public string LastName { get; set; }
}

class main
{
static void Main()
{
//Method 1:Adding people to List
people People = new people();
List Names = new List();
People.FirstName = "Anish";
People.LastName = "Varghese";
Names.Add(People);
People.FirstName = "ani";
People.LastName = "marokey";
Names.Add(People);

//Method 2:Adding people to List
List Names1 = new List();
Names1.Add(new people { FirstName = "Anish", LastName = "Varghese" });
Names1.Add(new people { FirstName = "ani", LastName = "marokey" });

//Method 3:Adding people to List
List Names2 = new List()
{
new people{FirstName="Anish",LastName="Varghese"},
new people{FirstName="ani",LastName="marokey"}
};
//Method 4 :Adding people to List

List Names3 = new List { new people { FirstName = "Anish", LastName = "Varghese" }, new people { FirstName = "ani", LastName = "marokey" } };
}

Note :where we can use is a class has no default constructor and initialization is required.

Type Safe in C#

2009-07-13T10:00:00.003+05:30

When casting from one type to another.C# compiler will check whether the casting wont cause any problem .Then only the casting will happen other wise it throw error "InvalidCastExpression" . This is why .Net is type safe.

We can freely cast form a derived class to a base class .But we cannot blindly convert a base class to a derived class.

E.g1 :
object obj = new object();
string s = (string)obj;
//Error "Unable to cast object of type 'System.Object' to type 'System.String' "

Note : Because system.String is derived from system.Object(base class of .NET ).i.e we are converting from a base class to derived class.

Object obj = "foo";
string str = (string)obj;
//No error

Note : we are converting derived class to a base class.

E.g2:
class classA
{

}

class classB:classA
{
}

class main
{
public static void Main()
{
classA a = new classA();
classB b = (classB)a;
//Error " Unable to cast object of type 'Console_Anisj.classA' to type 'Console_Anisj.classB' "

}
}

Note : Because classB is derived from ClassA.i.e we are converting from a base class to derived class.

class classA
{

}

class classB:classA
{
}

class main
{
public static void Main()
{
classB b = new classB();
classA a = (classA)b;
}
}

Note : we are converting derived class to a base class.

Why this is compailing ?

During compile time compiler checks whether the classA and classB is derived from System.Object class.So it wont throw any error.During run time it will check the base class and derived class.This is the reason the error is throwing in the runtime.

Best way to check the casting by using is and as operator in C#

object obj = new object();
System.Boolean b1 = (obj is System.Object);
System.Boolean b2 = (obj is System.String);

Note : here b1 is true and b2 is false.

classA a = new classA();
classB b = new classB();
System.Boolean b1 = (a is classB);
System.Boolean b2 = (b is classA);

if(b2)
{
classB b = new classB();
classA a = (classA)b;
}

Note : here the b1 is false and b2 is true .CLR wants to check the type twice one out side the
if loop and one inside the if loop. so introduced the new concept as "as"operator.

classA a = new classA();
classB b = new classB();
classA a1 = b as classA;
classB b1 = a as classB;
if (a1 != null)
{
classA a2 = (classA)b;
}
if (b1 != null)
{
classB b2 = (classB)a;
}

Note :if the type can be casting then it returns not null pointer and if it returns null it cannot be cast.CLR wants to check the type only once.so it improve the performance.

Deploy Asp.Net application using "compilation debug="false"

2009-07-10T16:14:00.005+05:30

If you are deploying using compilation debug="true".The following will happen.

The compilation of ASP.NET pages takes longer
Code executes slower
Memory useage will be high .during run time
Scripts and images download from the webresourcre.axd handler are not catched

Note:the last point is important.If you are using external scripts(javascript ,css etc ). "" webresourcre.axd handler automatically set long cache for on the resources retrieved via it.So that the resource is only downloaded once to the client and catched there forever.

For more details click Here

CLR Profiler

2009-07-10T12:18:00.003+05:30

CLR Profiler: this allows developers to see the allocation profile of their managed code

Note :if you love your memory space of your server try this .For more details click here .This link is for .NET Framework 2.0. How to use CLR Profile .See the read me file that is included in the Zip.

Content delivery Network

2009-07-09T21:09:00.002+05:30

Content Delivery Network(CDN) is a collection of web server distributed across multiple location to deliver content more efficiently to users.The server is selected for delivering content to a specific user is typically based on the measure of network work proximity.

E.g:the server with fastest network hops or the server with the quickest response time is chosen.

CDN service provide companies : Akamai Technologies,Mirror Image Internet or limelight networks.

Google Chrome OS is comming

2009-07-09T12:04:00.003+05:30

Google is also comming with there latest OS (open source) into the market.

It will run with a Linux kernel as its base
It will boot directly into the Chrome Web browser
It will be aimed primarily at netbooks
It will run on both x86 and ARM processors
It will not be designed to have local storage; all data will be stored in the cloud
Google will not entice developers to build software to run on the Chrome OS; instead, they want them to build Web apps that will run on any standards-based browser
The three most important features will be “speed, simplicity and security,” according to Google
Google will release the software to the open source community before the end of 2009
Announced Chrome OS hardware partners: Acer, Adobe, ASUS, Freescale, Hewlett-Packard, Lenovo, Qualcomm, Texas Instruments, and Toshiba.
Netbooks running Chrome OS will be available in the second half of 2010

For more details Read

sp_spaceused system procedure

2009-07-08T21:28:00.002+05:30

This will tells whatt is the physical space used by the system and the objects

exec sp_spaceused 'databasename'

for more details Click Here

Cryptographic Serivce Providers

2009-07-08T16:50:00.002+05:30

It is a software library that implements the cryptographic serverce Programming interface .CSPs are responsible for encryption and decryption .

CSP : Are independent modules that can be used by different algorithms .A user wants to call the CSP .CSP are responsible for implementing cryptographic alrorithms.

Note:some of the special types of DLL are implemented by CSP.In delay sigining Microsoft uses CSP ,siginal varifies when windows load the CSP.

: CSP are the "containers" that abstract the location of these keys.When it loads the key grabed from the CSP container.

:If private/Public key pairs in a CSP container donot use the AssemblyKeyFileAttribute or AL.EXEs /Keyf[ile].Insted it uses the system.Reflection.AssemblyKeyNameAttribute or AL.EXEs /keyn[ame](takes the name of the key container in CSP)

C# allows Passing Parameters by reference

2009-07-08T10:30:00.003+05:30

By default CLR assumes that all the parameters to a method are value type.

C# allows pass parameter by reference type in two ways

Ref :The caller must initialized the parameter's value to the method

E.g: Public static void RefAni(ref int iVal)

{

iVal+=2;

}

public static void Main()

{

int i=3; //i must be intialized

RefAni(ref i);

Console.Writeline(i);

}

Note : The i value is declared on the thread stack and initialized to 3.Address location of i is passed to RefAni method. RefAni iVal takes the value and new value is returned to the caller.

2.Out: The caller must not have to be initalized the parameter's value to the method

E.g:

Public static void OutAni(out int iVal)

{

iVal+=2;

}

public static void Main()

{

int i; //doesnot have to be intialized

OutAni(out i);

Console.Writeline(i);

}

Note : the i is declared on the thread stack .The address is then passed to the OutAni(here no values are comming).Inside the OutAni iVal is initailized to 2 and new value is returned to the caller.

Why ref and out is required ?

This is that the compailer want to do the right thing automatically.

Note : overloading is possiblie in this

E.g : Public static void OutAni(out int iVal)

Public static void OutAni(int iVal)

This will compile properly.

Command Line Tips

2009-07-07T21:16:00.004+05:30

open command prompt and type the following ,Makes your work easy

enable firewall: netsh firewall set opmode mode = enable

disable firewall : netsh firewall set opmode mode =disable

change command line title :title new_window

computer name :hostname

os version :ver

logoff system :logoff

to see date :date

Windows XP Shortcut Keys

2009-07-07T20:52:00.007+05:30

In Run

Devenv : Open visual studio

ssmsee : Open sql server management studio expression edition

Control : Open control panel

services.msc : open windows services

appwiz.cpl : add/Remove programs

mspaint : Open paint

iexplore.exe : open internet explore

safari : open safari browser

firefox : open mizilla browser

chrome : open chrome browser

perfmon.exe : Open performance moniter

shutdown -s -t 01 : Shutdown xp in 01 second

shutdown -s :shutdown

shutdown -r :restart

shutdown -a :abort shutdown

nero : open nero

outlook : open outlook express

winword : open word

assembly : Open GAC

cliconfg : open SQL Server Client Network

cleanmgr:open Cleanup Tool

userinit:open documents

Difference between Primary key and unique key?

2009-07-06T17:53:00.004+05:30

Primary Key : Creates uniqueness for the column.And also creates clustered index on the column,by default

Unique Key :Creates uniqueness for the column.By default it creates a Non clustered index

To know more about Clustered index and non Clustered index.

Note : try to avoid using GUID as primaryKey (it will waste of your space (16 bytes)).If the database volume is high it will affect performance.if use int it will take less space(4 bytes).

Union and UnionAll

2009-07-06T12:26:00.002+05:30

Union:its Like a join Command.When using the union all the selected columns need to be of the same datatype.Only distinct values are selected.

Union All :it almost like union.There is no distinct operation so it will take all the values.

Rules for Union
a union must be composed of two or more select statement and each is separated by a keyword union
Each union must contain same column,expression or aggregate function.
Column name need not be same ,but they must be the type that the sql can implicitly convert.

Value type can have an implict Constructor?

2009-07-03T16:59:00.000+05:30

All the value type is initialized to zero or null.This is because it dont have a implict constructor.

ways you can define a variable

1) variable inside a Reference Type

E.g:

Class c

{

int i;

};

test()

{

c C = new c(); //At this point GC will take care of it

}

Note : GC checks the variable is zero or NULL before releasing the variable from heap.

2) Inside Value type

struct structDemo

{

int i;

};

test()

{

c C = new c(); //At this point JIT will take care of it

}

Note : JIT checks inside the stack.if nothing is defined stack place occupied with zero labeled.

3)If value type has a value ,stack occupied with the that value as labled

Linq(Language integrated Query) Part 1

2009-07-02T20:49:00.005+05:30

LinQ

LinQ is tightly coupled to C# and VB

Imperative Programming language: Programmers want to describe the statement(C# and VB)

Declartive Programming language : In the case of SQL,the engine determines the physical strategy to retrive the logical request made in the form of a query.

Most mordern language supports RDBMS in their code,like Xml .But nothing was type safe.Microsoft solution is LinQ ,a type safe query.

Note : LinQ can be coded in Lambda syntax(Anonymous code blocks from functional programming Community ) and comprehension syntax.

Lambda Syntax : Normally takes => as expression.

How linq makes development Easy

Example 1 : without using LinQ

void NameContainsA()

{

List cell = new List ();

string[] Names = new string[]{

"Anish"

,"Varghese"

,"Linq"

,"Anish Varghese"};

for(int iCount=0; iCount<>

{

if(Names [iCount].StartsWith("A"))

{

cell.Add(Names[i]);

}

Example 2 : With LinQ

void NameContainsA()

{

List cell = new List ();

string[] Names = new string[]{

"Anish"

,"Varghese"

,"Linq"

,"Anish Varghese"};

cell = (from n in Names where n.StartsWith("A") select n).ToList();

}

Note : this makes the development very easy.

Example 3 : With Linq (above same example with less number of codes)

void NameContainsA()

{

List cell = new List ();

string[] Names = new string[]{

"Anish"

,"Varghese"

,"Linq"

,"Anish Varghese"};

cell = Names.Where(x => x.StartsWith("A")).ToList();

}

NEWSEQUENTIALID()

2009-07-02T16:39:00.000+05:30

Creates a GUID that is greater than any GUID previously generated by this function on a specified computer.

CREATE TABLE myGUIDTable (myCol uniqueidentifier DEFAULT NEWSEQUENTIALID())

this is grate to see the id is created based on the machine id .

E.g: id created for me B0DD13B4-FB66-DE11-A148-001CC031A29A

my Physical address of my machine is 00-1C-C0-31-A2-9A

To know you ip address this will help you click here

to see your machine address type ipconfig/all

you can see physical address : that is same as the last 12 digits of your id

They introduced this to improve the performance of uniqueidentifiers when inserting

to get more information click here

.Net 3.0

2009-07-02T07:37:00.000+05:30

New features in .net Framework 3.o?

The .Net framework 3.0 contains the same CLR 2.0 and base class libraries.The three new things in .Net 3.0 are windows persentation fountation(WPF),Windows Communication Fountation(WCF) and Windows work Flow foundation(WWF).

Windows Presentation Foundation : Helps advanced 3D animaitons and graphics.it uses Extesibile Application Mark up language.

Windows Communication Foundation :offers Service oriented message trasaction.It uses soap(Simple object access protocol) ,so it is reliable and secure.

Windows Work Flow Foundation : Offers automated business process.helps to tranfer whole or a part ,during which documentation information or task from one participient to another for action.

Properties in C#

2009-07-01T22:57:00.000+05:30

Properties in C#

Why property are required?
If you are simply delcaring a variable and you want to do some operation on a variable .
E.g: Class demo1
{
Public string Age;
}
Class Maindemo1
{
demo1 Demo = new demo1();
Demo.Age= -35;
}

This we want to check manually whether the logic is correct or not.Like the below way

class Employee
{
public int Age;

public int GetAge()
{
return (Age);
}

public void SetAge(int value)
{
if(value<0)
throw new ArgumentOutOfRangeException ("Age Must be greater than zero");
Age = value;
}

}

class MainEmployee
{
static void Main()
{
Employee e = new Employee();
e.SetAge(35);
int i = e.GetAge();
}
}

This will solve the above problem.If Age is less than zero it will throw an error.
Disadvantage : want to write long number of codes.and user must call a method rather than a variable.

CLR offers a mechanism to overcome the above disadvantage,ie by using properties.
class Employee
{
private int _Age1;
public int Age1
{
get
{
return _Age1;
}
set
{
if (value < 0)
throw new ArgumentOutOfRangeException("Age Must be greater than zero");
_Age1 = value;
}
}
}

class MainEmployee
{
static void Main()
{
Employee e = new Employee();
e.Age1 = 35;
int j = e.Age1;
}
}

The CLR offers get accessor and set accessor.During compile time it will automatically added GetAge() and SetAge(int value).And makes the code easy

Types of Properties

1) Parameterless Property
2) Parameterful property

Parameterless Property

This doesn’t have a parameter
E.g :
public int Age1
{
get
{
return _Age1;
}
set
{
if (value < 0)
throw new ArgumentOutOfRangeException("Age Must be greater than zero");
_Age1 = value;
}
}
}

Parameterful property

C# developer to overload [] operator

private int[] arr=new int[10]

public int this[int i]

{

get

{

return arr[i];

}

set

{

arr[i]=value;

}

CLR doesnot differentiate parameterless properties and parameterful proprty.C# team set this[] as syntax for indexer.which this choice means is that C# allows indexer to be defined only instace of the objects.so C# doesnot allow developer to define a static parameterful property.

Strong Assembly and Weak Assembly

2009-06-30T23:40:00.000+05:30

Both compailer are created by Compailer and AL.exe(Assembly linker,which helps to create the assembly in your project also helps to add new modules.).But the difference is only the Private and public keys.

Weak Assembly : can deploy in your application directory.Not globally(ie in GAC)

Strong Assembly: Can deploy both in application directory and globally.

if you want to create your application as strong ,you should give sigining from your project properties.it will create a public key after that only you can deploy in GAC.

sigining :sn.exe(Strong name tool) is responsible for creating the public key ,which is a part of .Net SDK(.NET Software Development Kit) .More Details

Note : the combination of file name,assembly version ,culture and the public key gives the strong name,which is guaranteed to be unique.

you can check the public key value by take command prompt of visual studio

and map your dll path(C:\Documents and Settings\anish\My Documents\Visual Studio 2008\Projects\AnishClassDll\AnishClassDll\bin\Debug) then type sn -T demo.dll.

this public key is you are given in the web config file to map this to the particular location.

Note :when you create a strong name it create a unique key like this

070200000024000052534132000400000100010031f38d3b2e55454ed52c5d2469 11011be59543

it is difficult to read the developer so modified to a human readable form like

3e95326fea73ef1783b777

Why the strong name is needed ?

This is the way that the compailer finds which assembly it wants to load.only one public key with same name is accepted in GAC.

Extension Method

2009-06-30T22:04:00.000+05:30

This is the new feature of C# 3.0

Static method can invoke using instance method syntax.

static class contain a parameter with this key word.

E.g:

public static class NewFeature

{

public static int TointNewFeature(this int i,int j)

{

return i+j;

}

public static int TointOldFeature(int i, int j)

{

return i+j;

}

class App

{

static void Main()

{

int iDemo = 2.TointNewFeature(3);

Console.WriteLine(iDemo);

iDemo = NewFeature.TointOldFeature(2,3);

Console.WriteLine(iDemo);

}

Features of Extension Method

Contains the keyword this
here the parameter can be leave.ie parameter should not be provided
can be called only by an instant variable.

In ILDASM you can see system.runtime.compilerservices .extensionAttribute for the

TointNewFeature method.ie during runtime the extension is flagged and do the rest of operation.

Using Keyword in C#

2009-06-30T22:02:00.000+05:30

When you use the using statement the Compiler automatically throws try and finally block.inside the Finally block compiler automatically cast to IDisposable inrerface and automatically calls dispose method.

Note : using can be used only which it supports IDisposable interface.So it reduce the syntax and help to dispose method automatically.reduce the number of errors.

E,g

Using(SqlConnection con = new SqlConnection())

{

…………….

}

The compailer automatically added try - finally to ‘con’ . and do the previous operation by using IDisposable.

Common Type System(CTS)

2009-06-30T08:10:00.000+05:30

Common Type System(CTS)

Types are mechanism by which code one programming language and can be talk to different programming language.

CTS contains contains one or more member.They are fields,method,property and events

CTS also maintains access modifiers like Private,Family,Family and Assembly,Assembly,Family or assembly and public.

Note 1) CTS rules inheritance ,vrtual functions ,object life time etc.

2) CTS rules all the type must inherit from system.object.

Conclusion : Manages the type

Common Language Specification(CLS)

CLR integrates all the language and consider as same type. i.e CLR produce

self-describing type information(metadata) and a common executable environment.

Note: Some of the things we can easily write in one language not in others .CLS makes the

development easy ,i.e metada can read all other language that uses the CLR as compailer.

Conclution : Manages different languages to support.

Temporary table in SQL

2009-06-30T07:28:00.000+05:30

There are two types of temporary tables are available in sql server

1) Local Temporary table

2) Global Temporary table

Local Temporary table: They are visible to only the current connection of the user.For each user it will create a temporary table along with a session value and delete from the system temp table once the inistance of the user to the particular table has gone.To add this table add a sign(#) before the table.

E.g:CREATE TABLE #tblTemp

(

col1 int,etc

)

2) Global Temporary table:They are visible to any user after they are created and delete when the user references the table disconnect from the sql server.To add this table add a sign(##) before the table.

E.g:CREATE TABLE ##tblTemp

(

col1 int,etc

)

Advantages :by using this we can avoid cursors and can do as a prameterized views.

Limitations :dont use properly it will reduce the overall perfromance.

Using Temporary Tables Effectively

If you do not have any option other than to use temporary tables, use them affectively. There are few steps to be taken.

Only include the necessary columns and rows rather than using all the columns and all the data which will not make sense of using temporary tables. Always filter your data into the temporary tables.
When creating temporary tables, do not use SELECT INTO statements, Instead of SELECT INTO statements, create the table using DDL statement and use INSERT INTO to populate the temporary table.

e.g :select a into #tblani from dbo.table_execplan --Dont use this one

e.g:

CREATE TABLE #tbl_ani1 (col1 nchar) INSERT #tbl_ani1 (col1) (select a from dbo.table_execplan)--try to use this one

After you finish the using your temporary table, delete them. This will free the tempdb resources. Temporary tables are deleted when connection is ended. but do not wait until such time.
When creating a temporary table do not create them with a transaction. If you create it with a transaction, it will lock some system tables (syscolumns, sysindexes, syscomments). This will prevent others from executing the same query.

linked server

2009-06-29T20:43:00.000+05:30

Linked server is used to execute command against OLEDB datasource on different server.

Advantages :

· Remote server access

· Distibuted query ,update,command and transaction on heterogeneous datasource across the enterprice.

· Ability to address diverse datasource similarity

Linked Server components :

Oledb provider and oledb datasource

Oledb provider-is a dll that manages and interact with specific

Linked server details

When a client appln execute a distributed query through a linked server ,sql server break down into command and send it to rowset and req to oledb. The row set exec and open the table from the provider.

Managing linked server Definition

To work in linked server ,register the connection formula and datasource information to sql server .After registration datasource ll always reffer to the logical name provided.

e.g
EXEC

sp_addlinkedserver @server='74.55.278.251',
@srvproduct='',
@provider='SQLNCLI',
@provstr = 'DRIVER={SQL server }; server=databasename;UID=username;PWD=password;'
@datasrc='74.55.278.251'

by using proc we can add and delete the linked server
sp_addlinkedserver – to add the linked server.
Sp_linkedservers –to see the information in the linked serer.
Sp_addlinkedserver and sp_linkedservers to see more information

The tables affected are
For server details:
select * from sys.servers

For linked server Login Details :

select * from sys.linked_logins

sp_dropserver – used to delete the added server and also we can remove the remote server.

By using sql server enterprise Manager

I am not explaining this.

Identifying a Data Source Using a Linked Server Name

After registered a linked server four part name that help for the transaction.

Part Name Desc

Linked_server_name Linked server referencing the the oleDB data source

Catalog Catalog in oledb datasource Containing object

Schema Schema in the catalog contain the object

Object_name Data object in the schema

How CLR Locates and binds assemblies

2009-06-29T08:33:00.001+05:30

.NET loads the assemblies in a structured manner.CLR is responsible to locating and binding assemblies.

Step 1: Check for the referred assembly upon the name and version.

Step 2: Check in previous referred assembly

Step 3: check in GAC

Step 4: Code base or probing

Here the information can over ride the pervious version. Here I am explaining what is happening in each step.

Step 1: Check referred assembly name and version.

· Check in the application config after the manifest check.

· Check for publishers policy (when the shared/public assembly has new version).this can be managed by

· Check in machine config(manages all .NET files in the machine)

Step 2:check in previous referred assembly

If CLR uses the same assembly it will take this only. why it is not first step means ,to examine the which version is required.

Step 3: Check in GAC (global assembly cache)

If the assembly is not found in the first two steps it should be a strong name, so it goes to GAC.

Step 4: code base or probing

This inform to CLR which version is required.

Code base: codebase is the tag in the application config .CLR checks the defined location only. if the assembly is not there probing has terminated.

Probing : if the no codebase tag is config.CLR starts probing

Subdirectories: search the application sub directories.CLR terminates probing as soon as the assembly is found.

if u have dought mail me anishmarokey@gmail.com

Portable executable(PE)

2009-06-28T20:29:00.000+05:30

Portable executable(PE) is a dll or exe file created after the compilation.

Compiling source code architecture for C# is as Shown in figure

When you write the code and compiles the code the compiler(in the second block) check the syntax and produce a managed module(PE)

Parts Of PE

PE has mainly four parts

PE Header : indicates the type of file (GUI or .dll) and it also contains time of the file created.Also contains the information of the native CPU code.
CLR Header: Contains the information of version of managed module(PE),some flags,metadata ,the size of the metadata,strong name etc.
Metadata: contains two tables,one contains types(eg:class used) and members defined in the source code and the second table contains members and types reffered by the source code)
Intermediate Source Code(IL) : Compiler produce the compiled source code.the CLR then compiles the IL to native CPU instructions.

If you want to see the PE data.intermediate language deassembler(ILDASM) helps you to open the PE.

Open the visual studio command prompt and type ildasm and the PE(.dll or exe)will open the IL DASM from the open you can locate the PE and see how your PE is.

But you cant able to open the win32 dlls because it doesnot contain the CLR header and it is not created in this manner.so you cannot able to open it

If you have any dought in this mail me :anishmarokey@gmail.com

Anish Varghese - My World of Microsoft Technologies

Web Platform Installer

To Hide a file in C#

How to Write a Macro in VS 2010

Import and Export Break Points in VS 2010

Track Changes in Visual Studio

How to get the deleted file in Windows

Square selection in Visual studio 2010

Enable javascript Debugging in IE

Unable to load DLL ‘FileTracker.dll’

operation could not be completed – Visual studio 2010

How to clear the temp folder in windows start up using C#

Twitter API in C#

Zip Extension

K-MUG Session on 19th Saturday at Technopark

How to install Chrome OS ?

Bing Driving Directions

Introducing Closure Tools

CLR via C#, Third Edition

MVC

Script Data in SQL SERVER 2008

separating multiple lines of data to insert with comma –SQL Server 2008

Coding Heroes - Present

Bernie Cosell

Visual Studio 2010 and .NET Framework 4 Beta 2

An anonymous type cannot have multiple properties with the same name

Entity Framework for MSSQL and MYSQL

ALTER ALL TABLE,Procedure and UDF SCHEMA IN A SINGLE QUERY

NDepend – Part 1

New MVPs Announced – October 2009

Microsoft Visual C# 2008 Compiler could not be created

C# New Features – Till Visual Studio 2008 SP1

Page Events – MasterPage + WebUserControl + Page + WebUserControl

ASP.NET Page Life Cycle

Windows Live Writer - For Better Blogging

WPF(Windows Presentation Foundation)

Const Vs Fields

How to copy code from Visual studio to Html page

Applied Microsoft NET_Framework_Programming by Jeffrey Richter

entity framework model

HTTP Error 500.19 - Internal Server Error iis

Dynamic LINQ

Linq to Sql Debug Visualizer

Assembly Binding Log Viewer (Fuslogvw.exe)

TimeZoneInfo vs TimeZone

Windows 8

Visual studio Background Images

Mutable vs Immutable

Web site vs Web Application

To get the microsecond in C#

To find server address using sql server 2005

Common Table Expression(CTE) and ROW_NUMBER()

Collections in C# 2 Part 1

Set single user mode in sql server 2oo5

Implict vs explict

Guidelines for Names(taken from MSDN)

Change schema on table and proc in SQL SERVER 2005

Visual Studio Short Cut Keys

ER Diagram in Sql server 2005

Joining two tables Using UNION

charindex Vs patindex

Implicitly Type local variable

collection Initializers in .Net 3.0

Type Safe in C#

Deploy Asp.Net application using "compilation debug="false"

CLR Profiler

Content delivery Network

Google Chrome OS is comming

sp_spaceused system procedure

Cryptographic Serivce Providers

C# allows Passing Parameters by reference

Command Line Tips

Windows XP Shortcut Keys

Difference between Primary key and unique key?

Union and UnionAll

Value type can have an implict Constructor?

Linq(Language integrated Query) Part 1

NEWSEQUENTIALID()

.Net 3.0

Properties in C#