Export (0) Print
Expand All

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.

  NameDescription
Public propertyErrorParametersGets the last three error parameters. Error parameters are used by SQL Server Compact to provide additional details about an error.
Public propertyHResultReturns an HRESULT value that identifies the type of error.
Public propertyMessageGets the text describing the error.
Public propertyNativeErrorGets 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 propertyNumericErrorParametersGets the first three error parameters. Error parameters are used by SQL Server Compact to provide additional details about an error.
Public propertySourceGets the name of the provider that generated the error.
Top

  NameDescription
Public methodEquals (inherited from Object)
Protected methodFinalize (inherited from Object)
Public methodGetHashCode (inherited from Object)
Public methodGetType (inherited from Object)
Protected methodMemberwiseClone (inherited from Object)
Public methodToStringGets 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.
Was this page helpful?
(1500 characters remaining)
Thank you for your feedback
Show:
© 2014 Microsoft