SQl Exception: Incorrect syntax near '<'. when attempting to save changes to an entity

I followed the tutorial on creating my entity class manually instead of through the designer. My class looks like this:

public class : Entity { #region Fields

    [ValidatePresence]
    [ValidateLength(0, 200)]
    private string _name;
    private DateTime _timeRegistered;
    private bool _isActive;
    [ValidateLength(0, 250)]
    private string _description;
    [ValidateLength(0, 100)]
    private string _phoneId;
      #endregion


    #region Properties

    public string Name
    {
        get { return Get(ref _name, "Name"); }
        set { Set(ref _name, value, "Name"); }
    }

    public System.DateTime TimeRegistered
    {
        get { return Get(ref _timeRegistered, "TimeRegistered"); }
        set { Set(ref _timeRegistered, value, "TimeRegistered"); }
    }

    public bool IsActive
    {
        get { return Get(ref _isActive, "IsActive"); }
        set { Set(ref _isActive, value, "IsActive"); }
    }

    public string Description
    {
        get { return Get(ref _description, "Description"); }
        set { Set(ref _description, value, "Description"); }
    }

    public string PhoneId
    {
        get { return Get(ref _phoneId, "PhoneId"); }
        set { Set(ref _phoneId, value, "PhoneId"); }
    }     

    public Uri Link { get; set; }
    [DataMember] 
    public double ToleranceToFeatureInMeters { get; set; }
    #endregion


}

Then I manually created a UnityOfWork class like so:

public class SubscriberUnitOfWork : Mindscape.LightSpeed.UnitOfWork
    {
        public System.Linq.IQueryable<Subscriber> Subscribers
        {
            get { return this.Query<Subscriber>(); }
        }
    }

Now, when I try to persist an item to the database, I get

System.Data.SqlClient.SqlException was caught Message="Incorrect syntax near '<'." Source=".Net SqlClient Data Provider" ErrorCode=-2146232060 Class=15 LineNumber=3 Number=102 Procedure="" Server="NJISINSPIRON\SQLEXPRESS" State=1 StackTrace: at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) at System.Data.SqlClient.SqlDataReader.ConsumeMetaData() at System.Data.SqlClient.SqlDataReader.get_MetaData() at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString) at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async) at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, DbAsyncResult result) at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method) at System.Data.SqlClient.SqlCommand.ExecuteScalar() at ...() at ..(IUnitOfWork , IDbCommand ,
) at ..(IUnitOfWork , IDbCommand ) at ..(Entity ,
) at ..(Entity , ICollection1 ) at ..(Entity , List1 ) at ..(UnitOfWorkBase , IEnumerable1 , IEnumerable1 ) at Mindscape.LightSpeed.UnitOfWork.SaveChanges(Boolean reset) at Mindscape.LightSpeed.UnitOfWorkBase.SaveChanges() at Services.Contracts.Entities.SubscriberRepository.TryAdd(String name, ILocationServiceSubscriber subscriber) in D:\Documents\Visual Studio 2008\Projects\PushNotifications.Server\Services.Interface\Entities\SubscriberRepository.cs:line 46 InnerException:

What did I miss? Thanks in advance.

Hi,

The issue is in this line:

public Uri Link { get; set; }

You cannot use automatic properties. The C# compiler will generate a backing field for this at compile time and then because LightSpeed thinks all fields are properties in your table, it tries to select that field back (and it infers the type from the type of the automatically generated property, which is typically a generic, hence the < character appearing in your query which is not valid.

To fix this, change to:

private Uri _link;
public Uri Link
{
    get { return Get(ref _link, "Link"); }
    set { Set(ref _link, value, "Link"); }
}

If the field "_link" is not in the database and shouldn't be selected or persisted by LightSpeed, place the Transient attribute on the field:

[Transient]
private Uri _link;

I hope that helps!

John-Daniel

Thank you, that was it.