SubSonic Database Error

[shadowman123]

well i tried to Load value from Database using SubSonice Read method but it gave me an Error which is :-

PHP Code:

ArgumentException was unhandled
There's no column called 'superboss' for this object
Parameter name: columnName 


but Actually There is Column Named superboss in Database and was Written Correctly

Reading Code

PHP Code:

mf.SuperBossVariable = monsters[x].SuperBoss; 


SuperBoss Property

PHP Code:

[XmlAttribute("SuperBoss")]
[Bindable(true)]
public uint SuperBoss
{
 get { return GetColumnValue<uint>(Columns.SuperBoss); }
 set { SetColumnValue(Columns.SuperBoss, value); }
} 


SuperBoss string Field

PHP Code:

public static string SuperBoss = @"superboss"; 


PHP Code:

public static TableSchema.TableColumn superboss
        {
            get { return Schema.Columns[48]; }
        } 


The Column Named superboss inside Database


whats wrong ? And what should i do to Fix this Problem i've Tried Alot

Regards
shadowman123

[teroareboss1]

you add the column?
TableSchema.TableColumn colvarSuperBoss = new TableSchema.TableColumn(schema);
......

[abdoumatrix]

i don't have much exp. in it
but when i checked a file. i released if i wanna add a new coloum i will add it at this.

PHP Code:

#region Columns Struct
        public struct Columns
        {
            public static string Id = @"id"; 


PHP Code:

#region Typed Columns


        public static TableSchema.TableColumn IdColumn
        {
            get { return Schema.Columns[0]; }
        } 


PHP Code:

 #region Props

        [XmlAttribute("Id")]
        [Bindable(true)]
        public int Id
        {
            get { return GetColumnValue<int>(Columns.Id); }
            set { SetColumnValue(Columns.Id, value); }
        } 


PHP Code:

   private static void GetTableSchema()
        {
            if (!IsSchemaInitialized)
            {
                //Schema declaration
                TableSchema.Table schema = new TableSchema.Table("monsterinfos", TableType.Table, DataService.GetInstance("Conquer_Server"));
                schema.Columns = new TableSchema.TableColumnCollection();
                schema.SchemaName = @"";
                //columns

                TableSchema.TableColumn colvarId = new TableSchema.TableColumn(schema);
                colvarId.ColumnName = "id";
                colvarId.DataType = DbType.Int32;
                colvarId.MaxLength = 0;
                colvarId.AutoIncrement = false;
                colvarId.IsNullable = false;
                colvarId.IsPrimaryKey = true;
                colvarId.IsForeignKey = false;
                colvarId.IsReadOnly = false;
                colvarId.DefaultSetting = @"";
                colvarId.ForeignKeyTableName = "";
                schema.Columns.Add(colvarId); 


wish if i could help more.

[shadowman123]

well After i Added Table Column using the Following codes i Received An Error

PHP Code:

TableSchema.TableColumn colvarSuperBoss = new TableSchema.TableColumn(schema);
colvarOwnitemrate.ColumnName = "superboss";
colvarOwnitemrate.DataType = DbType.UInt32;
colvarOwnitemrate.MaxLength = 0;
colvarOwnitemrate.AutoIncrement = false;
colvarOwnitemrate.IsNullable = true;
colvarOwnitemrate.IsPrimaryKey = false;
colvarOwnitemrate.IsForeignKey = false;
colvarOwnitemrate.IsReadOnly = true;
colvarOwnitemrate.DefaultSetting = @"";
colvarOwnitemrate.ForeignKeyTableName = "";
schema.Columns.Add(colvarSuperBoss); 


Error

PHP Code:

TargetInvocationException was unhandled
Exception has been thrown by the target of an invocation. 


WTF Should i do .it annoys me

[teroareboss1]

be careful.
read again
you schema is colvarSuperBoss
you use colvarOwnitemrate

TableSchema.TableColumn colvarSuperBoss = new TableSchema.TableColumn(schema);
colvarOwnitemrate.ColumnName = "superboss";
colvarOwnitemrate.DataType = DbType.UInt32;
colvarOwnitemrate.MaxLength = 0;
colvarOwnitemrate.AutoIncrement = false;
colvarOwnitemrate.IsNullable = true;
colvarOwnitemrate.IsPrimaryKey = false;
colvarOwnitemrate.IsForeignKey = false;
colvarOwnitemrate.IsReadOnly = true;
colvarOwnitemrate.DefaultSetting = @"";
colvarOwnitemrate.ForeignKeyTableName = "";
schema.Columns.Add(colvarSuperBoss);

[shadowman123]

oh my bad its weird i havent noticed that anyways thx alot