Generate your database entities using T4 templates

Standard

Long back I wrote some post about code generation using T4 templates. This post is about generating database entities using T4 templates. This code is pretty straight forward, you are reading the app.config to get the connection string, connecting to db server using Sql Server read more →

CREATE DATABASE permission denied in database ‘master’ – SQL EXPRESS

Standard

Long back I wrote a post about Entity Framework Error – The underlying provider failed on Open. Yesterday some one told me, he is getting this error – CREATE DATABASE permission denied in database ‘master’, he is using an application pool with NETWORK SERVICE identity. read more →

How to execute a Stored Procedure with Entity Framework Code First

Standard

Recently I worked on a project, which I started as code first and then I forced to switch to Database first. This post is about executing procedures from EF code first.(This is an update version of this post Here is my class structure and procedures. read more →

Introduction to Code First development with Entity Framework

Standard

The Database First approach is interesting when the database already exists. You use Visual Studio and the Entity Framework Designer to generate the C# and VB.NET classes which reflect the existing database model. You may then change relations using the Designer (or the XML mapping read more →