????????????????ó????У???????????????????????????????????????????DataTable?????????????????? TestDataTable??????????????????????????????????select??????????????SetInputParameter???????????????????????Table??????????DataTable???????????select???????????

????class TestDataTable

????{

????private readonly SqlCommand _command;

????public TestDataTable(String connstr?? String selectQuery?? CommandType commandType)

????{

????SqlConnection conn = new SqlConnection(connstr);

????_command = new SqlCommand(selectQuery?? conn);

????_command.CommandType = commandType;

????}

????public void SetInputParameter(string parameterName?? object parameterValue)

????{

????if (_command.Parameters.Contains(parameterName))

????_command.Parameters[parameterName] =

????new SqlParameter(parameterName?? parameterValue);

????else

????_command.Parameters.AddWithValue(parameterName?? parameterValue);

????}

????public DataTable Table

????{

????get

????{

????DataTable _dataTable = new DataTable();

????SqlDataAdapter da = new SqlDataAdapter(_command);

????da.Fill(_dataTable);

????da.Dispose();

????return _dataTable;

????}

????}

????}

????????????????????LINQ?????????DataTable???????????????????????д???????????logFilePath???????????С?ResultSetComparer?????????????