Different way of mapping with EFCodeFirst

Recently I have been working Entity Framework Code First 6.0 and it’s awesome. I am in love with it. It has got great fluent API and we can do anything with that. It’s also promotes Convention over configuration which I love so far.

I have seen people are more confused about how we can map table to class via Entity framework via code first. So this post is going to be in same series. In this post I’m going to write about different ways to mapping table to class. I have already written two post about in details.

Entity Framework code first and Inheritance–Table per hierarchy
Entity framework code first and inheritance- Table Per Type

In this blog post I will give you tips and tricks to map class(type) with database table.

Continue Reading

HashSet in C#

In this blog post we are going to learn about HashSet collection in C#. It is a cool collection available from C# 3.5. Like any other collection it can be used for representing a set of value. It is an optimized set collection. It helps eliminating duplicate string or elements in collection. Whenever an Item is added in collection it will check whether this items are already there in collection If not then only it will add items.

Let’s take an example for the same.

using System;
using System.Collections.Generic;

namespace CSharpHashSet
{
    class Program
    {
        static void Main(string[] args)
        { 
            HashSet<string> nameHashSet=
                new HashSet<string>
                {
                    "Jalpesh", "Vishal", "Tushar", "Jalpesh"
                };
            foreach (var item in nameHashSet)
            {
                Console.WriteLine(item);
            }
            Console.ReadKey();
        }
    }
}

Now if you see the code carefully I have created HashSet of name(string type) with duplicate name like “Jalpesh” and then enumerate that collection with for loop and print items of collection with Console.WriteLine.

Continue Reading

StructureMap–Getting Started

In this post we are going to learn about How we can do dependency injection with StructureMap. Here we are going to take a sample application of shopping cart. This shopping cart can process two type of orders 1. Sales order 2. Purchase Order. We want an abstraction for this. So first we are going to create an interface IOrder which will be implemented by both Purchase Order and Sales Order classes.

Following is a code for that.

public interface IOrder
{
    void Process();
}

And following is a implementation of SalesOrder class.

public class SalesOrder : IOrder
{
    public void Process()
    {
        Console.WriteLine("Sales Order Processed");
    }
}

Same way following is a implementation of PurchaseOrder class.

public class PurchaseOrder : IOrder
{
    public void Process()
    {
        Console.WriteLine("Purchase Order Processed");
    }
}

And following is a code for Shopping Cart.

public class ShoppingCart
{
    private readonly IOrder _order;
    public ShoppingCart(IOrder order)
    {
        _order = order;
    }

    public void CheckOut()
    { 
        _order.Process();
    }
}

Continue Reading

Entity Framework Code First migrations

In this blog post we are going to learn about entity code first migrations. Entity Framework code first approach will allow you to define model classes as per the domain requirements via POCOs. Hence you have complete control over classes are written. But as application grows and there are some new features to be added and  your classes will change. Entity Framework Code Migrations allows you to handle this migrations.

As we all now that Entity Framework Code First approach allows you to create database based on your classes created. It’s provide you three types of initializers.

CreateDatabaseIfNotExist: This is the default initializer which will create classes if database not exists.

DropCreateDatabasesWhenModelChanges: This initializer is only good when you don’t concern about your database records. If there is any change in class then it will match database will classes and if there is any difference then it will drop and create a new database.

DropCreateDatabaseAlways: This initializer will always create new database whether database exist or not. If database exist then it will drop that database and create it again.

Continue Reading

Visual Studio 2013, Team Explorer and BitBucket

With Visual Studio 2013, Microsoft started supporting Git directly with Team Explorer  and I have written a blog post how we can use git with team explorer and github called Visual Studio 2013, Team Explorer and GitHub. This post gained lots of popularity and also get lots of email about writing a blog post for using Git With BitBucket.org which is similar kind of source code hosting service like GitHub.com. So this post is all about it.

In this post I’m going to use a sample console application where we will put some code and then publish it to BitBucket Git Repository.  In this post I’m going to slightly take different approach then previous post but still you can do same way also previous post also.

In this post first we are going to create repository in BitBucket and then clone it on local. So here people will also get to know how we can create and clone a repository in local.

How to create repository in BitBucket:

If you don’t have account in BitBucket.Org then you need to create a account in BitBucket. You can create account from the following link.

Continue Reading

How to convert PSD into image file in c# with Magick.NET

Recently in one of project we had a requirement of converting a Adobe Photoshop file (PSD) into image file(.png) file. After digging while on internet I have found a great library which has so many features in can easily convert PSD files into any time of image file.

The Library is Magick.NET. It’s a open source project you can find more information about it from the following codeplex link.
https://magick.codeplex.com/

There are lots of example available for image conversion and other image editing functions. You can find that about that on documentation.
https://magick.codeplex.com/wikipage?title=Convert%20image

There are lots of NuGet package are available also. Following is a one of them.

Continue Reading

How to change a profile picture in Visual Studio 2013

With Visual Studio 2013, Microsoft has provided synchronized settings in visual studio 2013 with live account. So all you need to do is to login into your live account and then it will automatically sync the settings of Visual Studio 2013 in different machine. Recently one of the reader of blog has asked me question How I can change the Profile Pic on Visual Studio. So I thought it will be good Idea to write a blog post about it.

Here’s how you can change profile picture of Visual Studio live/outlook account. One you done with sign in with visual studio it will load default image with your firstname first character and last name character like below.



Now to change the account picture or profile picture click on name load a popup like following.

Continue Reading

Scope to this feature in Solution Explorer- Visual Studio

Visual Studio is one of my favourite IDE. I love more and more whenever I’m using it. Recently I have found a very good feature called “Scope to this” so I thought it will be a good idea to write a blog post about it.

This feature comes very handy when you have large solution and you want to work /Concentrate on the only portion of a solution. In solution you can select particular project/folder/file and right click and click on “Scope to this” Menu. It will scope your solution explorer to that particular item.

Continue Reading

Entity Framework code first and Inheritance–Table per hierarchy

Before some day I have posted a blog about Entity Framework code first and Inheritance – Table per type and this post in next in series with that.

In previous post we have learned about how entity framework code first handles inheritance and in this part we are going to extend this and modify some of code of the code of data context to see how its creates a “Table per Hierarchy”.

We’re going to use same code as previous post just going to change EDataContext code like below.

public class EDataContext : DbContext
{
    public EDataContext() : base("MyConnectionString") 
    { 
    }
    public IDbSet<Customer> Customers { get; set; }
    public IDbSet<Employee> Employees { get; set; }
    public IDbSet<Person> Persons { get; set; }
}

If you see this code carefully and compare is with previous post. The only difference is persons property. That will force Entity Framework to create a single table for inheritance hierarchy. Now we are going to run this application again and see how it creates table. It will create only one table like this.

Continue Reading

Entity framework code first and inheritance- Table Per Type

Also see part-2 of this blog post- Entity Framework code first and Inheritance–Table per hierarchy

Recently I am using Entity Framework a lot. So I tried some of advance scenario and this post related to it only. In this post we will learn how entity framework handles inheritance.

In object oriented world, We all use Inheritance for reusability. We create some base classes and inherit those in child classes to facilitate code reuse and we don’t have to write again and again. In this post we will also have same kind of methodology. We are going to create a “Person” class and inherit this in to Employee and Customer class and we are going to see how entity framework code first handles this kind of inheritance by default. I’m going to use entity framework version 6.0 and Visual Studio 2013.

So what we are waiting for. Let’s get started. So create a console application from file menu new project.



Once you are done with creating a application. It’s time to add entity framework via nuget package.

Continue Reading

Visual Studio 14 CTP virtual machine on Azure

Recently Microsoft has release a CTP version of Visual Studio 14 with ASP.NET VNext application. So I thought I will download and try it. But due to bad internet connection it was not downloading properly. Then I cam across following post about Visual Studio 14 CTP Virtual Machine on Azure.

http://blogs.msdn.com/b/visualstudioalm/archive/2014/06/04/visual-studio-14-ctp-now-available-in-the-virtual-machine-azure-gallery.aspx

So I thought it’s a good idea to spin a virtual machine instead of downloading and installing that which would cost me a day. While on Azure I can set that virtual machine in minutes.

So Following are steps for creating a virtual machine in Azure.

How to Create a Virtual Machine on Microsoft Azure with Visual Studio 14 CTP:

1) Login into your Microsoft Azure Account

2) From dashboard goto virtual machine and select Create Virtual Machine.

Continue Reading

One ASP.NET in Visual studio 2013

This post is part of Visual Studio 2013 features series.

Since first release of ASP.NETMVC 2009, There are lots of type of projects are available for ASP.NET and It’s always been confusion to find all the projects under one hood. So now developer has not to worry about whether I should use Web Forms or ASP.NET MVC and If I need some functionalities of ASP.NET MVC in web forms or anything then how it will work? How we should combine all those different project types?

Now that fuss for developer is over. With Visual Studio 2013 Microsoft has vision called One ASP.NET so when you create a web project there will be a single project in Web Category only.

Continue Reading

Video Review: Restful Services with ASP.NET Web API by Packt Publishing

If you enjoy seeing videos to learn thing this is the opportunity, Now  Packt publishing is also started providing video courses and tutorial. I’m lucky enough to get an opportunity to review this video and thanks again Sagar Malage and Packt publishing marketing team to providing me opportunity to review this video.

About Video Course:

Course Name : Restful services  with ASP.NET Web API by Packt Publishing.
Total Duration: 2 hours and 4 minutes.
Release Date: Wednesday February 26,2014.
Author: Fanie Reynders

Continue Reading

Visual Studio update 2 is here download now!!

10 days ago Microsoft has release Visual Studio 2013 update 2.  This update includes bug fixes as well as new features and customer feedbacks. Following are some new capabilities included in this updates.

Universal Apps:

With this release you now build Universal Apps that can run on Windows 8.1 and Windows phone 8.1 while sharing code and assets through shared projects.

There are two types of app available 1) Blank app as universal Project and Hub application for that. So now if you already developed the windows phone 8.1 app and want to create same app with windows 8.1 then you can do that very easily Add windows 8.1 and same way you can add windows phone 8.1 if you have already developed windows 8.1 via Add windows phone 8.1.

Continue Reading

.NET Framework 4.5.2 released by Microsoft

Microsoft has released .NET Framework 4.5.2 before some time see the announcement from It’s .NET Framework team blog. It’s a compatible, in-place update for Microsoft.NET Framework 4.0,4.5 and 4.5.1.  This framework also run side by side with earlier version of .NET framework.

From where I can download .NET Framework 4.5.2?

Following are link from where you can download .NET framework 4.5.2.

.NET framework web installer- Internet required at the time installation. It will download required file runtime.A Boots trapper that pulls in components based on the target OS/platform specs on which the .NET Framework is being deployed.

Continue Reading

One Million page views for my blog–dotnetjalps.com

I have putted blogger statistics from its announcement(July 2010).  Today my statistics are showing that I have completed One million page views from July 2010. I feel honoured I have never assumed my blog will come this way. Earlier I had started this blog just for fun and to reserve my name with blogger subdomain. I was not aware that what is blogging and why we should do it. After some time almost after one year I realized the power of blog then and this 9th year I am continuously doing that. This is a great achievement and I feel honoured and awesome.

Continue Reading

Fun with Angela Smith library by James Chambers for C#

AngelaSmith is an awesome library created by James Chambers. This library is used to generate realistic test data. You can find more information about it from the following link.

https://github.com/MisterJames/AngelaSmith

As per documentation on the github, it is.

AngelaSmith is a library you can use to generate realistic test data. It is composed of several property fillers that can populate commonly named properties through reflection using an internal database of values or randomly created data. You can override any of the fillers, give AngelaSmith hints on how to fill them, or easily extend the property fillers using extension methods or MEF.

It’s an awesome realistic data generator library. You can generate object data as well list also. She can fill anything that you throw it to her.You can use it’s static methods to create objects for testing, design time data or seeding a database.

Continue Reading

Learning resources for ASP.NET MVC

I am getting lots of question regarding where to learn ASP.NET MVC. So I thought it will beneficial to write a blog post so that everyone get advantages of it. Today there are multiple resources available to learn ASP.NET MVC here I have listed some of the my favorite resources to learn ASP.NET MVC.

Videos:

Videos are great way to learn any technology and there are many video resources are available.

1) Pluralsight free videos on www.asp.net/mvc:

On the official asp.net mvc site Pluralsight has provided 8 free videos It it a great resource for any to get started with ASP.NET MVC. Some videos are there for ASP.NET MVC 3.0 but still it is worth learning it.

Continue Reading

Important Milestone achieved- 650th blog post

I am not super crazy about achieving mile stones but I just notice that I have completed 649 posts on blog. So I thought it will be good idea to write about few mile stones.

1. On April 2014, my blog completed 8 years. The first post I have ever written was at April 26,2006.
2. Today I have completed another important milestone this is 650th post I am writing and still going on. My passion for blogging never dropped I will still continue to write blog on my blog.

On this occasion, I would first like to thank my family who scarifies their time when I am writing blogs without their encouragement It would never possible to write blog and maintained it for almost 8 years.
I would also like to thank my readers. Without their love It would not have been possible to achieve this. Hopefully I will continue to write blog that will help you learn technology in some way.

Thanks again everybody for making this journey possible!!

Continue Reading

What’s new in ASP.NET MVC 5 Part-1 : Attribute Routing

ASP.NET MVC is a new buzz word in Microsoft.NET stack most of people have started learning into it. So recently before some time Microsoft has released a Major new version of ASP.NET MVC with ASP.NET MVC 5.x. There are lots of new features given with ASP.NET MVC 5.x versions and I’m going to write a few series of blog post to explain all the features in details. So stay tuned with that!!

In this blog post I’m going to explain attribute routing in ASP.NET MVC 5.

Routing in ASP.NET MVC:

From the first version of ASP.NET MVC It’s provides a routing out of box. You don’t need to do much about it. Routing is how ASP.NET MVC matches URL in browsers to action. Based on URL a particular action is called on particular controller and result will be provided as view.

Continue Reading