public static int PersonUpdate(this TestDataDB dataConnection, int? @id, int? @PersonID, string? @FirstName, string? @MiddleName, string? @LastName, string? @Gender) { var parameters = new [] { new DataParameter("@id", @id, LinqToDB.DataType.Int32), new DataParameter("@PersonID", @PersonID, LinqToDB.DataType.Int32), new DataParameter("@FirstName", @FirstName, LinqToDB.DataType.VarChar) { Size = 255 }, new DataParameter("@MiddleName", @MiddleName, LinqToDB.DataType.VarChar) { Size = 255 }, new DataParameter("@LastName", @LastName, LinqToDB.DataType.VarChar) { Size = 255 }, new DataParameter("@Gender", @Gender, LinqToDB.DataType.VarChar) { Size = 255 } }; return(dataConnection.ExecuteProc("[Person_Update]", parameters)); }
public static IEnumerable <PersonSelectByKeyResult> PersonSelectByKey(this TestDataDB dataConnection, int? @id) { var parameters = new [] { new DataParameter("@id", @id, LinqToDB.DataType.Int32) }; return(dataConnection.QueryProc <PersonSelectByKeyResult>("[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 <PersonSelectByNameResult> PersonSelectByName(this TestDataDB dataConnection, string? @firstName, string? @lastName) { var parameters = new [] { new DataParameter("@firstName", @firstName, LinqToDB.DataType.VarChar) { Size = 255 }, new DataParameter("@lastName", @lastName, LinqToDB.DataType.VarChar) { Size = 255 } }; return(dataConnection.QueryProc <PersonSelectByNameResult>("[Person_SelectByName]", parameters)); }
public static int PersonInsert(this TestDataDB dataConnection, string? @FirstName, string? @MiddleName, string? @LastName, string? @Gender) { var parameters = new [] { new DataParameter("@FirstName", @FirstName, LinqToDB.DataType.VarChar) { Size = 255 }, new DataParameter("@MiddleName", @MiddleName, LinqToDB.DataType.VarChar) { Size = 255 }, new DataParameter("@LastName", @LastName, LinqToDB.DataType.VarChar) { Size = 255 }, new DataParameter("@Gender", @Gender, LinqToDB.DataType.VarChar) { Size = 255 } }; return(dataConnection.ExecuteProc("[Person_Insert]", parameters)); }