GPS Tracer Extension: storing the path on SQL2005 via Web Services

using System;
using System.Collections.Generic;
using System.Data;
using System.Data.Common;
using System.Text;
using Microsoft.Practices.EnterpriseLibrary.Data;
using GpsTracerServer.BusinessEntities;
using System.Data.SqlClient;
using System.Diagnostics;
using GpsTracerServer.DataAccess.SQLServer;

namespace GpsTracerServer.DataAccess
{
    /// <summary>
    /// Respository that lets you find Device in the
    /// CRM database.
    /// </summary>
    public class DeviceRepository : Repository<Device>
    {
        private string databaseName;

        public DeviceRepository(string databaseName)
            : base(databaseName)
        {
            this.databaseName = databaseName;
        }


        public List<Device> GetAllFromDevice()
        {
            ISelectionFactory<NullableIdentity> selectionFactory = new GetAllFromDeviceSelectionFactory();

            try
            {
                NullableIdentity nullableIdentity = new NullableIdentity();
                return base.Find(selectionFactory, new GetAllFromDeviceFactory(), nullableIdentity);
            }
            catch (SqlException ex)
            {
                HandleSqlException(ex, selectionFactory);
            }

            return new List<Device>();
        }

        public void Add(Device device)
        {
            DeviceInsertFactory insertFactory = new DeviceInsertFactory();
            try
            {
                base.Add(insertFactory, device);
            }
            catch (SqlException ex)
            {
                HandleSqlException(ex, insertFactory);
            }
        }

        public void Remove(System.Guid iD)
        {
            IDeleteFactory<System.Guid> deleteFactory = new DeviceDeleteFactory();

            try
            {
                base.Remove(deleteFactory, iD);
            }
            catch (SqlException ex)
            {
                HandleSqlException(ex, deleteFactory);
            }
        }


        public void Save(Device device)
        {
            DeviceUpdateFactory updateFactory = new DeviceUpdateFactory();
            try
            {
                base.Save(updateFactory, device);
            }
            catch (SqlException ex)
            {
                HandleSqlException(ex, updateFactory);
            }
        }

        private void HandleSqlException(SqlException ex, IDbToBusinessEntityNameMapper mapper)
        {
            if (ex.Number == ErrorCodes.SqlUserRaisedError)
            {
                switch (ex.State)
                {
                    case ErrorCodes.ValidationError:
                        string[] messageParts = ex.Errors[0].Message.Split(':');
                        throw new RepositoryValidationException(
                            mapper.MapDbParameterToBusinessEntityProperty(messageParts[0]),
                            messageParts[1], ex);

                    case ErrorCodes.ConcurrencyViolationError:
                        throw new ConcurrencyViolationException(ex.Message, ex);

                }
            }

            throw new RepositoryFailureException(ex);
        }
    }
}