public virtual ProductView UpdateProductView(ProductView entity) { if (entity.IsTransient()) { return(entity); } ProductView other = GetProductView(entity.ViewId); if (entity.Equals(other)) { return(entity); } string sql = @"Update ProductView set [CustomerViewID]=@CustomerViewID , [ProductID]=@ProductID , [ViewDate]=@ViewDate where ViewID=@ViewID" ; SqlParameter[] parameterArray = new SqlParameter[] { new SqlParameter("@ViewID", entity.ViewId) , new SqlParameter("@CustomerViewID", entity.CustomerViewId) , new SqlParameter("@ProductID", entity.ProductId) , new SqlParameter("@ViewDate", entity.ViewDate) }; SqlHelper.ExecuteNonQuery(this.ConnectionString, CommandType.Text, sql, parameterArray); return(GetProductView(entity.ViewId)); }