Error adding table column

ServiceStack.OrmLite
1

Hello to all,
I’m trying to add a column to a table that not use the default schema in SqlServer e SqlLite. The table POCO have the attribute “Schema” set, when I execute the AddColumn method I receive this error: “Cannot find the object “Identities” because it does not exist or you do not have permissions”.
I’m doing something wrong or is it a not supported function? Currently i’m using ServiceStack 4.5.12.

This is the poco definition:

[Schema("core")]
[Alias("Identities")]
public class Identity : IIdentity
{
    [StringLength(50)]
    public string RegisterNumber { get; set; }

    ...
}

This is the schema upgrade implementation:

using (var ctx = dbFactory.OpenDbConnection())
 {
    if (!ctx.ColumnExists<Identity>(c => c.RegisterNumber))
        ctx.AddColumn<Identity>(c => c.RegisterNumber);
 }

Thanks to all

2

Can you show you database tables definitions? Do you have table Identity or Identities? Does the table belong to schema core in SQL server? If execute

SELECT * FROM [core].[Identities];
SELECT * FROM [core].[Identity];

what is returned by SQL Server?

3

I have the table [core].[Identities].

CREATE TABLE [core].[Identities](
	[Id] [int] IDENTITY(1,1) NOT NULL,
	[IdentityCode] [nvarchar](50) NOT NULL,
	[IdentityTypeId] [int] NOT NULL,
	[RegisterNumber] [nvarchar](15) NULL,
        .....

In my opinion the table schema attribute isn’t considered by the AddColumn method.

4

The schema name should now be included in DDL statements in this commit. This change is available from v5 that’s now available on MyGet. Please review v5 changes before upgrading.