If database server collation is Turkish_CI_AS, then following error occurs
***
System.Data.SqlClient.SqlException: Must declare the variable '@id'.
...
CREATE PROCEDURE dbo.[AddSearchItemWord]
@SearchItemID int,
@SearchWordsID int,
@Occurrences int
AS
DECLARE @ID int
SELECT @id = SearchItemWordID
...
***
In all type of Turkish collations 'i' is not lowercase of 'I', or vice versa 'I' is not uppercase of 'i'
even in case insensitive mode. This behavior causes problems in queries as @ID is not the same definition as @id, these are two different variables.
btw , I want to explain another key point for Turkish collations and/or Regional Settings
when you are using regex without the option RegexOptions.CultureInvariant "<DIV>" and "<div>" are different.
to match such words containing i with case insensitive behaviour you must use RegexOptions.CultureInvariant option.
Could you please keep these in mind. Maybe somewhere you want to match such a keyword etc.
And could you please update your script files to fix these. i.e script file "04.00.01.SqlDataProvider" in line 40 and 47 replace "@ID" --> "@id"