Introduction

In this article we will see how to create the ASP. NET Web API With an Entity Framework (EF) Database.

By using the EF database, developers can work easily with an object model that can be mapped to various storage schemas, and can be implemented within a different database.

Now the procedure for creating the ASP. NET Web API with an EF Database.

Step 1

First we create the Web API application:

Step 2

We create the SDF Database in the App_Data folder.

Step 3

We create the DataModel in the Model folder using the following procedure:

The Entity Detail Model Wizard is open then:

Now open a Tool box. From the Tool box we drag the Entity in to the surface. And name it as DetailModel. We add the field name into this entity.

2.jpg

ef11.jpg

Step 4

We generate the database script using the following procedure:

Step 5

Now we execute the database.

First we install the SQL CE Toolbox. We we install it. Then it will be visible in the View/Other Windows/SQL Server Compact Toolbox.

Now we open it.

The copied code is this:

  1. -- --------------------------------------------------
  2. -- Entity Designer DDL Script for SQL Server Compact Edition
  3. -- --------------------------------------------------
  4. -- Date Created: 06/10/2013 13:23:21
  5. -- Generated from EDMX file: D:\mudita\projects\MvcApplication9\MvcApplication9\Models\TodoModel.edmx
  6. -- --------------------------------------------------
  8. -- --------------------------------------------------
  9. -- Dropping existing FOREIGN KEY constraints
  10. -- NOTE: if the constraint does not exist, an ignorable error will be reported.
  11. -- --------------------------------------------------
  13. -- --------------------------------------------------
  14. -- Dropping existing tables
  15. -- NOTE: if the table does not exist, an ignorable error will be reported.
  16. -- --------------------------------------------------
  18. -- --------------------------------------------------
  19. -- Creating all tables
  20. -- --------------------------------------------------
  22. -- Creating table 'TodoModels'
  23. CREATE TABLE [TodoModels] (
  24. [Id] int IDENTITY(1,1) NOT NULL,
  25. [Name] nvarchar(4000) NOT NULL,
  26. [Date] datetime NOT NULL
  27. );
  28. GO
  30. -- --------------------------------------------------
  31. -- Creating all PRIMARY KEY constraints
  32. -- --------------------------------------------------
  34. -- Creating primary key on [Id] in table 'TodoModels'
  35. ALTER TABLE [TodoModels]
  36. ADD CONSTRAINT [PK_TodoModels]
  37. PRIMARY KEY ([Id] );
  38. GO
  40. -- --------------------------------------------------
  41. -- Creating all FOREIGN KEY constraints
  42. -- --------------------------------------------------
  44. -- --------------------------------------------------
  45. -- Script has ended
  46. -- --------------------------------------------------

Now execute the application.

Step 6

Add the demo data.