Hello,

When we define a DataSet visuallyin Visual Studio 2005, we can specify primary keys for a DataTable.

Say we defined table Employee. It has the following columns:

emp_id (PK)
emp_name

Suppose we setemp_id is the PK for Employee.VS would generate a FindByemp_id(int) method for the DataTable, and you can find a record based on emp_id easily.

My question is: Whatmechanism does FindByemp_id(int) use to search Employee? Is it a table-scan? Or is it a Hashcode-based scan?

I am concerned about the efficiency of FindByxxxx if the table's huge... I am using Sybase for the backend, so I couldn't enjoy the benefits ofusing SQL server to do thesearch.

Thanks for the help in advance,
Kenny