public static IEnumerable <PersonSelectByKeyResult> PersonSelectByKey(this TestDataDB dataConnection, int?id)
{
var parameters = new []
{
new DataParameter("@id", id, DataType.Int32)
};
return(dataConnection.QueryProc <PersonSelectByKeyResult>("[Person_SelectByKey]", parameters));
}
public static IEnumerable <PersonSelectListByNameResult> PersonSelectListByName(this TestDataDB dataConnection, string?firstName, string?lastName)
{
var parameters = new []
{
new DataParameter("@firstName", firstName, DataType.NText)
{
Size = 50
},
new DataParameter("@lastName", lastName, DataType.NText)
{
Size = 50
}
};
return(dataConnection.QueryProc <PersonSelectListByNameResult>("[Person_SelectListByName]", parameters));
}