Reader Level:
ARTICLE

MVC 4 Entity in SQL Server

Posted by Dorababu Articles | ASP.NET MVC January 24, 2013
In this article you will see MVC 4 Entity in SQL Server.
  • 0
  • 0
  • 9557
Download Files:
 

Create a table in SQL Server as follows:

USE [forumDB1]

GO

 

/****** Object:  Table [dbo].[users]    Script Date: 01/23/2013 11:25:49 ******/

SET ANSI_NULLS ON

GO

 

SET QUOTED_IDENTIFIER ON

GO

 

SET ANSI_PADDING ON

GO

 

CREATE TABLE [dbo].[users](

            [userID] [int] NOT NULL,

            [EmailID] [varchar](50) NOT NULL,

            [Password] [varchar](50) NOT NULL,

            [FirstName] [varchar](50) NOT NULL,

            [LastName] [varchar](50) NULL,

            [JoinedDate] [datetime] NOT NULL,

            [usrImage] [image] NULL,

PRIMARY KEY CLUSTERED 

(

            [userID] ASC

)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY],

UNIQUE NONCLUSTERED 

(

            [EmailID] ASC

)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]

) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]

 

GO

 

SET ANSI_PADDING OFF

GO


Image 1.jpg

Image 2.jpg

Image 3.jpg

Image 4.jpg

Image 5.jpg

Then select your HomeController and change it to the following:

using System;

using System.Collections.Generic;

using System.Linq;

using System.Web;

using System.Web.Mvc;

using MvcApplication2.Models;

 

namespace MvcApplication2.Controllers

{

    public class HomeController : Controller

    {

        forumDB1Entities dbentity = new forumDB1Entities();

        public ActionResult Index()

        {

            ViewBag.Message = "Modify this template to jump-start your ASP.NET MVC application.";

 

            return View(dbentity);

        }

 

        public ActionResult About()

        {

            ViewBag.Message = "Your app description page.";

 

            return View();

        }

 

        public ActionResult Contact()

        {

            ViewBag.Message = "Your contact page.";

 

            return View();

        }

    }

}

Also change your view as follows
 

@model displaydatausingEF.Models.forumDB1Entities

@{

    Layout = null;

}

<!DOCTYPE html>

<html>

<head>

    <meta name="viewport" content="width=device-width" />

    <title>Index</title>

</head>

<body>

    <p>

       

    </p>

    <table>

        <tr>

            <th>

                Employee ID

            </th>

            <th>

                Email ID

            </th>

            <th>

                Password

            </th>

            <th>

                &nbsp;First Name

            </th>

            <th>

                &nbsp;Last Name

            </th>

            <th>

                Joined Date

            </th>

            <th>

                Picture

            </th>

        </tr>

        @foreach (var item in Model.users)

        {

            <tr>

                <td>

                    &nbsp;&nbsp;@item.userID

                </td>

                <td>

                    &nbsp;&nbsp;&nbsp;@item.EmailID

                </td>

                <td>

                    &nbsp;&nbsp;&nbsp;@item.Password

                </td>

                <td>

                    &nbsp;&nbsp;&nbsp;@item.FirstName

                </td>

                <td>

                    &nbsp;&nbsp;&nbsp;&nbsp;@item.LastName

                </td>

                <td>

                    &nbsp;&nbsp;&nbsp;@item.JoinedDate

                </td>

                <td>

                    <img src="@Url.Action("GetPhoto", new { photoId = item.userID })" />

                </td>

            </tr>

        }

    </table>

</body>

</html>

This will initially give output as follows:

Image 6.jpg

Now we will implement the code to show an image. Add this code to your HomeController:
 

public ActionResult GetPhoto(int usrID)

        {

            byte[] photo = null;

            var v = dbentity.users.Where(p => p.userID == usrID).Select(img => img.usrImage).FirstOrDefault();
            photo = v;

            return File(photo, "image/jpeg");

        }



Now re-run the application.

Happy coding cheers

 

COMMENT USING

Trending up