This topic has not yet been rated - Rate this topic

SqlCeError Class

Collects information relevant to a warning or error returned by the data source. This class cannot be inherited.

System.Object
  System.Data.SqlServerCe.SqlCeError

Namespace:  System.Data.SqlServerCe
Assembly:  System.Data.SqlServerCe (in System.Data.SqlServerCe.dll)
[SerializableAttribute]
public sealed class SqlCeError

The SqlCeError type exposes the following members.

  Name Description
Public property ErrorParameters Gets the last three error parameters. Error parameters are used by SQL Server Compact to provide additional details about an error.
Public property HResult Returns an HRESULT value that identifies the type of error.
Public property Message Gets the text describing the error.
Public property NativeError Gets the native error number of the SqlCeError. For more information about these errors, see "SQL Server Compact Errors" in the Troubleshooting section of SQL Server Compact Books Online.
Public property NumericErrorParameters Gets the first three error parameters. Error parameters are used by SQL Server Compact to provide additional details about an error.
Public property Source Gets the name of the provider that generated the error.
Top
  Name Description
Public method Equals (inherited from Object)
Protected method Finalize (inherited from Object)
Public method GetHashCode (inherited from Object)
Public method GetType (inherited from Object)
Protected method MemberwiseClone (inherited from Object)
Public method ToString Gets the complete text of the error message. (Overrides Object.ToString().)
Top

An instance of SqlCeError is created by the System.Data.SqlServerCe managed provider when an error occurs. The SqlCeErrorCollection contains one or more instances of SqlCeError.

The following example shows a typical use of SqlCeError.

try
{
    SqlCeReplication repl = new SqlCeReplication();

    // Fill repl properites here
    // ...

    // SqlCeReplication may throw SqlCeException which contains a 
    // collection of errors; SQL Mobile database engine always
    // returns one error in the collection
    //
    repl.Synchronize();
}
catch (SqlCeException e)
{
    foreach (SqlCeError error in e.Errors)
    {
        // Use SqlCeError properties if you need specific
        // application logic depending on the error condition
        //
        if (28577 == error.NativeError /*SSCE_M_SCHEMAHASCHANGED*/)
        {
            // Error specific logic goes here...
            //
        }

        // Note: For native error numbers, refer to SQL Server Mobile Errors
        // in the SQL Server Mobile Books Online
        //
        MessageBox.Show(error.Message);
    }
}


Any public static (Shared in Microsoft Visual Basic) members of this type are thread safe. Any instance members are not guaranteed to be thread safe.
Did you find this helpful?
(1500 characters remaining)