Create Procedure [dbo].[usp_RolesList]
    (@WhereCond varchar(50))
AS
Begin
    Set NoCount ON
    Declare @SQLQuery AS Varchar(max)
    Set @SQLQuery = 'Select * From dbo.AspNetRoles ' + @WhereCond
    Execute sp_Executesql @SQLQuery

End
and this is my c# code that I am using for executing the results
var idParam = new SqlParameter
                    {
                        ParameterName = "WhereCond",
                        Value = "where Id > 0"
                    };
                    var courseList = ctx.Database.SqlQuery<UserRoles>("exec usp_RolesList @WhereCond ", idParam).ToList<UserRoles>();