Tuesday, October 29, 2013

How to create Web API using code first Entity Framework 5.0

How to create Web API using code first Entity Framework 5.0

1) Create ASP.NET MVC 4 application

2) Select Web API Project template

3) Create a Customer class

         public class Customer
        public int custId { get; set; }
        public String Name { get; set; }
        public DateTime DOJ { get; set; }
        public String szEmailID { get; set; }
        public string Mobile { get; set; }

4) Create CustomerModel class which is Derived from DBContext

 public class CustomerModel:DbContext
        public CustomerModel() : base("CustDB") { }

        protected override void OnModelCreating(DbModelBuilder mb)
           // mb.Entity<Customer>().ToTable("Customers");

        public DbSet<Customer> customers { get; set; }

   CustDB is a Connection String Specified in Web.config
 <add name="CustDB"

5) Build the Project

6) Create a Controller Class Select "API controller with read/write operations using Entity Frame "
      Name it as "CustomerController"
      In this 
        select DataContext as CustomerModel
                  Model Class as Customer

7)  That;s it

8) Just run the Web API class in Browser


U will get Empty JSON/XML data.

How to Insert,UPDATE,DELETE on Web API 

pls see below articles