I have an Employee Table.
On the GUI i have a Search Type (combo box) and Search Criteria (Text Box)
User can do search based on Search Type for SSN,LastName, FirstName .......
so far i have been writting the IPredicateExpressionto get the SSN,LastName,FirstName search results....
Someting like this...
DataTable EmployeeResult = employee.GetMulti(filter);
but now my users want more and more search type like department, Email, PhoneNumber
zipcode,city....and more
so to make this more dynamic i have created a table EmployeeSearchType that has Two Column SearchType and SPName
Something like following
SearchType , SPName
LastName , spEmpBYLastName
FirstName , spEmpBYFirstName
SSN , spEmpBYSSN
OK here is the question
how can i get result from these SP with one line of code
something like following
DataTable EmployeeResult=myProject.StoredProcedureCallerClasses.RetrievalProcedures."Name of SP with Parameter"
is there any way to pass the SP Name to StoredProcedureCallerClasses from String with parameter?
Thanks