Showing posts with label SQL Server Compact. Show all posts
Showing posts with label SQL Server Compact. Show all posts

Friday, September 4, 2009

SyncComm 0.95 Exception Handling

Despite the delay of the last SyncComm’s version it has finally  been released. There are important improvements which I have been working on during the last months. One of such improvements is the enhancement of exception handling between the WCF component and the client’s generated proxy.

By default, when an exception occurs on the WCF Service the client proxy does not entirely deserialize the fault message received. Thus, when the exception is caught by the caller method the exception message thrown by the WCF Service is not available although the message has been sent and received. Just not right.

To solve this issue some changes have had to be made on CFClientBase class, especially on processReply method. If you wish to get further information about how it works, see WCF Guidance for Mobile Developers, section Error Handling.

Throwing exceptions from WCF SyncComm components

Each ServiceContract implementation has its own try..catch statement and all those methods throw the exception in the same way. Basically, “an exception” contains:

  • Exception/InnerException message
  • Fault reason text (‘friendly’ message)
  • Fault code
    • An universal identifier
    • WCF namespace

Check the following code extracted from SyncComm.Service.SyncService class’s constructor.

catch (SqlException sqlex)
{
Guid id = Guid.NewGuid();

//display detailed exception information on console
Notification.Invoke(DateTime.Now,
string.Format ("Exception {0}: {1}", id.ToString(), sqlex.Message));

//throw and exception for being catch by client
throw new FaultException<string>(sqlex.Message, new FaultReason(
new FaultReasonText("SQL Server is not available. Please try later.")),
FaultCode.CreateSenderFaultCode(id.ToString(), "urn:synccomm.com/2009/07/ISyncService"));


}
catch (Exception e)
{
Guid id = Guid.NewGuid();

//display detailed exception information on console
Notification.Invoke(DateTime.Now,
string.Format ("Exception {0}: {1}",id.ToString(),e.Message));

throw new FaultException<string>(e.Message, new FaultReason(
new FaultReasonText("SyncService unavailable. Contact SyncService support.")),
FaultCode.CreateSenderFaultCode(id.ToString(), "urn:synccomm.com/2009/07/ISyncService"));

}





As you could appreciate, there are some issues you may pay attention on. At first, throwing the entire exception message is not a good practice because the exception message could contain sensitive information. On the other hand, the error message should head the user to perform any action he might do to solve it, hence, despite the WCF SyncService is not available due to technical reason, for example, SQL Server is not available because it is being restarted for maintenance purposes , which solutions is trivial, the friendly message that might be thrown should be:



“SyncService unavailable. Contact SyncService support or try again later.”




Instead of:




“… The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured…”




This kind of message personalization is possible right now by SyncComm.



Exception’s unique identifier represented by System.Guid object should be useful for identifying such exception on both sides. For example, consider the next exception thrown on server side:



ServerException



FaultException message is sent to client whilst FaultException is shown on ServiceHost console application:



ServerExceptionConsole



Handling exceptions by SyncComm client



The SyncAgent’s Sync() method’s call is wrapped by try…catch statement. After a call of the method any exception will be caught by one of the following Exception types:




  • CFFaultSyncException which catches all application’s exceptions thrown by WCF Service.


  • CommunicationException which catches any communication error in either client or server side.


  • Exception which catches any other non-typed exception, for example channel’s timeout expiring.



Let’s talk about CFFaultSyncException type case. This exception type returns a bunch of information about exception caught and thrown by WCF Service. The most important thing is that inside this object we have a couple of description fields of the source exception. Recall the structure of FaultException explained above. There is a friendly message as well as more technical one. The friendly message is the one you should drop onto application screen whilst technical one is such you should log to be checked later. Remember, entire exception has a unique identifier that corresponds with FaultException thrown by server.



Here you are an example showed above, about how it is handled by client:



ClientExceptionCatch







At the result, friendly message is dropped:



emulatorMessageError



Whilst a more detailed exception’s message is properly logged.



The code of the client would be something like:




catch (CFFaultSyncException faultEx)
{
Cursor.Current = Cursors.Default;

//
MessageBox.Show(string.Format("FaultCode: {0}\r\nFaultReason: {1}\r\nHasDetail: {2}",
faultEx.FaultCode, faultEx.FaultMessage, faultEx.HasDetail));
}
catch (CommunicationException communicationException )
{
//is the emulator cradled? does it reach SyncService endpoint?
MessageBox.Show(communicationException.Message);
}
catch (Exception e)
{
//something is not configured properly
MessageBox.Show(e.Message);
//HResult -2146233087 maybe database must be reinitialize

}





Any doubt or comment? please contact here.



Cheers,

Wednesday, October 8, 2008

SQL Server Compact Edition, Best Practices


Since the last April to these days, I have attended some conferences and have spoken with a several colleagues about SQL Server Compact 3.5. One thought really surprise me is that most of these people still think that SQL Server Compact is a relational database only for device developments. In fact, one of the most important features, from my point of view, of this SQL Server edition is multiplatform support, since it was introduced as is in the first betas of SQL Server Everywhere (SQL Server Compact 3.1).

SQL Server Compact 3.5 is a relational database manager specifically built for Smart Clients for occasionally connected systems. In fact, sync services for ado.net 1.0 was released with the first betas in order to introduce a set of tools working together to respond to sync solutions demands. Sync Services for ADO.NET introduce an alternative way to get the data updated between two or more data sources based on oriented serviced technology. ClickOnce, on the other hand, is other SmartClient technology.

Actually, all these technological pieces converge into a powerful set of development tools that allow easier occasionally connected systems building with all aspects, peculiarities and own features.
Probably, the key piece is the proper database, a simple sdf extension file which brings all or most important weight of responsibility. The programming model used in this kind of solutions is not so different than we have used with desktop or client/server applications but it has its own peculiarities we might know, so this database may be used on either Windows Desktop or Windows CE platforms, that’s mean either on .NET Framework or .NET Compact Framework, so, if a set of peculiarities exists and the evolution of the technology we use allows it, why don’t we create multiplatforms data access components?, in other words, for .NET Framework and .NET CF.

Actually, it has got its pros and cons, obviously. .NET Compact Framework is nearly 30% subset of full .NET Framework so to face development of multiplatform’s components is possible but with its own questions. We got an example by using transactional operations, as new feature in version 3.5, can be handled by Lightweight Transaction Manager through managed classes in System.Transaction namespace, however it may be used only on Windows Desktop platforms. Here you are an example of peculiarity on multiplatform’s code.

Despite SQL Server Compact has not been made as a great storage and processing data base we cannot forget application’s scalability knowing what kind of type are available and benefit from it in order to make the task easy to query optimizer, as far as knowing the main differences between Compact and others editions. A feature I’d like to remark is that SQL Server Compact gives an exceptional exception handling through managed classes based on native typify errors and operating system error spread as HResult.

For more than 14 months I was working trying to looking for SQL Server Compact’s development models, I synthesized the most important issues for the experimented developer with this kind of applications kick off his projects with a bit average, showing it in a eBook with few more of 110 pages which editor, SolidQ@Press, have just edited and now is available.

Application development with SQL Server Compact Edition: Best Practices do not pretend to be a reference guide, but a vertical book with alls and each important aspects a developer must know for developing applications for “the little” of SQL Server family, directly and without introductions.