Entity Framework Step By Step 1

-

Thought of writing a series of posts to explain entity framework Step by step so that anyone can easily understand the concepts behind that. This will be the starting point of that.

What is Entity Framework?

“Entity Framework (EF) is an object-relational mapper that enables .NET developers to work with relational data using domain-specific objects. It eliminates the need for most of the data-access code that developers usually need to write.”

As the first step to begin entity frame work the first thing we have to do is to identify which workflow we should adopt. Entity Framework provides 4 different workflows we can adopt for our development based on our requirement.

 ThinkingSmiley Which Workflow We should Adopt?

 

image

When deciding which workflow we should select there are four question we should answer.

1. Are you targeting new Database , which is empty & tables need to be created?

2. Are you targeting existing Database where tables are already populated?

3. Would you prefer creating the model using boxes & lines in the designer?

4. Would you prefer creating the model by writing code?

Based on your answers, looking at the image above you can decide which development workflow of entity framework suits your requirement best. Lets see what are the features available in these four workflows in brief.

Model First

1. We Can create the model using the boxes & lines available in the designer

2. Then we can generate the Database from the model

3. Classes that we interact within the code will be auto generated using the model we designed using the designer.

 

Database First

1. You can do reverse engineering & create he boxes & lines in the designer using a existing data base

2. Then classes that we interact within the code will be auto generated using the model we designed using the designer.

 

Code First (New Database)

1. Create the model by defining the domain classes in the code.

2. Database is created from the model.

3. If you make any changes to the model , can use code first migrations to evolve the database.

 

Code First (Existing Database)

1. Create the model by defining the domain classes in the code based on the existing database.

2. There are some tools available for reverse engineering.

Now You can decide which development workflow to be adopted.  smiley_with_thumbs_up

Lets discuss these four workflows in detail in the following posts.

Comments

Post a Comment

Popular posts from this blog

Responsive Web Design

-
Image
  What it is A web application developed based on the responsive web design concept will adopt the layout of the application based on the screen size and orientation. As the user switches from their laptop to iPad, the website should automatically switch to accommodate for resolution, image size and scripting abilities. In other words, the website should have the technology to automatically respond to the user’s preferences. This would eliminate the need for a different design and development phase for each new gadget on the market. When designing a web in responsive manner same HTML content will be maintained, but it will be viewed in different layouts when user switches among different browser sizes. In that way website can server the users by changing the layout of the content so user can view it in more user friendly manner, without too many scrolling. How the layout changes will be discussed under topic Design patterns   Pros Increasing your reach to tablet and mobile au
Read more

Affine Cipher in C#

-
Image
  The affine cipher is a type of monoalphabetic substitution cipher , wherein each letter in an alphabet is mapped to its numeric equivalent, encrypted using a simple mathematical function, and converted back to a letter. The formula used means that each letter encrypts to one other letter, and back again, meaning the cipher is essentially a standard substitution cipher with a rule governing which letter goes to which. As such, it has the weaknesses of all substitution ciphers. Each letter is enciphered with the function , where is the magnitude of the shift. For more information on affine cipher visit here Following code is written in c# which has the affine cipher algorithm   public static string AffineEncrypt( string plainText, int a, int b) {      string cipherText = "" ;        // Put Plain Text (all capitals) into Character Array      char [] chars = plainText.ToUpper().ToCharArray();        // Compute e(x) = (ax + b)(mod m) for every character
Read more

Contract First Development in WCF 4.5

-
Image
WCF 4.5 supports contract first development. Means it allows to create all the data contract classes can be auto generated using the WSDL. one of the advantage in using the is if we start developing the service from the data contracts & then generating the WSDL we might end up in creating from data contracts with .net specific data types. But when using contract first development as WSDL is xml based only xml based data types are allowed to create so no .net specific contract will be created. This feature can be very useful when WSDL file is produced through design phase either by a solution architect or through mutual parties that agree on a contract prior to development and build phases.  When this is the case, either the contract can be created for a future service implementation or contracts can be created so that developers can begin coding for the client side of an interface prior to the endpoint being available. The contract-first tool is integrated into Visual Studio 2012
Read more