1. Create an ASP.NET
MVC 4 Web Application.
2. Select Basic
Project Template, Razor View engine
and leave ‘create a unit test project’ tick box blank.
3. Add a Model Class name it as Address.cs.
Shortcut: Ctrl+. To find references required
4. Add reference to jquery.
5. Create a connection string in the Web.config file.
<add name="AddressDBContext" connectionString="Data
Source=(LocalDb)\v11.0;Initial Catalog=PostCode;Integrated Security=SSPI;AttachDBFilename=|DataDirectory|\PostCode.mdf" providerName="System.Data.SqlClient" />
6. Build the solution (Ctrl+Shift+B).
7. Add a Controller named AddressController.
8. Add a View by right click in the AjaxSearch method
in the AddressController.
9. Create a partial view ‘_PostCodesList’ in the View/Address folder. Click the Create as a
partial view tick box.
10. Enable code first migrations.
At the
PM> prompt enter the
following command:
enable-migrations -contexttypename
AddressDBContext
The
Configuration class includes a Seed method that is called
when the database is created and every time it is updated after a data model
change.
namespace MvcSearchSite.Migrations
{
using System;
using System.Data.Entity;
using
System.Data.Entity.Migrations;
using System.Linq;
using MvcSearchSite.Models;
using System.Collections.Generic;
internal sealed class Configuration : DbMigrationsConfigurationAddressDBContext>
{
public Configuration()
{
AutomaticMigrationsEnabled = false;
}
protected override void Seed(MvcSearchSite.Models.AddressDBContext context)
{
var postcode = new List<Address>
{
new Address { ID=1, PostCode = "AB101AB", Street1 = "Alexander",
Street2 = "",Address1="Address1",Address2="",Town="Derby",County="Derbyshire" }
};
postcode.ForEach(s =>
context.Addresses.AddOrUpdate(p => p.ID, s));
context.SaveChanges();
}
}
}
Build the project.
In the Package Manager
Console window, enter the following commands:
add-migration InitialCreate
update-database
A SQL Server database has
now been created for your data model
In Database Explorer db is visible, sql commands can be executed.
If you need to add more data to the table, change the Seed method and run the ‘update-database’
command.
11. Set the default starting page in ‘App_Start/RouteConfig.cs’.
12. Run the application (F5)
