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 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)); }