public static int PersonUpdate(this TestDataDB dataConnection, int? @id, int? @PersonID, string? @FirstName, string? @MiddleName, string? @LastName, char? @Gender)
{
var parameters = new []
{
new DataParameter("@id", @id, LinqToDB.DataType.Int32),
new DataParameter("@PersonID", @PersonID, LinqToDB.DataType.Int32),
new DataParameter("@FirstName", @FirstName, LinqToDB.DataType.NText)
{
Size = 50
},
new DataParameter("@MiddleName", @MiddleName, LinqToDB.DataType.NText)
{
Size = 50
},
new DataParameter("@LastName", @LastName, LinqToDB.DataType.NText)
{
Size = 50
},
new DataParameter("@Gender", @Gender, LinqToDB.DataType.NText)
{
Size = 1
}
};
return(dataConnection.ExecuteProc("[Person_Update]", parameters));
}
public static IEnumerable <Person> PersonSelectByKey(this TestDataDB dataConnection, int? @id)
{
var parameters = new []
{
new DataParameter("@id", @id, LinqToDB.DataType.Int32)
};
return(dataConnection.QueryProc <Person>("[Person_SelectByKey]", parameters));
}
public static int PersonDelete(this TestDataDB dataConnection, int? @PersonID)
{
var parameters = new []
{
new DataParameter("@PersonID", @PersonID, LinqToDB.DataType.Int32)
};
return(dataConnection.ExecuteProc("[Person_Delete]", parameters));
}
public static IEnumerable <Person> PersonSelectListByName(this TestDataDB dataConnection, string? @firstName, string? @lastName)
{
var parameters = new []
{
new DataParameter("@firstName", @firstName, LinqToDB.DataType.NText)
{
Size = 50
},
new DataParameter("@lastName", @lastName, LinqToDB.DataType.NText)
{
Size = 50
}
};
return(dataConnection.QueryProc <Person>("[Person_SelectListByName]", parameters));
}
public static int PersonInsert(this TestDataDB dataConnection, string? @FirstName, string? @MiddleName, string? @LastName, char? @Gender)
{
var parameters = new []
{
new DataParameter("@FirstName", @FirstName, LinqToDB.DataType.NText)
{
Size = 50
},
new DataParameter("@MiddleName", @MiddleName, LinqToDB.DataType.NText)
{
Size = 50
},
new DataParameter("@LastName", @LastName, LinqToDB.DataType.NText)
{
Size = 50
},
new DataParameter("@Gender", @Gender, LinqToDB.DataType.NText)
{
Size = 1
}
};
return(dataConnection.ExecuteProc("[Person_Insert]", parameters));
}
public static int AddIssue792Record(this TestDataDB dataConnection)
{
return(dataConnection.ExecuteProc("[AddIssue792Record]"));
}
