MVC 5 tutorial

Getting Started with ASP.NET MVC 5

Adding a Controller

Adding a View

Adding a Model

Creating a Connection String and Working with SQL Server LocalDB

Accessing Your Model's Data from a Controller

Examining the Edit Methods and Edit View

Adding Search

Adding a New Field

Adding Validation

Examining the Details and Delete Methods

The above all articles wrote by 

By Rick Anderson

Simple Membership MVC4

Simple Membership

The Asp.Net MVC 4 introduced the many new features one of the main features is SimpleMembership. SimpleMembership is also support for Outh. SimpleMembership has been designed as an advanced of previous ASP.NET Role and Membership provider system.

Whenever we create a new MVC 4 project, Simple Membership is automatically implemented and the related views, models and controllers are also automatically generated. Let‘s we look at this bellow image.

WebSecurity

Simple membership provides the new class called WebSecurity. MSDN definition (“Provides security and authentication features for ASP.NET Web Pages applications, including the ability to create user accounts, log users in and out, reset or change passwords, and perform related tasks.”-MSDN).

In the class have SimpleMembership related methods are there, I would explain some basic methods and how to use in our projects.

1) Login

WebSecurity.Login(UserName,Password, persistCookie:RememberMe)

The login method to check the given user is authorized person or not, it has three parameters Username-The User Name, Password-The user password, and persistCookie- It is (Optional) true to specify that the authentication token in the cookie should be persisted beyond the current session; otherwise false. The default is false.

1) LogOut

WebSecurity.Logout();

The logout method is used to clears all authentication cookies from the cookie cache in other words to disconnect the user

3) Create Account

WebSecurity.CreateAccount(userName, password, requireConfirmationToken = false);

WebSecurity. CreateUserAndAccount(userName, password, propertyValues = null, requireConfirmationToken = false);

If our application wants more detail about the user we will use CreateUserAndAccount method otherwise we use Create Account

The bellow image shows the all other methods of web security

Roles  

SimpleMembership provides another one class named as Roles. . MSDN definition” Manages user membership in roles for authorization checking in an ASP.NET application. This class cannot be inherited.”

In the class have Role based methods are there, I would explain basic methods and how to use in our projects.

1)CreateRole

Roles.CreateRole("RolesName");

 The method has been used to add a new role the database. It has single parameter named as rolename.

2)DeleteRole

Roles.DeleteRole("rolename");

The method has been used to Removes a role from the data source. . It has single parameter named as rolename.

The bellow image shows the all other methods of websecurity roles

Database structure

Simple membership uses the entity framework model first approach whether when we execute the application it would be automatically create the database and tables. Let we see the tables

1)      UserProfile-It is a extension table for users.

2)      webpages_Membership-User security related data’s are their like “password , password salt etc”.

3)      webpages_OAuthMembership- Outh related information’s  stored in this table.

4)      webpages_Roles- The roles are stored like(“Admin, Editor etc..”).

5)      webpages_UsersInRoles- which user have which role that informations are stored this table.

Conclusion

In this article I simply explained how to use SimpleMebership, it’s only for beginners

How to call a stored procedure through MVC 4 and Entity Framework 5.0

Create database

•         Just we have to create a simple database named as student
•         We also create simple table named as student
•        Write a simple stored procedure

USE [Student ]

GO

/****** Object:  StoredProcedure [dbo].[GetStudents]    Script Date: 05/14/2013 12:56:17 ******/

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

ALTER Procedure [dbo].[GetStudents]

As

Begin

   select * from dbo.StudentDetails

End

Add Edmx

As we know how to add edmx file. In the second step of adding edmx file (choose your database objects and settings). Let we choose the stored procedure and functions checkbox and expand the checkbox and select which stored procedure you want. Then proceed the other steps finally we get an edmx files and related context classes.

As we know about EDM (Entity Data Model) However, just remember the Storage model, It is your database design model which includes tables, views, stored procedures and their relationships and keys.The Storage model stored procedure configuration like below 

public partial class GetStudents_Result
    {
        public int Id { get; set; }
        public string Name { get; set; }
        public string Class { get; set; }
    }

  public virtual ObjectResult<GetStudents_Result> GetStudents()

        {

            return ((IObjectContextAdapter)this).ObjectContext.ExecuteFunction<GetStudents_Result>("GetStudents");

        }

Then we access the stored procedure in controller. So we create a object for our entity class 

            

            StudentEntities entity = new StudentEntities();

            var sd = entity.GetStudents().ToList();

            return View(sd);

Conclusion 

If any one have any doubts and corrections plese comment me  Thanks
Abiruban@ Niventh