How can i implement a database search using MVC project with stored procedure.

This is my storedprocedure which i want to use to search names from the database an automatically populate the gridview is ajax code.

please help how can i go about this in ASP.Net MVC

ALTER PROCEDURE [dbo].[nameschsearch](@s as nvarchar(50)) AS
SELECT * from student
WHERE     ([Name] LIKE @s  or [Name] LIKE '%'+@s+'%' or [Name] LIKE '%' + @s or [Name] LIKE @s + '%' AND ((student.Status) Is Null))
ORDER BY [Name]