ASP.NET

        public ViewResult Index()
        {
var observations = db.Observations
                .Include("Claim").Include("Defect").Include("InspectionType")
                .Include("Location").Include("Property");
            ViewBag.defectId = new SelectList(db.Defects, "id", "displayId");
            return View(observations.ToList());
        }
        public ViewResult Search(int defectId)
        {
var observations = db.Observations
                .Include("Claim").Include("Defect").Include("InspectionType")
                .Include("Location").Include("Property").Where(o => o.defectId == defectId);
            return View(observations.ToList());
        }

@Html.DropDownList("defectId", String.Empty)
@Html.ActionLink("Search","Search", new { defectId=??????????????})

CREATE TRIGGER Changed

ON dbo.Products

AFTER INSERT, UPDATE, DELETE

AS

Update  TableChanged Set Changed = 1 WHERE TableName='Products' 

If Not IsPostBack Then            
Dim dv As DataView
            Dim changed As Boolean = Global.CheckChanged("Products")
            If changed Then
                dv = LoadDV()
            Else
                dv = Cache("cachedDV")
                If dv Is Nothing Then 'in case application restarts, changed will be false and dv null
                    LoadDV()
                    dv = Cache("cachedDV")
                End If
            End If

Protected Function LoadDV() As DataView
        Dim dt As DataTable = Product.GetDiscounted
        Dim dv As DataView = New DataView(dt)
        Global.UpdateChanged("Products")
        Cache("cachedDV") = dv
        Return dv
    End Function

ALTER PROCEDURE dbo.TableChangedCheck
	@sTable varchar(20)
AS
	SET NOCOUNT ON
	Select Changed From TableChanged WHERE TableName=@sTable
	RETURN

ALTER PROCEDURE dbo.TableChangedUpdate
	@sTable varchar(20)
AS
	SET NOCOUNT ON
	UPDATE TableChanged SET Changed = 0 WHERE TableName=@sTable
	RETURN