CODEWITHSUNDEEP
c#datatableconnectionsql-server-cedatareader
amaters
amaters

Reputation: 2316

Datatable.Load does not work with SqlCeReader

I have this method:

public static DataTable ExecuteDataTable(IDbConnection connection, string cmdText)
{
    IDbCommand command = connection.CreateCommand();
    command.CommandText = cmdText;
    command.CommandType = CommandType.Text;
    IDataReader reader = command.ExecuteReader();
    DataTable dt = new DataTable();
    dt.Load(reader);
    return dt;
}

When i execute the query select * from information_schema.Tables against a connection of type SQLConnection it all works. However, when I try to run it against a connection of type SqlCEConnection the line dt.Load(reader) raises an exception:

System.Data.ConstraintException: Failed to enable constraints. One or more rows contain values violating non-null, unique, or foreign-key constraints.

Upvotes: 1

Views: 1147

Answers (1)

Icarus
Icarus

Reputation: 63956

Certainly a weird issue but here's an alternative:

Read the data into a DataSet and set the EnforceConstraints to false. You could then return DataSet.Tables[0]

Upvotes: 1

Related Questions