SubSonic Database Error

08/16/2013 22:05 shadowman123#1

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
[Only registered and activated users can see links. Click Here To Register...]

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

Regards
shadowman123

08/17/2013 00:08 teroareboss1#2

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

08/17/2013 00:08 abdoumatrix#3

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. :)

08/17/2013 00:40 shadowman123#4

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

08/17/2013 01:55 teroareboss1#5

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);

08/17/2013 10:16 shadowman123#6

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