User-1484203585 posted
I have created my first basic application using template ASP.NET Dynamic Data Linq to SQL Web Application (Visual Basic) to learn about LINQ to SQL.
The components are a Gridview, a DataContext model, a stored procedure and a view.
So far, the application is working as expected with the exception that if i try to update with the same rating as that previously entered it will not trigger an update.
So, in the screenshot below for example, if I enter 9 again as a rating, the row will not change to Rating=9, Total_rating =18, Total_ratings=2 even if done after a delibarate error has been forced (see row 2 ) and then 9 re-entered.
The code is essentially either default or auto-generated (as below).
This concept has not been problematic before, when in another application I was using an SqlDataSource instead of a LinqDataSource ....
UpdateCommand="Yes_Update" UpdateCommandType="StoredProcedure">
<UpdateParameters>
<asp:Parameter Name="ID" Type="Int32" />
<asp:Parameter Name="Rating" Type="Int32" />
</UpdateParameters>
Any help would be appreciated, thanks.
Sample screen shot
Default.aspx.vb Imports System.Web.DynamicData
Class _Default
Inherits Page
Protected Sub Page_Load(ByVal sender As Object, ByVal e As EventArgs)
Dim visibleTables As IList = Global_asax.DefaultModel.VisibleTables
If visibleTables.Count = 0 Then
Throw New InvalidOperationException("There are no accessible tables. " &
"Make sure that at least one data model is registered in Global.asax " &
"and scaffolding is enabled or implement custom pages.")
End If
End Sub
End Class
<View Join_1> SELECT TOP (100) PERCENT myDB.yes_personnel.IdPerson, myDB.yes_personnel.First_Name,
myDB.yes_personnel.Last_Name, myDB.yes_instruments.Instrument_Name,
myDB.yes_ratings.Rating, myDB.yes_ratings.Total_rating, myDB.yes_ratings.Total_ratings
FROM myDB.yes_instruments INNER JOIN
myDB.yes_personnel ON
myDB.yes_instruments.IdPerson = myDB.yes_personnel.IdPerson INNER JOIN
myDB.yes_ratings ON myDB.yes_personnel.IdPerson = myDB.yes_ratings.IdRating
ORDER BY myDB.yes_personnel.IdPerson
<Store Procedure Yes_Update>
USE [myDB]
GO
/****** Object: StoredProcedure [myDB].[Yes_Update] Script Date: 07/15/2011 14:28:13 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
-- =============================================
-- Author:
-- Create date: 09.07.2011
-- Description: Yes Update
-- =============================================
ALTER PROCEDURE [myDB].[Yes_Update]
-- Add the parameters for the stored procedure here
@ID int = 0,
@Rating int = 0
AS
BEGIN
-- SET NOCOUNT ON added to prevent extra result sets from
-- interfering with SELECT statements.
SET NOCOUNT ON;
-- Insert statements for procedure here
UPDATE myDB.yes_ratings
SET Rating = @Rating,
Total_rating = Total_rating + @Rating,
Total_ratings = Total_ratings + 1
WHERE
IdRating = @ID
END
The update occurs in YesLINQ.designer.vb which is auto-generated and here is the relevant code. <Global.System.Data.Linq.Mapping.ColumnAttribute(Storage:="_Rating", DbType:="Int NOT NULL")> _
Public Property Rating() As Integer
Get
Return Me._Rating
End Get
Set
If ((Me._Rating = value) _
= false) Then
Me.OnRatingChanging(value)
Me.SendPropertyChanging
Me._Rating = value
Me.SendPropertyChanged("Rating")
Me.OnRatingChanged
End If
End Set
End Property
<Global.System.Data.Linq.Mapping.FunctionAttribute(Name:="myDB.Yes_Update")> _
Public Function Yes_Update(<Global.System.Data.Linq.Mapping.ParameterAttribute(Name:="ID", DbType:="Int")> ByVal iD As System.Nullable(Of Integer), <Global.System.Data.Linq.Mapping.ParameterAttribute(Name:="Rating", DbType:="Int")> ByVal rating As System.Nullable(Of Integer)) As Integer
Dim result As IExecuteResult = Me.ExecuteMethodCall(Me, CType(MethodInfo.GetCurrentMethod,MethodInfo), iD, rating)
Return CType(result.ReturnValue,Integer)
End Function
