Search results matching tag 'VisualStudio2010'

My first video for code refactoring in visual studio 2010

Jalpesh07 — Sat, 28 Jan 2012 21:07:59 GMT

I have been planning this since long but now Its happened. I have created a video for visual studio 2010 code refactoring features. I have made this video public. Following is a link for that.

http://www.youtube.com/watch?v=HvC63rE7tB4&feature=share

Here is the video..

Please see the video and let me know your feedback. I am not a trained professional in this but I have tried to create it. Hope fully I will master this technique in some time. Stay tuned for more. Till then Happy programming.

NuGet package with multiple projects

Jalpesh07 — Fri, 23 Sep 2011 19:55:47 GMT

Before some day one of my friend asked me to install NuGet in project another then startup project. At that time I don’t have any idea about it. So I did some R and D on web and found one easiest way to do it. So let’s first create a solution where we have more then one project in single solution. I have created a new solution and create three project in single solution as below.

MyApplication- Main web application project.
MyApplication.Business- This project contains all business logic classes of application
MyApplication.Data- This project contains all data access layers classes of application

Its looks like following.

Now I want to add EFCodeFirst NuGet package to MyApplication.Data project as I want to use entity framework code first for database operations. To add new package with in the project. you can select project and then click ‘Manage NuGet Packages’ like following.

Once you click it will show a dialog for NuGet Packages like following.

I have selected EFCodeFirst and Once I clicked ‘Install’ . It has added reference to MyApplication.Data Project like following.

That’s it. It’s very easy. Hope you like it..Stay tuned for more.. Till then happy programming and Namaste!!!.

Visual Studio 2010 feature post list

Jalpesh07 — Sat, 27 Aug 2011 21:03:33 GMT

Before some days one of my friend ask me about my visual Studio 2010 features post. So this post is about my Visual Studio 2010 posts. I have done lots of post about features of visual studio 2010 and Following is complete list of it.

Visual Studio 2010 Color Theme Editor- Customize look of visual studio

Jalpesh07 — Fri, 12 Aug 2011 19:59:58 GMT

We have all love Visual Studio 2010 and I am sure you all want to change color for menus, toolbars and title etc. Today I have found one of the most interesting Extension for Visual studio 2010 from which you can manage all this things. Don’t believe me I’m sure you won’t believe but this reality and You can change the look of your favorite visual studio look and feel. There is a new extension called “Visual Studio Color Theme Editor” from which you can do all this stuff. Here is the link for that.

http://visualstudiogallery.msdn.microsoft.com/20cd93a2-c435-4d00-a797-499f16402378

Once you download and install this link a Theme Menu will be added to Visual Studio like following.

There are 8 themes provided by the Default. You can choose any one of them. Lets choose Emerald theme for visual studio and It will look like following.

Isn’t that great?. Even you can also design your own theme also. Click on Theme->Customize colors and then It will popup a dialog like following. where you can will get lots of things for which you can customize the color.

Isn’t that Great. Hoped You liked it. Stay tuned for more..Till then happy programming..

Surround with feature in Visual Studio 2010

Jalpesh07 — Tue, 02 Aug 2011 09:09:28 GMT

Everyday I am discovering something new with Visual Studio 2010 and today Once again I have discovered a new feature called “Surround with” feature. This feature is quite useful when you have very big HTML element and You want to surround it some HTML or ASP.NET element i.e. Suppose there is one very big div there and you want to add update panel for Ajax . So let’s take a Simple Example over there. I am having a div which contain very big HTML in it. Like following.

<div>
    Very big HTML here.
</div>

Now let's put that div into update panel with Surround with feature. You can right click and click Surround With or You can directly have shortcut Ctrl+k, Ctrl +S like following.

Now once you click it It will popup three things. 1) ASP.NET 2) ASP.NET MVC 2 and 3) HTML. You can select element of any of that like following.

I am going select ASP.NET as we want to put Update panel over there. Once you click ASP.NET It will popup elements of asp.net. Here I have selected update panel as I want to put update panel covering this div like following.

Now once you click update panel it will put Update panel and div will be in content template of Update panel. Now our code will like following.

<asp:UpdatePanel runat="server">
    <ContentTemplate>
        <div>
            Very big HTML here.
        </div>
    </ContentTemplate>
</asp:UpdatePanel>

That's it. Isn't that cool?. Hope you like it. Stay tuned for more.. Till then Happy Programming..

"The statement terminated. The maximum recursion 100 has been exhausted before statement completion" with CTE in SQL server

pprajapati — Sun, 31 Jul 2011 10:20:00 GMT

Problem :
When i was working with stored procedures to get the hierarchical data in SQL Server 2005, I did one mistake. Let me explain the what was that mistake. I don't want to repeat the same.

I have also posted one post for the CTE and MAXRECURSION option.

I was using CTE (Common table expression ) to get the hierarchical data and forgot to put MAXRECURSION option in t-sql statement inside the stored procedure.

It was working very well when the hierarchical depth is less than 100, but it was creating issue when hierarchical depth grater than 100.

An Example.

IF ( Object_id('CTEMaxLevelTab') > 0 )
  DROP TABLE CTEMaxLevelTab

GO

CREATE TABLE CTEMaxLevelTab
  (
     ChildId   BIGINT IDENTITY(1, 1)
     ,ParentId BIGINT
  )

GO

-- Inserting demo records
INSERT INTO CTEMaxLevelTab
            (ParentId)
SELECT TOP 500
  NULL
FROM   sys.sysobjects a
       CROSS JOIN sys.sysobjects b

GO

UPDATE CTEMaxLevelTab
SET  ParentId = ChildId - 1

GO

Now write the below code and execute in your query analyzer and see the what's result with the script.

;WITH cteLevels
AS
(
SELECT
  ChildId   AS Child
  ,ParentId AS Parent
  ,1        AS [Level]
FROM   CTEMaxLevelTab 
WHERE CHILDID = 1


UNION ALL

SELECT
  ChildId      AS Child
  ,ParentId    AS Parent
  ,[Level] + 1 AS [Level]
FROM   CTEMaxLevelTab
       INNER JOIN cteLevels
         ON ( ParentId = Child ) 


)


SELECT
  *
FROM   cteLevels

This is the error occurred after 100 recursion reached.

Solution :
Now going to close the success and resolve the issue with Max-recursion option. Let's run the below revised script and see you in success.

;WITH cteLevels
AS
(
SELECT
  ChildId   AS Child
  ,ParentId AS Parent
  ,1        AS [Level]
FROM   CTEMaxLevelTab 
WHERE CHILDID = 1


UNION ALL

SELECT
  ChildId      AS Child
  ,ParentId    AS Parent
  ,[Level] + 1 AS [Level]
FROM   CTEMaxLevelTab
       INNER JOIN cteLevels
         ON ( ParentId = Child ) 


)


SELECT
  *
FROM   cteLevels
OPTION (MAXRECURSION 0);

Hope you always use this option to come out from this issue.

Handle Exception Carefully

pranayamr — Fri, 22 Jul 2011 18:07:00 GMT

Handle Exception carefully means I am not going to discuss some rocket science about exception handling but I am going to discuss not to shadow the exception in your program. Not going to discuss more I am starting my example

class Program
    {
        static void Main(string[] args)
        {
            try
            {
                Program p = new Program();
                p.MethodA();
            }
            catch (Exception ex)
            {
                Console.WriteLine(ex.Message);
                Console.WriteLine(ex.StackTrace);
            }
            Console.ReadLine();
        }

        public void MethodA()
        {
            try
            {
                MethodB();
            }
            catch (Exception ex)
            {
                throw ex;
            }
        }

        public void MethodB()
        {
            try
            {
                MethodC();
            }
            catch (Exception ex)
            {
                throw ex;
            }
        }

        public void MethodC()
        {
            int a = 10;
            int b = 0;
            int c = 0;
            try
            {
                c = a / b;
            }
            catch (Exception ex)
            {
                throw ex;
            }
        }
    }

When execute the program you will get the following output as result. Yes you can able to handle the exception thrown by the method and displayed on the console.

Output

But the actual thing is you hiding the stack trace and each time you throw the exception by writing throw ex you are creating new stack trace. So you are not able to get the actual path from where the exception get thrown. Now to understand the thing properly, write the program again and now replace throw ex by the throw

class Program
    {
        static void Main(string[] args)
        {
            try
            {
                Program p = new Program();
                p.MethodA();
            }
            catch (Exception ex)
            {
                Console.WriteLine(ex.Message);
                Console.WriteLine(ex.StackTrace);
            }
            Console.ReadLine();
        }

        public void MethodA()
        {
            try
            {
                MethodB();
            }
            catch
            {
                throw;
            }
        }

        public void MethodB()
        {
            try
            {
                MethodC();
            }
            catch
            {
                throw;
            }
        }

        public void MethodC()
        {
            int a = 10;
            int b = 0;
            int c = 0;
            try
            {
                c = a / b;
            }
            catch
            {
                throw;
            }
        }
    }

When execute the program get the following output

Output

Now as you see when you replace the line there is no new stacktrace get created and you get actual path from where exception get thrown.

Summary

So make use of the throw to get the actual path of the exception rather than using throw ex

Box Selection in Visual Studio 2010

Jalpesh07 — Fri, 22 Jul 2011 11:17:00 GMT

Every day I am discovering something new with Visual Studio 2010 and In this post I am again going to explain you new interesting feature of Visual Studio 2010. We all required to modify the code in bulk some time and there is a new features for Visual Studio 2010 which enables to made changes in multiple line at same time. Let’s take a simple example like following.

using System;

namespace Parallel
{
    class Program
    {
           private int a=10;
           private int b=10;
           private int c=10;

           static void Main(string[] args)
           {

           }    
    }
}

In above code I have three private variable a,b and c and now I want to make them protected. There is two way either I do manually one by one or I can do it with box selection and modify them together. It very easy to use this feature Press ALT+ SHIFT and draw box with help of mouse on the code which you need to modify like following.

Now I want to make it protected so I started writing protected and it will modify all the line at same time like following.

And now my code is like following.

using System;

namespace Parallel
{
    class Program
    {
           protected int a=10;
           protected int b=10;
           protected int c=10;

           static void Main(string[] args)
           {

           }    
    }
}

That's it. Hope you like it… Stay tuned for more…Till then Happy programming.

New Improved IntelliSense with Visual Studio 2010

Jalpesh07 — Sun, 17 Jul 2011 12:02:23 GMT

I have posted lot many things about Visual Studio 2010 features because its a great IDE(Integrated Development Environment).Today I am going to write about IntelliSense improvement in Visual Studio 2010. Today when I was working with Visual Studio 2008 for a old project(Nowadays I am working with Visual Studio 2010), I have found new improve IntelliSense feature in Visual Studio 2010.

Filtering:

Visual Studio 2010 IntelliSense is filtered better than Visual Studio 2008. I have created a sample application and I am writing Console.ReadLine that you can see in following image its filtering with read only.

In earlier version it was not possible.Hope you like it. Stay tuned for more.. Happy Programming..

Code refactoring with Visual Studio 2010 Part-4

Jalpesh07 — Wed, 29 Jun 2011 09:01:27 GMT

I have been writing few post with code refactoring features in Visual Studio 2010. This post also will be part of series and this post will be last of the series. In this post I am going explain two features 1) Encapsulate Field and 2) Extract Interface. Let’s explore both features in details.

Encapsulate Field:

This is a nice code refactoring feature provides by Visual Studio 2010. With help of this feature we can create properties from the existing private field of the class. Let’s take a simple example of Customer Class. In that I there are two private field called firstName and lastName. Below is the code for the class.

public class Customer
{
    private string firstName;
    private string lastName;
    public string Address { get; set; }
    public string City { get; set; }
    
}

Now lets encapsulate first field firstName with Encapsulate feature. So first select that field and goto refactor menu in Visual Studio 2010 and click on Encapsulate Field. Once you click that a dialog box will appear like following.

Now once you click OK a preview dialog box will open as we have selected preview reference changes. I think its a good options to check that option to preview code that is being changed by IDE itself. Dialog will look like following.

Once you click apply it create a new property called FirstName. Same way I have done for the lastName and now my customer class code look like following.

public class Customer
{
    private string firstName;

    public string FirstName
    {
        get { return firstName; }
        set { firstName = value; }
    }
    private string lastName;

    public string LastName
    {
        get { return lastName; }
        set { lastName = value; }
    }
    public string Address { get; set; }
    public string City { get; set; }
    
}

So you can see that its very easy to create properties with existing fields and you don’t have to change anything there in code it will change all the stuff itself.

Extract Interface:

When you are writing software prototype and You don’t know the future implementation of that then its a good practice to use interface there. I am going to explain here that How we can extract interface from the existing code without writing a single line of code with the help of code refactoring feature of Visual Studio 2010. For that I have create a Simple Repository class called CustomerRepository with three methods like following.

public class CustomerRespository
{
   public void Add()
   {
       // Some code to add customer
   }
    
   public void Update()
   {
       //some code to update customer
   }

   public void Delete()
   {
       //some code delete customer
   }
}

In above class there are three method Add,Update and Delete where we are going to implement some code for each one. Now I want to create a interface which I can use for my other entities in project. So let’s create a interface from the above class with the help of Visual Studio 2010. So first select class and goto refactor menu and click Extract Interface. It will open up dialog box like following.

Here I have selected all the method for interface and Once I click OK then it will create a new file called ICustomerRespository where it has created a interface. Just like following.

Here is a code for that interface.

using System;
namespace CodeRefractoring
{
    interface ICustomerRespository
    {
        void Add();
        void Delete();
        void Update();
    }
}

Now let's see the code for the our class. It will also changed like following to implement the interface.

public class CustomerRespository : ICustomerRespository
{
   public void Add()
   {
       // Some code to add customer
   }
    
   public void Update()
   {
       //some code to update customer
   }

   public void Delete()
   {
       //some code delete customer
   }
}

Isn't that great we have created a interface and implemented it without writing a single line of code. Hope you liked it. Stay tuned for more.. Till that Happy Programming.

Search results matching tag 'VisualStudio2010'

My first video for code refactoring in visual studio 2010

NuGet package with multiple projects

Visual Studio 2010 feature post list

Visual Studio 2010 Color Theme Editor- Customize look of visual studio

Visual Studio 2010 styles

Surround with feature in Visual Studio 2010

SQL Management Studio in Visual Studio 2010

Box Selection in Visual Studio 2010

Code refactoring with Visual Studio 2010 Part-1

Code refactoring with Visual Studio 2010 Part-2

Code refactoring with Visual Studio 2010 Part-3

Code refactoring with Visual Studio 2010 Part-4

Visual Studio 2010 and UML(Unified Modeling Language) Part-I

Task list window in Visual Studio 2010

HTML5 Intellisense in Visual Studio 2010/2008

View Call Hierarchy window in Visual Studio 2010

Pin features while debugging in Visual Studio 2010

Historical Debugging (Intellitrace) on Visual Studio 2010 Ultimate Part-1

Historical Debugging (Intellitrace) on Visual Studio 2010 Ultimate Part-2

Variable Reference Code Highlighting and Hide selection features of Visual Studio 2010

HTML and Java Script code snippets in Visual Studio 2010

Visual Studio 2010 New Feature-Generate From usage

Visual Studio 2010-Automatically Adjust Visual Experience

Visual Studio 2010- New Features Selected Text

New publish setting dialog in visual studio 2010 beta 2

Rename feature in Visual Web Developer 2010/Visual Studio 2010

Visual Studio 2010 Color Theme Editor- Customize look of visual studio

Surround with feature in Visual Studio 2010

"The statement terminated. The maximum recursion 100 has been exhausted before statement completion" with CTE in SQL server

Handle Exception Carefully

Box Selection in Visual Studio 2010

New Improved IntelliSense with Visual Studio 2010

Filtering:

Code refactoring with Visual Studio 2010 Part-4

Encapsulate Field:

Extract Interface: