Invalid Object Name with Entity framework -EFCodeFirstCTP5

Recently I was working on one sample application with EFCodeFirst with the existing database.After doing all the coding I have found a error “Invalid object name 'dbo.Customers'.”. Following was my code for data context.

using System;
using System.Collections.Generic;
using System.Data.Entity;
using System.Linq;
using System.Web;

namespace CodeSimplified.Models
{
  public class MyDataContext:DbContext
  {
      public DbSet<Customer> Customer { get; set; }

      protected override void OnModelCreating(System.Data.Entity.ModelConfiguration.ModelBuilder modelBuilder)
      {
     
      }
  }
}

And following is code for my entity model class.

public class Customer
{
  public int CustomerId { get; set; }
  public string FirstName { get; set; }
  public string LastName { get; set; }
  public string Address { get; set; }
  public string City { get; set; }
}

Once I run the application I was getting following error.



As you can see from my code that it should be dbo.customer name. So after digging into the issue I have found that I need to remove the plural table name. Here is a forum that is saying the same.

http://social.msdn.microsoft.com/Forums/en-ie/adonetefx/thread/719f3e4d-073b-49fe-9968-945acde27bb7.

Now there are two ways of resolving this issue.
1) Either explicitly map entity class with table attribute like I have changed my code like following.

[Table("Customer",SchemaName="dbo")]
public class Customer
{
  public int CustomerId { get; set; }
  public string FirstName { get; set; }
  public string LastName { get; set; }
  public string Address { get; set; }
  public string City { get; set; }
}

Another one is you need to remove default plural table name via overriding the onModelCreating event like following.

using System;
using System.Collections.Generic;
using System.Data.Entity;
using System.Linq;
using System.Web;
using System.Data.Entity.ModelConfiguration.Conventions.Edm.Db;

namespace CodeSimplified.Models
{
  public class MyDataContext:DbContext
  {
      public DbSet<Customer> Customer { get; set; }

      protected override void OnModelCreating(System.Data.Entity.ModelConfiguration.ModelBuilder modelBuilder)
      {
          modelBuilder.Conventions.Remove<PluralizingTableNameConvention>();
      }
  }
}

That’s it now error is gone. My code is work perfectly!!. Hope this will help you.Stay tuned for more..Till that happy programming.

Continue Reading

Wohooooo!!! I got Microsoft MVP award again for Visual C#

Yesterday I got great news from Microsoft. I have been awarded as Microsoft MVP again for year 2011-2012. Yesterday I got following email.



Dear Jalpesh Vadgama,

Congratulations! We are pleased to present you with the 2011 Microsoft® MVP Award! This award is given to exceptional technical community leaders who actively share their high quality, real world expertise with others. We appreciate your outstanding contributions in Visual C# technical communities during the past year.

It is really one of the proudest moment of my professional life. When you get this kind of appreciation its feel great.

On this occasion I would like to thank my Friends,Employer,co-workers, Community friends and readers for providing support for me. I would also like to thank my MVP lead Abhishek Kant for guiding me throughout year. Last but not least my family members who are been there for me for my every ups and down. My father and mother who is inspiration of mine. My lovely brother Vishal who encourage me to do all this and My Lovely wife Reena who is supporting me for this in every possible way and my little champ Teerth from whom I am getting energy to do this.

Once again Thanks Microsoft for this.

Continue Reading

Code refactoring with Visual Studio 2010 Part-4

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.

Continue Reading

Code refactoring with Visual Studio 2010-Part 3

I have been writing few post about Code refactoring features of visual studio 2010 and This blog post is also one of them. In this post I am going to show you reorder parameters features in visual studio 2010. As a developer you might need to reorder parameter of a method or procedure in code for better readability of the the code and if you do this task manually then it is tedious job to do. But Visual Studio Reorder Parameter code refactoring feature can do this stuff within a minute. So let’s see how its works. For this I have created a simple console application which I have used earlier posts . Following is a code for that.

using System;

namespace CodeRefractoring
{
  class Program
  {
      static void Main(string[] args)
      {
          string firstName = "Jalpesh";
          string lastName = "Vadgama";

          PrintMyName(firstName, lastName);
      }

      private static void PrintMyName(string firstName, string lastName)
      {
          Console.WriteLine(string.Format("FirstName:{0}", firstName));
          Console.WriteLine(string.Format("LastName:{0}", lastName));
          Console.ReadLine();
      }
  }
}

Above code is very simple. It just print a firstname and lastname via PrintMyName method. Now I want to reorder the firstname and lastname parameter of PrintMyName. So for that first I have to select method and then click Refactor Menu-> Reorder parameters like following.



Once you click a dialog box appears like following where it will give options to move parameter with arrow navigation like following.



Now I am moving lastname parameter as first parameter like following.



Once you click OK it will show a preview option where I can see the effects of changes like following.



Once I clicked Apply my code will be changed like following.

using System;

namespace CodeRefractoring
{
  class Program
  {
      static void Main(string[] args)
      {
          string firstName = "Jalpesh";
          string lastName = "Vadgama";

          PrintMyName(lastName, firstName);
      }

      private static void PrintMyName(string lastName, string firstName)
      {
          Console.WriteLine(string.Format("FirstName:{0}", firstName));
          Console.WriteLine(string.Format("LastName:{0}", lastName));
          Console.ReadLine();
      }
  }
}

As you can see its very easy to use this feature. Hoped you liked it.. Stay tuned for more.. Till that happy programming.

Continue Reading

Code refactoring with Visual Studio 2010 Part-2

In previous post I have written about Extract Method Code refactoring option. In this post I am going to some other code refactoring features of Visual Studio 2010. Renaming variables and methods is one of the most difficult task for a developer. Normally we do like this. First we will rename method or variable and then we will find all the references then do remaining over that stuff. This will be become difficult if your variable or method are referenced at so many files and so many place. But once you use refactor menu rename it will be bit Easy. I am going to use same code which I have created in my previous post. I am just once again putting that code here for your reference.

using System;

namespace CodeRefractoring
{
  class Program
  {
      static void Main(string[] args)
      {
          string firstName = "Jalpesh";
          string lastName = "Vadgama";

          Print(firstName, lastName);
      }

      private static void Print(string firstName, string lastName)
      {
          Console.WriteLine(string.Format("FirstName:{0}", firstName));
          Console.WriteLine(string.Format("LastName:{0}", lastName));
          Console.ReadLine();
      }
  }
}

Now I want to rename print method in this code. To rename the method you can select method name and then select Refactor-> Rename . Once I selected Print method and then click on rename a dialog box will appear like following.



Now I am renaming this Print method to PrintMyName like following.



Now once you click OK a dialog will appear with preview of code like following. It will show preview of code.



Now once you click apply. You code will be changed like following.

using System;

namespace CodeRefractoring
{
  class Program
  {
      static void Main(string[] args)
      {
          string firstName = "Jalpesh";
          string lastName = "Vadgama";

          PrintMyName(firstName, lastName);
      }

      private static void PrintMyName(string firstName, string lastName)
      {
          Console.WriteLine(string.Format("FirstName:{0}", firstName));
          Console.WriteLine(string.Format("LastName:{0}", lastName));
          Console.ReadLine();
      }
  }
}

So that’s it. This will work in multiple files also. Hope you liked it.. Stay tuned for more.. Till that Happy Programming.

Continue Reading

My blog post appearing on Channel9.msdn.com

Recently I was searching something and I found that one of the post about New Features of the SQL Server Denali was being discussed on Channel9 on MSDN. It’s a great pleasure and honour to have this kind of appreciation. I would like to thanks again Microsoft for giving opportunity and serve community. I would also like to thanks my readers who are giving me all the support and love.

Once again I am appealing good developers to start blogging. I have seen many great developers are who are doing great stuff but not blogging. I would like to say please please do the blogging and share your stuff with community and you will also get this kind of great appreciation.

Here is the link where they discussed that video.

https://channel9.msdn.com/Shows/This+Week+On+Channel+9/TWC9-Skype-HTML-5-Canvas-Python-tools--more

Following is video where Dan and Clint from Microsoft discussed my blog post on channel 9.



Here are the stuff they have discussed during the video.

• [00:30] Microsoft PressPass - Microsoft to acquire Skype
• [01:12] Skype - Skype already has developer APIs you may be interested in
• [01:55] Mark Heath - Skype Voice Changer app shows how to use the Skype4COM library 
• [03:32] Robert Green kicks off the Visual Studio Toolbox show, covering the Productivity Power Pack
• [04:49] Pytools - A free, open source Python IDE with syntax colorization, IntelliSense, interactive mode, and more
• [06:08] Dan Wahlin - Getting started with the HTML 5 Canvas tag
• [07:39] Todd Brix - Updates and clarifications to the Windows Phone marketplace policies
• [09:35] Scott Guthrie - Walkthrough of using the HTML 5 improvements in the ASP.NET MVC3 Tools Update 
• [10:33] Azure Team - Windows Azure Toolkit for iOS provides a client library to access Azure in Objective C
• [11:29] Jalpesh Vadgama - New IDE features in SQL Server "Denali" Management Studio -
• [13:29] CodeProject - Respond to Windows Power Management events

Once again thank you for great appreciation. Stay tuned for more.. Happy programming.

Continue Reading

Code refactoring with Visual Studio 2010 Part-1

Visual studio 2010 is a Great IDE(Integrated Development Environment) and we all are using it in day by day for our coding purpose. There are many great features provided by Visual Studio 2010 and Today I am going to show one of great feature called for code refactoring. This feature is one of the most unappreciated features of Visual Studio 2010 as lots of people still not using that and doing stuff manfully. So to explain feature let’s create a simple console application which will print first name and last name like following.



And following is code for that.

using System;

namespace CodeRefractoring
{
class Program
{
  static void Main(string[] args)
  {
      string firstName = "Jalpesh";
      string lastName = "Vadgama";

      Console.WriteLine(string.Format("FirstName:{0}",firstName));
      Console.WriteLine(string.Format("LastName:{0}", lastName));
      Console.ReadLine();
  }
}
}

So as you can see this is a very basic console application and let’s run it to see output.

So now lets explore our first feature called extract method in visual studio you can also do that via refractor menu like following. Just select the code for which you want to extract method and then click refractor menu and then click extract method. Now I am selecting three lines of code and clicking on refactor –> Extract Method just like following.



Once you click menu a dialog box will appear like following.



As you can I have highlighted two thing first is Method Name where I put Print as Method Name and another one Preview method signature where its smart enough to extract parameter also as We have just selected three lines with console.writeline. One you click ok it will extract the method and you code will be like this.

using System;

namespace CodeRefractoring
{
class Program
{
  static void Main(string[] args)
  {
      string firstName = "Jalpesh";
      string lastName = "Vadgama";

      Print(firstName, lastName);
  }

  private static void Print(string firstName, string lastName)
  {
      Console.WriteLine(string.Format("FirstName:{0}", firstName));
      Console.WriteLine(string.Format("LastName:{0}", lastName));
      Console.ReadLine();
  }
}
}

So as you can see in above code its has created a static method called Print and also passed parameter for as firstname and lastname. Isn’t that great!!!. It has also created static print method as I am calling it from static void main. Hope you liked it.. Stay tuned for more..Till that Happy programming.

Continue Reading