Xml Not matching expected resultsdisabling namespace attributes in serializationWhat does <![CDATA[]]> in XML mean?How do you parse and process HTML/XML in PHP?XmlSerializer obfuscation support?Parsing XML in Windows Phone 7Cloning an instance of object to its base typeRead SOAP XML by ASMX web servcie functionread line and keep spaces from xml fileError using node-soap in NodeJSImport XML into SQL server using OPENXML command with XMLNS

Should I give professor gift at the beginning of my PhD?

Grover algorithm for a database search: where is the quantum advantage?

C++ Arduino IDE receiving garbled `char` from function

How to tell your grandparent to not come to fetch you with their car?

Were Alexander the Great and Hephaestion lovers?

What is the highest possible temporary AC at level 1, without any help from others?

Are there any important biographies of nobodies?

Winning Strategy for the Magician and his Apprentice

How can this tool find out registered domains from an IP?

Why did the Herschel Space Telescope need helium coolant?

Why would future John risk sending back a T-800 to save his younger self?

How come the nude protesters were not arrested?

Is it possible to 'live off the sea'

How to deal with apathetic co-worker?

Is using haveibeenpwned to validate password strength rational?

Is it possible to have a wealthy country without middle class?

Find the limit of a multiplying term function when n tends to infinity.

Does Disney no longer produce hand-drawn cartoon films?

Should an arbiter claim draw at a K+R vs K+R endgame?

Why was the Sega Genesis marketed as a 16-bit console?

What makes an item an artifact?

Impedance ratio vs. SWR

What is the highest possible permanent AC at character creation?

PhD - Well known professor or well known school?



Xml Not matching expected results


disabling namespace attributes in serializationWhat does <![CDATA[]]> in XML mean?How do you parse and process HTML/XML in PHP?XmlSerializer obfuscation support?Parsing XML in Windows Phone 7Cloning an instance of object to its base typeRead SOAP XML by ASMX web servcie functionread line and keep spaces from xml fileError using node-soap in NodeJSImport XML into SQL server using OPENXML command with XMLNS






.everyoneloves__top-leaderboard:empty,.everyoneloves__mid-leaderboard:empty,.everyoneloves__bot-mid-leaderboard:empty height:90px;width:728px;box-sizing:border-box;








0















I am trying to build a schema xml using the following but I am having issues items our being repeated twice and the fields are not being populated.



Basically what happens is the program goes out to sql gets the columns names of the chosen tables then it should produce a schema simlar to as follows not identically in term of values but yes in terms of structure



 public List<TableNames> _tablesNamesList = new List<TableNames>();

 public void BuildSchema()
 

 foreach (var table in _tablesNamesList)
 
 PersistentObject _newObject = new PersistentObject();
 List<PersistentObject> _newPersistantObjectList = new List<PersistentObject>();

 List<TableDefnition> _newList = db.GetALLTableDeiniations(table.TABLE_NAME);

 List<FieldSchemaXml> _newFieldList = new List<FieldSchemaXml>();


 foreach (var item in _newList)
 

 FieldSchemaXml _newSchema = new FieldSchemaXml();


 _newSchema = ConvertSQLDataTypeToSage(item.Type, _newSchema, item);


 _newSchema.Name = item.Field;
 _newSchema.IsUnique = "false";
 _newSchema.IsReadOnly = "false";
 _newSchema.IsQueryable = "true";
 if (item.is_nullable == 1)
 

 _newSchema.IsNullable = "true";
 
 else
 
 _newSchema.IsNullable = "false";
 

 _newSchema.IsReadOnly = "false";
 _newSchema.IsUnique = "false";
 _newSchema.Group = "false";

 _newSchema.IsLockable = "false";
 _newSchema.IsDeltaField = "false";
 _newSchema.IsPrimaryKey = "false";
 _newSchema.FillType = "None";
 _newSchema.Direction = "Input";
 _newSchema.OverrideFormatting = "false";
 _newSchema.ValueSetByDatabase = "false";
 _newSchema.FormatScale = "0";
 _newSchema.NegativeFormatting = "Standard";
 _newSchema.AggregateFunction = "false";
 _newSchema.IsExpression = "false";
 _newSchema.IsBrowsable = "true";
 _newSchema.IsQueryable = "true";
 _newSchema.IsEnumeration = "false";
 _newSchema.IsAddInPrimaryKey = "false";
 _newSchema.IsExcludedFromReset = "false";
 _newSchema.IsMember = "false";
 _newSchema.AddInTableName = "";


 _newObject.IsCacheable = "false";

 _newObject.AllowZeroKeys = "false";
 _newObject.TransactionMode = "Required";
 _newObject.IsStoredProcedure = "false";
 _newObject.ProcedureReturnType = "";
 _newFieldList.Add(_newSchema);

 
 _newPersistantObjectList.Add(_newObject);
 _newPObject.PersistentObject.AddRange(_newPersistantObjectList);
 
 schemeContent.Text = HelperXml.ToXML(_newPObject);


Example 1.1



 <?xml version="1.0" encoding="utf-8"?>
 <ObjectStore xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns="urn:SageObjectStore">
 <ApplicationNamespace>BusinessObjects</ApplicationNamespace>
 <MemberVariablePrefix>_</MemberVariablePrefix>
 <ClassPrefix>Persistent</ClassPrefix>
 <ClassSuffix />
 <Language>VB</Language>
 <Path>C:Sage200SchemaExtensions</Path>
 <GenerateBusinessObjects>false</GenerateBusinessObjects>
 <GenerateSeparateFiles>false</GenerateSeparateFiles>
 <PersistentObjects>
 <PersistentObject Name="Customer">
 <TableName>SLCustomerAccount</TableName>
 <Description />
 <Fields>
 <Field Name="SLCustomerAccountID">
 <DbType>Int64</DbType>
 <Precision>19</Precision>
 <Scale>0</Scale>
 <FillType>None</FillType>
 <IsNullable>false</IsNullable>
 <IsReadOnly>true</IsReadOnly>
 <AllowOverwrite>Equal</AllowOverwrite>
 <IsPrimaryKey>true</IsPrimaryKey>
 <IsDeltaField>false</IsDeltaField>
 <IsIndexed>true</IsIndexed>
 <IsTransient>false</IsTransient>
 <IsUnique>true</IsUnique>
 <OverrideFormatting>false</OverrideFormatting>
 <IsLockable>false</IsLockable>
 <Direction>Input</Direction>
 <ValueSetByDatabase>false</ValueSetByDatabase>
 <FormatScale>0</FormatScale>
 <FormatMask>9999999999999999999</FormatMask>
 <NegativeFormatting>Standard</NegativeFormatting>
 <Group>false</Group>
 <AggregateFunction>None</AggregateFunction>
 <IsExcludedFromCopy>false</IsExcludedFromCopy>
 <IsExpression>false</IsExpression>
 <FriendlyName>SLCustomer Account ID</FriendlyName>
 <IsBrowsable>true</IsBrowsable>
 <IsQueryable>true</IsQueryable>
 <IsEnumeration>false</IsEnumeration>
 <IsAddInPrimaryKey>false</IsAddInPrimaryKey>
 <AddInTableName />
 <AddInRelationField />
 <IsMember>false</IsMember>
 <IsExcludedFromReset>false</IsExcludedFromReset>
 </Field>
 </Fields>
 <IsCacheable>false</IsCacheable>
 <AllowZeroKeys>false</AllowZeroKeys>
 <AlwaysAllowPaging>false</AlwaysAllowPaging>
 <Namespace>SalesLedger</Namespace>
 <PagingFields />
 <TransactionMode>Required</TransactionMode>
 <IsStoredProcedure>false</IsStoredProcedure>
 <ProcedureReturnType />
 </PersistentObject>
 <PersistentObject Name="MCSSopOrderss">
 <TableName />
 <Description />
 <Fields>
 <Field Name="CustomerID">
 <DbType>Int64</DbType>
 <Precision>11</Precision>
 <Scale>0</Scale>
 <FillType>None</FillType>
 <IsNullable>true</IsNullable>
 <IsReadOnly>false</IsReadOnly>
 <AllowOverwrite>True</AllowOverwrite>
 <IsPrimaryKey>false</IsPrimaryKey>
 <IsDeltaField>false</IsDeltaField>
 <IsIndexed>false</IsIndexed>
 <IsTransient>false</IsTransient>
 <IsUnique>false</IsUnique>
 <OverrideFormatting>false</OverrideFormatting>
 <IsLockable>false</IsLockable>
 <Direction>Input</Direction>
 <ValueSetByDatabase>false</ValueSetByDatabase>
 <FormatScale>0</FormatScale>
 <FormatMask>99999999999</FormatMask>
 <NegativeFormatting>Standard</NegativeFormatting>
 <Group>false</Group>
 <AggregateFunction>None</AggregateFunction>
 <IsExcludedFromCopy>false</IsExcludedFromCopy>



 <IsExpression>false</IsExpression>
 <FriendlyName>Customer ID</FriendlyName>
 <IsBrowsable>true</IsBrowsable>
 <IsQueryable>true</IsQueryable>
 <IsEnumeration>false</IsEnumeration>
 <IsAddInPrimaryKey>false</IsAddInPrimaryKey>
 <AddInTableName />
 <AddInRelationField />
 <IsMember>false</IsMember>
 <IsExcludedFromReset>false</IsExcludedFromReset>
 </Field>
 <Field Name="TestDate">
 <DbType>Date</DbType>
 <Precision>3</Precision>
 <Scale>0</Scale>
 <FillType>None</FillType>
 <IsNullable>true</IsNullable>
 <IsReadOnly>false</IsReadOnly>
 <AllowOverwrite>True</AllowOverwrite>
 <IsPrimaryKey>false</IsPrimaryKey>
 <IsDeltaField>false</IsDeltaField>
 <IsIndexed>false</IsIndexed>
 <IsTransient>false</IsTransient>
 <IsUnique>false</IsUnique>
 <OverrideFormatting>false</OverrideFormatting>
 <IsLockable>false</IsLockable>
 <Direction>Input</Direction>
 <ValueSetByDatabase>false</ValueSetByDatabase>
 <FormatScale>0</FormatScale>
 <FormatMask>99/99/9999</FormatMask>
 <NegativeFormatting>Standard</NegativeFormatting>
 <Group>false</Group>
 <AggregateFunction>None</AggregateFunction>
 <IsExcludedFromCopy>false</IsExcludedFromCopy>
 <IsExpression>false</IsExpression>
 <FriendlyName>test</FriendlyName>
 <IsBrowsable>true</IsBrowsable>
 <IsQueryable>true</IsQueryable>
 <IsEnumeration>false</IsEnumeration>
 <IsAddInPrimaryKey>false</IsAddInPrimaryKey>
 <AddInTableName />
 <AddInRelationField />
 <IsMember>false</IsMember>
 <IsExcludedFromReset>false</IsExcludedFromReset>
 </Field>
 <Field Name="TestString">
 <DbType>String</DbType>
 <Precision>64</Precision>
 <Scale>2</Scale>
 <FillType>None</FillType>
 <IsNullable>false</IsNullable>
 <IsReadOnly>false</IsReadOnly>
 <AllowOverwrite>True</AllowOverwrite>
 <IsPrimaryKey>false</IsPrimaryKey>
 <IsDeltaField>false</IsDeltaField>
 <IsIndexed>false</IsIndexed>
 <IsTransient>false</IsTransient>
 <IsUnique>false</IsUnique>
 <OverrideFormatting>false</OverrideFormatting>
 <IsLockable>false</IsLockable>
 <Direction>Input</Direction>
 <ValueSetByDatabase>false</ValueSetByDatabase>
 <FormatScale>2</FormatScale>
 <NegativeFormatting>Standard</NegativeFormatting>
 <Group>false</Group>
 <AggregateFunction>None</AggregateFunction>
 <IsExcludedFromCopy>false</IsExcludedFromCopy>
 <IsExpression>false</IsExpression>
 <FriendlyName>Test String</FriendlyName>
 <IsBrowsable>true</IsBrowsable>
 <IsQueryable>true</IsQueryable>
 <IsEnumeration>false</IsEnumeration>
 <IsAddInPrimaryKey>false</IsAddInPrimaryKey>
 <AddInTableName />
 <AddInRelationField />
 <IsMember>false</IsMember>
 <IsExcludedFromReset>false</IsExcludedFromReset>
 </Field>
 <Field Name="TestMoney">
 <UserDataType>MonetaryValue2dp</UserDataType>
 <DbType>String</DbType>
 <Precision>12</Precision>
 <Scale>2</Scale>
 <FillType>None</FillType>
 <IsNullable>false</IsNullable>
 <IsReadOnly>false</IsReadOnly>
 <AllowOverwrite>True</AllowOverwrite>
 <IsPrimaryKey>false</IsPrimaryKey>
 <IsDeltaField>false</IsDeltaField>
 <IsIndexed>false</IsIndexed>
 <IsTransient>false</IsTransient>
 <IsUnique>false</IsUnique>
 <OverrideFormatting>false</OverrideFormatting>
 <IsLockable>false</IsLockable>
 <Direction>Input</Direction>
 <ValueSetByDatabase>false</ValueSetByDatabase>
 <FormatScale>2</FormatScale>
 <NegativeFormatting>Standard</NegativeFormatting>
 <Group>false</Group>
 <AggregateFunction>None</AggregateFunction>
 <IsExcludedFromCopy>false</IsExcludedFromCopy>
 <IsExpression>false</IsExpression>
 <FriendlyName>Test Money</FriendlyName>
 <IsBrowsable>true</IsBrowsable>
 <IsQueryable>true</IsQueryable>
 <IsEnumeration>false</IsEnumeration>
 <IsAddInPrimaryKey>false</IsAddInPrimaryKey>
 <AddInTableName />
 <AddInRelationField />
 <IsMember>false</IsMember>
 <IsExcludedFromReset>false</IsExcludedFromReset>
 </Field>
 <Field Name="TestDecimal">
 <DbType>Decimal</DbType>
 <Precision>18</Precision>
 <Scale>0</Scale>
 <FillType>None</FillType>
 <IsNullable>false</IsNullable>
 <IsReadOnly>false</IsReadOnly>
 <AllowOverwrite>True</AllowOverwrite>
 <IsPrimaryKey>false</IsPrimaryKey>
 <IsDeltaField>false</IsDeltaField>
 <IsIndexed>false</IsIndexed>
 <IsTransient>false</IsTransient>
 <IsUnique>false</IsUnique>
 <OverrideFormatting>false</OverrideFormatting>
 <IsLockable>false</IsLockable>
 <Direction>Input</Direction>
 <ValueSetByDatabase>false</ValueSetByDatabase>
 <FormatScale>0</FormatScale>
 <FormatMask>999999999999999999.</FormatMask>
 <NegativeFormatting>Standard</NegativeFormatting>
 <Group>false</Group>
 <AggregateFunction>None</AggregateFunction>
 <IsExcludedFromCopy>false</IsExcludedFromCopy>
 <IsExpression>false</IsExpression>
 <FriendlyName>Test Decimal</FriendlyName>
 <IsBrowsable>true</IsBrowsable>
 <IsQueryable>true</IsQueryable>
 <IsEnumeration>false</IsEnumeration>
 <IsAddInPrimaryKey>false</IsAddInPrimaryKey>
 <AddInTableName />
 <AddInRelationField />
 <IsMember>false</IsMember>
 <IsExcludedFromReset>false</IsExcludedFromReset>
 </Field>
 <Field Name="TestCurrency">
 <DbType>Currency</DbType>
 <Precision>11</Precision>
 <Scale>2</Scale>
 <FillType>None</FillType>
 <IsNullable>false</IsNullable>
 <IsReadOnly>false</IsReadOnly>
 <AllowOverwrite>True</AllowOverwrite>
 <IsPrimaryKey>false</IsPrimaryKey>
 <IsDeltaField>false</IsDeltaField>
 <IsIndexed>false</IsIndexed>
 <IsTransient>false</IsTransient>
 <IsUnique>false</IsUnique>
 <OverrideFormatting>false</OverrideFormatting>
 <IsLockable>false</IsLockable>
 <Direction>Input</Direction>
 <ValueSetByDatabase>false</ValueSetByDatabase>
 <FormatScale>2</FormatScale>
 <FormatMask>99999999999.99</FormatMask>
 <NegativeFormatting>Standard</NegativeFormatting>
 <Group>false</Group>
 <AggregateFunction>None</AggregateFunction>
 <IsExcludedFromCopy>false</IsExcludedFromCopy>
 <IsExpression>false</IsExpression>
 <FriendlyName>Test Currency</FriendlyName>
 <IsBrowsable>true</IsBrowsable>
 <IsQueryable>true</IsQueryable>
 <IsEnumeration>false</IsEnumeration>
 <IsAddInPrimaryKey>false</IsAddInPrimaryKey>
 <AddInTableName />
 <AddInRelationField />
 <IsMember>false</IsMember>
 <IsExcludedFromReset>false</IsExcludedFromReset>
 </Field>
 <Field Name="Test">
 <DbType>String</DbType>
 <Precision>64</Precision>
 <Scale>2</Scale>
 <FillType>None</FillType>
 <IsNullable>false</IsNullable>
 <IsReadOnly>false</IsReadOnly>
 <AllowOverwrite>True</AllowOverwrite>
 <IsPrimaryKey>false</IsPrimaryKey>
 <IsDeltaField>false</IsDeltaField>
 <IsIndexed>false</IsIndexed>
 <IsTransient>false</IsTransient>
 <IsUnique>false</IsUnique>
 <OverrideFormatting>false</OverrideFormatting>
 <IsLockable>false</IsLockable>
 <Direction>Input</Direction>
 <ValueSetByDatabase>false</ValueSetByDatabase>
 <FormatScale>2</FormatScale>
 <NegativeFormatting>Standard</NegativeFormatting>
 <Group>false</Group>
 <AggregateFunction>None</AggregateFunction>
 <IsExcludedFromCopy>false</IsExcludedFromCopy>
 <IsExpression>false</IsExpression>
 <FriendlyName>Test</FriendlyName>
 <IsBrowsable>true</IsBrowsable>
 <IsQueryable>true</IsQueryable>
 <IsEnumeration>false</IsEnumeration>
 <IsAddInPrimaryKey>false</IsAddInPrimaryKey>
 <AddInTableName />
 <AddInRelationField />
 <IsMember>false</IsMember>
 <IsExcludedFromReset>false</IsExcludedFromReset>
 </Field>
 </Fields>
 <IsCacheable>false</IsCacheable>
 <AllowZeroKeys>false</AllowZeroKeys>
 <AlwaysAllowPaging>false</AlwaysAllowPaging>
 <Namespace />
 <PagingFields />
 <TransactionMode>Required</TransactionMode>
 <IsStoredProcedure>false</IsStoredProcedure>
 <ProcedureReturnType />
 </PersistentObject>
 </PersistentObjects>
 <Relationships>
 <Relationship>
 <ParentObject>Customer</ParentObject>
 <ParentKey>SLCustomerAccountID</ParentKey>
 <ChildObject>MCSSopOrderss</ChildObject>
 <ChildKey>CustomerID</ChildKey>
 <InsertOperation>CheckParentExists</InsertOperation>
 <DeleteOperation>CheckForAnyChildren</DeleteOperation>
 <IsOneToMany>true</IsOneToMany>

 </Relationship>
 </Relationships>
 <DataTypes />
 <Enumerations />
 <BaselineSchema>C:Program Files (x86)Sage 200 
 SDKSageObjectStore.xml</BaselineSchema>
 </ObjectStore>


However what I am getting is the following For that table there is 44 objects in the field list list so for fields it should be printing that and as you can see its ignorning the name property i am setting on persitent object as well.



 <?xml version="1.0" encoding="utf-16"?>
 <ObjectStore xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema">
 <PersistentObjects>
 <PersistentObject>
 <Fields />
 <IsCacheable>false</IsCacheable>
 <AllowZeroKeys>false</AllowZeroKeys>
 <TransactionMode>Required</TransactionMode>
 <ProcedureReturnType />
 <IsStoredProcedure>false</IsStoredProcedure>
 </PersistentObject>
 </PersistentObjects>
 <PersistentObject>
 <PersistentObject>
 <Fields />
 <IsCacheable>false</IsCacheable>
 <AllowZeroKeys>false</AllowZeroKeys>
 <TransactionMode>Required</TransactionMode>
 <ProcedureReturnType />
 <IsStoredProcedure>false</IsStoredProcedure>
 </PersistentObject>
 </PersistentObject>
 </ObjectStore>


My Class for the above.



 public class SageXmlDefiniation
 
 public class ObjectStore

 
 public List<PersistentObject> PersistentObjects = new 
 List<PersistentObject>();
 public string ApplicationnameSpace get; set; 
 public string MemberVariablePrefix get; set; 
 public string ClassPrefix get; set; 
 public string ClassSuffix get; set; 
 public string Language get; set; 
 public string Path get; set; 
 public string GenerateBusinessObjects get; set; 
 public string GenerateSeparateFiles get; set; 

 public List<PersistentObject> PersistentObject
 
 get return PersistentObjects; 
 set PersistentObjects = value; 
 

 
 public class PersistentObject
 
 private List<FieldSchemaXml> _Fields = new List<FieldSchemaXml>();

 [XmlAttribute("Name")]
 public string Name get; set; 

 public string TableName get; set; 
 public string Description get; set; 
 [XmlArray("Fields")]
 [XmlArrayItem("Field")]
 public List<FieldSchemaXml> FieldsList
 
 get return _Fields; 
 set _Fields = value; 
 
 public string IsCacheable get; set; 
 public string AllowZeroKeys get; set; 
 public string NameSapce get; set; 

 public string PagingFields get; set; 
 public string TransactionMode get; set; 
 public string ProcedureReturnType get; set; 
 public string IsStoredProcedure get; set; 
 
 public class FieldSchemaXml
 
 [XmlAttribute("Name")]
 public string Name get; set; 

 public string DBType get; set; 
 public string Precision get; set; 
 public string Scale get; set; 
 public string FillType get; set; 
 public string IsNullable get; set; 
 public string IsReadOnly get; set; 
 public string AllowOverwrite get; set; 
 public string IsPrimaryKey get; set; 

 public string IsDeltaField get; set; 
 public string IsIndexed get; set; 
 public string IsTransient get; set; 
 public string IsUnique get; set; 

 public string OverrideFormatting get; set; 
 public string IsLockable get; set; 
 public string Direction get; set; 
 public string ValueSetByDatabase get; set; 
 public string FormatScale get; set; 
 public string FormatMask get; set; 
 public string NegativeFormatting get; set; 
 public string Group get; set; 
 public string AggregateFunction get; set; 
 public string IsExcludedFromCopy get; set; 
 public string IsExpression get; set; 
 public string FriendlyName get; set; 
 public string IsBrowsable get; set; 
 public string IsQueryable get; set; 
 public string IsEnumeration get; set; 

 public string IsAddInPrimaryKey get; set; 
 public string AddInTableName get; set; 
 public string AddInRelationField get; set; 
 public string IsMember get; set; 
 public string IsExcludedFromReset get; set;


My code which returns correct 44 fields for the above table.



public List<TableDefnition> GetALLTableDeiniations(string tableName)

 string sql = @"SELECT c.name Field, 
t.name Type,
c.max_length MaxLength,
c.Precision, 
c.Scale,
c.is_nullable,
c.collation_name
FROM sys.columns c
INNER JOIN sys.types t ON t.system_type_id = c.system_type_id
WHERE object_id = object_id('"+ tableName + "') ORDER BY column_id";

using (var connection = new 
sqlConnection(ConfigurationManager.AppSettings["ConnectionString"]))

 List<TableDefnition> _tableDefnitions = connection.Query<TableDefnition>(sql).ToList();
 return _tableDefnitions;







c# xml xml-serialization







share|improve this question






















  • I don't see anywhere you set a Name on PersistentObject (which is _newObject). I don't see anywhere you set or add to the FieldsList either.

    – Charles Mager
    Mar 24 at 18:22


















0















I am trying to build a schema xml using the following but I am having issues items our being repeated twice and the fields are not being populated.



Basically what happens is the program goes out to sql gets the columns names of the chosen tables then it should produce a schema simlar to as follows not identically in term of values but yes in terms of structure



 public List<TableNames> _tablesNamesList = new List<TableNames>();

 public void BuildSchema()
 

 foreach (var table in _tablesNamesList)
 
 PersistentObject _newObject = new PersistentObject();
 List<PersistentObject> _newPersistantObjectList = new List<PersistentObject>();

 List<TableDefnition> _newList = db.GetALLTableDeiniations(table.TABLE_NAME);

 List<FieldSchemaXml> _newFieldList = new List<FieldSchemaXml>();


 foreach (var item in _newList)
 

 FieldSchemaXml _newSchema = new FieldSchemaXml();


 _newSchema = ConvertSQLDataTypeToSage(item.Type, _newSchema, item);


 _newSchema.Name = item.Field;
 _newSchema.IsUnique = "false";
 _newSchema.IsReadOnly = "false";
 _newSchema.IsQueryable = "true";
 if (item.is_nullable == 1)
 

 _newSchema.IsNullable = "true";
 
 else
 
 _newSchema.IsNullable = "false";
 

 _newSchema.IsReadOnly = "false";
 _newSchema.IsUnique = "false";
 _newSchema.Group = "false";

 _newSchema.IsLockable = "false";
 _newSchema.IsDeltaField = "false";
 _newSchema.IsPrimaryKey = "false";
 _newSchema.FillType = "None";
 _newSchema.Direction = "Input";
 _newSchema.OverrideFormatting = "false";
 _newSchema.ValueSetByDatabase = "false";
 _newSchema.FormatScale = "0";
 _newSchema.NegativeFormatting = "Standard";
 _newSchema.AggregateFunction = "false";
 _newSchema.IsExpression = "false";
 _newSchema.IsBrowsable = "true";
 _newSchema.IsQueryable = "true";
 _newSchema.IsEnumeration = "false";
 _newSchema.IsAddInPrimaryKey = "false";
 _newSchema.IsExcludedFromReset = "false";
 _newSchema.IsMember = "false";
 _newSchema.AddInTableName = "";


 _newObject.IsCacheable = "false";

 _newObject.AllowZeroKeys = "false";
 _newObject.TransactionMode = "Required";
 _newObject.IsStoredProcedure = "false";
 _newObject.ProcedureReturnType = "";
 _newFieldList.Add(_newSchema);

 
 _newPersistantObjectList.Add(_newObject);
 _newPObject.PersistentObject.AddRange(_newPersistantObjectList);
 
 schemeContent.Text = HelperXml.ToXML(_newPObject);


Example 1.1



 <?xml version="1.0" encoding="utf-8"?>
 <ObjectStore xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns="urn:SageObjectStore">
 <ApplicationNamespace>BusinessObjects</ApplicationNamespace>
 <MemberVariablePrefix>_</MemberVariablePrefix>
 <ClassPrefix>Persistent</ClassPrefix>
 <ClassSuffix />
 <Language>VB</Language>
 <Path>C:Sage200SchemaExtensions</Path>
 <GenerateBusinessObjects>false</GenerateBusinessObjects>
 <GenerateSeparateFiles>false</GenerateSeparateFiles>
 <PersistentObjects>
 <PersistentObject Name="Customer">
 <TableName>SLCustomerAccount</TableName>
 <Description />
 <Fields>
 <Field Name="SLCustomerAccountID">
 <DbType>Int64</DbType>
 <Precision>19</Precision>
 <Scale>0</Scale>
 <FillType>None</FillType>
 <IsNullable>false</IsNullable>
 <IsReadOnly>true</IsReadOnly>
 <AllowOverwrite>Equal</AllowOverwrite>
 <IsPrimaryKey>true</IsPrimaryKey>
 <IsDeltaField>false</IsDeltaField>
 <IsIndexed>true</IsIndexed>
 <IsTransient>false</IsTransient>
 <IsUnique>true</IsUnique>
 <OverrideFormatting>false</OverrideFormatting>
 <IsLockable>false</IsLockable>
 <Direction>Input</Direction>
 <ValueSetByDatabase>false</ValueSetByDatabase>
 <FormatScale>0</FormatScale>
 <FormatMask>9999999999999999999</FormatMask>
 <NegativeFormatting>Standard</NegativeFormatting>
 <Group>false</Group>
 <AggregateFunction>None</AggregateFunction>
 <IsExcludedFromCopy>false</IsExcludedFromCopy>
 <IsExpression>false</IsExpression>
 <FriendlyName>SLCustomer Account ID</FriendlyName>
 <IsBrowsable>true</IsBrowsable>
 <IsQueryable>true</IsQueryable>
 <IsEnumeration>false</IsEnumeration>
 <IsAddInPrimaryKey>false</IsAddInPrimaryKey>
 <AddInTableName />
 <AddInRelationField />
 <IsMember>false</IsMember>
 <IsExcludedFromReset>false</IsExcludedFromReset>
 </Field>
 </Fields>
 <IsCacheable>false</IsCacheable>
 <AllowZeroKeys>false</AllowZeroKeys>
 <AlwaysAllowPaging>false</AlwaysAllowPaging>
 <Namespace>SalesLedger</Namespace>
 <PagingFields />
 <TransactionMode>Required</TransactionMode>
 <IsStoredProcedure>false</IsStoredProcedure>
 <ProcedureReturnType />
 </PersistentObject>
 <PersistentObject Name="MCSSopOrderss">
 <TableName />
 <Description />
 <Fields>
 <Field Name="CustomerID">
 <DbType>Int64</DbType>
 <Precision>11</Precision>
 <Scale>0</Scale>
 <FillType>None</FillType>
 <IsNullable>true</IsNullable>
 <IsReadOnly>false</IsReadOnly>
 <AllowOverwrite>True</AllowOverwrite>
 <IsPrimaryKey>false</IsPrimaryKey>
 <IsDeltaField>false</IsDeltaField>
 <IsIndexed>false</IsIndexed>
 <IsTransient>false</IsTransient>
 <IsUnique>false</IsUnique>
 <OverrideFormatting>false</OverrideFormatting>
 <IsLockable>false</IsLockable>
 <Direction>Input</Direction>
 <ValueSetByDatabase>false</ValueSetByDatabase>
 <FormatScale>0</FormatScale>
 <FormatMask>99999999999</FormatMask>
 <NegativeFormatting>Standard</NegativeFormatting>
 <Group>false</Group>
 <AggregateFunction>None</AggregateFunction>
 <IsExcludedFromCopy>false</IsExcludedFromCopy>



 <IsExpression>false</IsExpression>
 <FriendlyName>Customer ID</FriendlyName>
 <IsBrowsable>true</IsBrowsable>
 <IsQueryable>true</IsQueryable>
 <IsEnumeration>false</IsEnumeration>
 <IsAddInPrimaryKey>false</IsAddInPrimaryKey>
 <AddInTableName />
 <AddInRelationField />
 <IsMember>false</IsMember>
 <IsExcludedFromReset>false</IsExcludedFromReset>
 </Field>
 <Field Name="TestDate">
 <DbType>Date</DbType>
 <Precision>3</Precision>
 <Scale>0</Scale>
 <FillType>None</FillType>
 <IsNullable>true</IsNullable>
 <IsReadOnly>false</IsReadOnly>
 <AllowOverwrite>True</AllowOverwrite>
 <IsPrimaryKey>false</IsPrimaryKey>
 <IsDeltaField>false</IsDeltaField>
 <IsIndexed>false</IsIndexed>
 <IsTransient>false</IsTransient>
 <IsUnique>false</IsUnique>
 <OverrideFormatting>false</OverrideFormatting>
 <IsLockable>false</IsLockable>
 <Direction>Input</Direction>
 <ValueSetByDatabase>false</ValueSetByDatabase>
 <FormatScale>0</FormatScale>
 <FormatMask>99/99/9999</FormatMask>
 <NegativeFormatting>Standard</NegativeFormatting>
 <Group>false</Group>
 <AggregateFunction>None</AggregateFunction>
 <IsExcludedFromCopy>false</IsExcludedFromCopy>
 <IsExpression>false</IsExpression>
 <FriendlyName>test</FriendlyName>
 <IsBrowsable>true</IsBrowsable>
 <IsQueryable>true</IsQueryable>
 <IsEnumeration>false</IsEnumeration>
 <IsAddInPrimaryKey>false</IsAddInPrimaryKey>
 <AddInTableName />
 <AddInRelationField />
 <IsMember>false</IsMember>
 <IsExcludedFromReset>false</IsExcludedFromReset>
 </Field>
 <Field Name="TestString">
 <DbType>String</DbType>
 <Precision>64</Precision>
 <Scale>2</Scale>
 <FillType>None</FillType>
 <IsNullable>false</IsNullable>
 <IsReadOnly>false</IsReadOnly>
 <AllowOverwrite>True</AllowOverwrite>
 <IsPrimaryKey>false</IsPrimaryKey>
 <IsDeltaField>false</IsDeltaField>
 <IsIndexed>false</IsIndexed>
 <IsTransient>false</IsTransient>
 <IsUnique>false</IsUnique>
 <OverrideFormatting>false</OverrideFormatting>
 <IsLockable>false</IsLockable>
 <Direction>Input</Direction>
 <ValueSetByDatabase>false</ValueSetByDatabase>
 <FormatScale>2</FormatScale>
 <NegativeFormatting>Standard</NegativeFormatting>
 <Group>false</Group>
 <AggregateFunction>None</AggregateFunction>
 <IsExcludedFromCopy>false</IsExcludedFromCopy>
 <IsExpression>false</IsExpression>
 <FriendlyName>Test String</FriendlyName>
 <IsBrowsable>true</IsBrowsable>
 <IsQueryable>true</IsQueryable>
 <IsEnumeration>false</IsEnumeration>
 <IsAddInPrimaryKey>false</IsAddInPrimaryKey>
 <AddInTableName />
 <AddInRelationField />
 <IsMember>false</IsMember>
 <IsExcludedFromReset>false</IsExcludedFromReset>
 </Field>
 <Field Name="TestMoney">
 <UserDataType>MonetaryValue2dp</UserDataType>
 <DbType>String</DbType>
 <Precision>12</Precision>
 <Scale>2</Scale>
 <FillType>None</FillType>
 <IsNullable>false</IsNullable>
 <IsReadOnly>false</IsReadOnly>
 <AllowOverwrite>True</AllowOverwrite>
 <IsPrimaryKey>false</IsPrimaryKey>
 <IsDeltaField>false</IsDeltaField>
 <IsIndexed>false</IsIndexed>
 <IsTransient>false</IsTransient>
 <IsUnique>false</IsUnique>
 <OverrideFormatting>false</OverrideFormatting>
 <IsLockable>false</IsLockable>
 <Direction>Input</Direction>
 <ValueSetByDatabase>false</ValueSetByDatabase>
 <FormatScale>2</FormatScale>
 <NegativeFormatting>Standard</NegativeFormatting>
 <Group>false</Group>
 <AggregateFunction>None</AggregateFunction>
 <IsExcludedFromCopy>false</IsExcludedFromCopy>
 <IsExpression>false</IsExpression>
 <FriendlyName>Test Money</FriendlyName>
 <IsBrowsable>true</IsBrowsable>
 <IsQueryable>true</IsQueryable>
 <IsEnumeration>false</IsEnumeration>
 <IsAddInPrimaryKey>false</IsAddInPrimaryKey>
 <AddInTableName />
 <AddInRelationField />
 <IsMember>false</IsMember>
 <IsExcludedFromReset>false</IsExcludedFromReset>
 </Field>
 <Field Name="TestDecimal">
 <DbType>Decimal</DbType>
 <Precision>18</Precision>
 <Scale>0</Scale>
 <FillType>None</FillType>
 <IsNullable>false</IsNullable>
 <IsReadOnly>false</IsReadOnly>
 <AllowOverwrite>True</AllowOverwrite>
 <IsPrimaryKey>false</IsPrimaryKey>
 <IsDeltaField>false</IsDeltaField>
 <IsIndexed>false</IsIndexed>
 <IsTransient>false</IsTransient>
 <IsUnique>false</IsUnique>
 <OverrideFormatting>false</OverrideFormatting>
 <IsLockable>false</IsLockable>
 <Direction>Input</Direction>
 <ValueSetByDatabase>false</ValueSetByDatabase>
 <FormatScale>0</FormatScale>
 <FormatMask>999999999999999999.</FormatMask>
 <NegativeFormatting>Standard</NegativeFormatting>
 <Group>false</Group>
 <AggregateFunction>None</AggregateFunction>
 <IsExcludedFromCopy>false</IsExcludedFromCopy>
 <IsExpression>false</IsExpression>
 <FriendlyName>Test Decimal</FriendlyName>
 <IsBrowsable>true</IsBrowsable>
 <IsQueryable>true</IsQueryable>
 <IsEnumeration>false</IsEnumeration>
 <IsAddInPrimaryKey>false</IsAddInPrimaryKey>
 <AddInTableName />
 <AddInRelationField />
 <IsMember>false</IsMember>
 <IsExcludedFromReset>false</IsExcludedFromReset>
 </Field>
 <Field Name="TestCurrency">
 <DbType>Currency</DbType>
 <Precision>11</Precision>
 <Scale>2</Scale>
 <FillType>None</FillType>
 <IsNullable>false</IsNullable>
 <IsReadOnly>false</IsReadOnly>
 <AllowOverwrite>True</AllowOverwrite>
 <IsPrimaryKey>false</IsPrimaryKey>
 <IsDeltaField>false</IsDeltaField>
 <IsIndexed>false</IsIndexed>
 <IsTransient>false</IsTransient>
 <IsUnique>false</IsUnique>
 <OverrideFormatting>false</OverrideFormatting>
 <IsLockable>false</IsLockable>
 <Direction>Input</Direction>
 <ValueSetByDatabase>false</ValueSetByDatabase>
 <FormatScale>2</FormatScale>
 <FormatMask>99999999999.99</FormatMask>
 <NegativeFormatting>Standard</NegativeFormatting>
 <Group>false</Group>
 <AggregateFunction>None</AggregateFunction>
 <IsExcludedFromCopy>false</IsExcludedFromCopy>
 <IsExpression>false</IsExpression>
 <FriendlyName>Test Currency</FriendlyName>
 <IsBrowsable>true</IsBrowsable>
 <IsQueryable>true</IsQueryable>
 <IsEnumeration>false</IsEnumeration>
 <IsAddInPrimaryKey>false</IsAddInPrimaryKey>
 <AddInTableName />
 <AddInRelationField />
 <IsMember>false</IsMember>
 <IsExcludedFromReset>false</IsExcludedFromReset>
 </Field>
 <Field Name="Test">
 <DbType>String</DbType>
 <Precision>64</Precision>
 <Scale>2</Scale>
 <FillType>None</FillType>
 <IsNullable>false</IsNullable>
 <IsReadOnly>false</IsReadOnly>
 <AllowOverwrite>True</AllowOverwrite>
 <IsPrimaryKey>false</IsPrimaryKey>
 <IsDeltaField>false</IsDeltaField>
 <IsIndexed>false</IsIndexed>
 <IsTransient>false</IsTransient>
 <IsUnique>false</IsUnique>
 <OverrideFormatting>false</OverrideFormatting>
 <IsLockable>false</IsLockable>
 <Direction>Input</Direction>
 <ValueSetByDatabase>false</ValueSetByDatabase>
 <FormatScale>2</FormatScale>
 <NegativeFormatting>Standard</NegativeFormatting>
 <Group>false</Group>
 <AggregateFunction>None</AggregateFunction>
 <IsExcludedFromCopy>false</IsExcludedFromCopy>
 <IsExpression>false</IsExpression>
 <FriendlyName>Test</FriendlyName>
 <IsBrowsable>true</IsBrowsable>
 <IsQueryable>true</IsQueryable>
 <IsEnumeration>false</IsEnumeration>
 <IsAddInPrimaryKey>false</IsAddInPrimaryKey>
 <AddInTableName />
 <AddInRelationField />
 <IsMember>false</IsMember>
 <IsExcludedFromReset>false</IsExcludedFromReset>
 </Field>
 </Fields>
 <IsCacheable>false</IsCacheable>
 <AllowZeroKeys>false</AllowZeroKeys>
 <AlwaysAllowPaging>false</AlwaysAllowPaging>
 <Namespace />
 <PagingFields />
 <TransactionMode>Required</TransactionMode>
 <IsStoredProcedure>false</IsStoredProcedure>
 <ProcedureReturnType />
 </PersistentObject>
 </PersistentObjects>
 <Relationships>
 <Relationship>
 <ParentObject>Customer</ParentObject>
 <ParentKey>SLCustomerAccountID</ParentKey>
 <ChildObject>MCSSopOrderss</ChildObject>
 <ChildKey>CustomerID</ChildKey>
 <InsertOperation>CheckParentExists</InsertOperation>
 <DeleteOperation>CheckForAnyChildren</DeleteOperation>
 <IsOneToMany>true</IsOneToMany>

 </Relationship>
 </Relationships>
 <DataTypes />
 <Enumerations />
 <BaselineSchema>C:Program Files (x86)Sage 200 
 SDKSageObjectStore.xml</BaselineSchema>
 </ObjectStore>


However what I am getting is the following For that table there is 44 objects in the field list list so for fields it should be printing that and as you can see its ignorning the name property i am setting on persitent object as well.



 <?xml version="1.0" encoding="utf-16"?>
 <ObjectStore xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema">
 <PersistentObjects>
 <PersistentObject>
 <Fields />
 <IsCacheable>false</IsCacheable>
 <AllowZeroKeys>false</AllowZeroKeys>
 <TransactionMode>Required</TransactionMode>
 <ProcedureReturnType />
 <IsStoredProcedure>false</IsStoredProcedure>
 </PersistentObject>
 </PersistentObjects>
 <PersistentObject>
 <PersistentObject>
 <Fields />
 <IsCacheable>false</IsCacheable>
 <AllowZeroKeys>false</AllowZeroKeys>
 <TransactionMode>Required</TransactionMode>
 <ProcedureReturnType />
 <IsStoredProcedure>false</IsStoredProcedure>
 </PersistentObject>
 </PersistentObject>
 </ObjectStore>


My Class for the above.



 public class SageXmlDefiniation
 
 public class ObjectStore

 
 public List<PersistentObject> PersistentObjects = new 
 List<PersistentObject>();
 public string ApplicationnameSpace get; set; 
 public string MemberVariablePrefix get; set; 
 public string ClassPrefix get; set; 
 public string ClassSuffix get; set; 
 public string Language get; set; 
 public string Path get; set; 
 public string GenerateBusinessObjects get; set; 
 public string GenerateSeparateFiles get; set; 

 public List<PersistentObject> PersistentObject
 
 get return PersistentObjects; 
 set PersistentObjects = value; 
 

 
 public class PersistentObject
 
 private List<FieldSchemaXml> _Fields = new List<FieldSchemaXml>();

 [XmlAttribute("Name")]
 public string Name get; set; 

 public string TableName get; set; 
 public string Description get; set; 
 [XmlArray("Fields")]
 [XmlArrayItem("Field")]
 public List<FieldSchemaXml> FieldsList
 
 get return _Fields; 
 set _Fields = value; 
 
 public string IsCacheable get; set; 
 public string AllowZeroKeys get; set; 
 public string NameSapce get; set; 

 public string PagingFields get; set; 
 public string TransactionMode get; set; 
 public string ProcedureReturnType get; set; 
 public string IsStoredProcedure get; set; 
 
 public class FieldSchemaXml
 
 [XmlAttribute("Name")]
 public string Name get; set; 

 public string DBType get; set; 
 public string Precision get; set; 
 public string Scale get; set; 
 public string FillType get; set; 
 public string IsNullable get; set; 
 public string IsReadOnly get; set; 
 public string AllowOverwrite get; set; 
 public string IsPrimaryKey get; set; 

 public string IsDeltaField get; set; 
 public string IsIndexed get; set; 
 public string IsTransient get; set; 
 public string IsUnique get; set; 

 public string OverrideFormatting get; set; 
 public string IsLockable get; set; 
 public string Direction get; set; 
 public string ValueSetByDatabase get; set; 
 public string FormatScale get; set; 
 public string FormatMask get; set; 
 public string NegativeFormatting get; set; 
 public string Group get; set; 
 public string AggregateFunction get; set; 
 public string IsExcludedFromCopy get; set; 
 public string IsExpression get; set; 
 public string FriendlyName get; set; 
 public string IsBrowsable get; set; 
 public string IsQueryable get; set; 
 public string IsEnumeration get; set; 

 public string IsAddInPrimaryKey get; set; 
 public string AddInTableName get; set; 
 public string AddInRelationField get; set; 
 public string IsMember get; set; 
 public string IsExcludedFromReset get; set;


My code which returns correct 44 fields for the above table.



public List<TableDefnition> GetALLTableDeiniations(string tableName)

 string sql = @"SELECT c.name Field, 
t.name Type,
c.max_length MaxLength,
c.Precision, 
c.Scale,
c.is_nullable,
c.collation_name
FROM sys.columns c
INNER JOIN sys.types t ON t.system_type_id = c.system_type_id
WHERE object_id = object_id('"+ tableName + "') ORDER BY column_id";

using (var connection = new 
sqlConnection(ConfigurationManager.AppSettings["ConnectionString"]))

 List<TableDefnition> _tableDefnitions = connection.Query<TableDefnition>(sql).ToList();
 return _tableDefnitions;







c# xml xml-serialization







share|improve this question






















  • I don't see anywhere you set a Name on PersistentObject (which is _newObject). I don't see anywhere you set or add to the FieldsList either.

    – Charles Mager
    Mar 24 at 18:22














0












0








0








I am trying to build a schema xml using the following but I am having issues items our being repeated twice and the fields are not being populated.



Basically what happens is the program goes out to sql gets the columns names of the chosen tables then it should produce a schema simlar to as follows not identically in term of values but yes in terms of structure



 public List<TableNames> _tablesNamesList = new List<TableNames>();

 public void BuildSchema()
 

 foreach (var table in _tablesNamesList)
 
 PersistentObject _newObject = new PersistentObject();
 List<PersistentObject> _newPersistantObjectList = new List<PersistentObject>();

 List<TableDefnition> _newList = db.GetALLTableDeiniations(table.TABLE_NAME);

 List<FieldSchemaXml> _newFieldList = new List<FieldSchemaXml>();


 foreach (var item in _newList)
 

 FieldSchemaXml _newSchema = new FieldSchemaXml();


 _newSchema = ConvertSQLDataTypeToSage(item.Type, _newSchema, item);


 _newSchema.Name = item.Field;
 _newSchema.IsUnique = "false";
 _newSchema.IsReadOnly = "false";
 _newSchema.IsQueryable = "true";
 if (item.is_nullable == 1)
 

 _newSchema.IsNullable = "true";
 
 else
 
 _newSchema.IsNullable = "false";
 

 _newSchema.IsReadOnly = "false";
 _newSchema.IsUnique = "false";
 _newSchema.Group = "false";

 _newSchema.IsLockable = "false";
 _newSchema.IsDeltaField = "false";
 _newSchema.IsPrimaryKey = "false";
 _newSchema.FillType = "None";
 _newSchema.Direction = "Input";
 _newSchema.OverrideFormatting = "false";
 _newSchema.ValueSetByDatabase = "false";
 _newSchema.FormatScale = "0";
 _newSchema.NegativeFormatting = "Standard";
 _newSchema.AggregateFunction = "false";
 _newSchema.IsExpression = "false";
 _newSchema.IsBrowsable = "true";
 _newSchema.IsQueryable = "true";
 _newSchema.IsEnumeration = "false";
 _newSchema.IsAddInPrimaryKey = "false";
 _newSchema.IsExcludedFromReset = "false";
 _newSchema.IsMember = "false";
 _newSchema.AddInTableName = "";


 _newObject.IsCacheable = "false";

 _newObject.AllowZeroKeys = "false";
 _newObject.TransactionMode = "Required";
 _newObject.IsStoredProcedure = "false";
 _newObject.ProcedureReturnType = "";
 _newFieldList.Add(_newSchema);

 
 _newPersistantObjectList.Add(_newObject);
 _newPObject.PersistentObject.AddRange(_newPersistantObjectList);
 
 schemeContent.Text = HelperXml.ToXML(_newPObject);


Example 1.1



 <?xml version="1.0" encoding="utf-8"?>
 <ObjectStore xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns="urn:SageObjectStore">
 <ApplicationNamespace>BusinessObjects</ApplicationNamespace>
 <MemberVariablePrefix>_</MemberVariablePrefix>
 <ClassPrefix>Persistent</ClassPrefix>
 <ClassSuffix />
 <Language>VB</Language>
 <Path>C:Sage200SchemaExtensions</Path>
 <GenerateBusinessObjects>false</GenerateBusinessObjects>
 <GenerateSeparateFiles>false</GenerateSeparateFiles>
 <PersistentObjects>
 <PersistentObject Name="Customer">
 <TableName>SLCustomerAccount</TableName>
 <Description />
 <Fields>
 <Field Name="SLCustomerAccountID">
 <DbType>Int64</DbType>
 <Precision>19</Precision>
 <Scale>0</Scale>
 <FillType>None</FillType>
 <IsNullable>false</IsNullable>
 <IsReadOnly>true</IsReadOnly>
 <AllowOverwrite>Equal</AllowOverwrite>
 <IsPrimaryKey>true</IsPrimaryKey>
 <IsDeltaField>false</IsDeltaField>
 <IsIndexed>true</IsIndexed>
 <IsTransient>false</IsTransient>
 <IsUnique>true</IsUnique>
 <OverrideFormatting>false</OverrideFormatting>
 <IsLockable>false</IsLockable>
 <Direction>Input</Direction>
 <ValueSetByDatabase>false</ValueSetByDatabase>
 <FormatScale>0</FormatScale>
 <FormatMask>9999999999999999999</FormatMask>
 <NegativeFormatting>Standard</NegativeFormatting>
 <Group>false</Group>
 <AggregateFunction>None</AggregateFunction>
 <IsExcludedFromCopy>false</IsExcludedFromCopy>
 <IsExpression>false</IsExpression>
 <FriendlyName>SLCustomer Account ID</FriendlyName>
 <IsBrowsable>true</IsBrowsable>
 <IsQueryable>true</IsQueryable>
 <IsEnumeration>false</IsEnumeration>
 <IsAddInPrimaryKey>false</IsAddInPrimaryKey>
 <AddInTableName />
 <AddInRelationField />
 <IsMember>false</IsMember>
 <IsExcludedFromReset>false</IsExcludedFromReset>
 </Field>
 </Fields>
 <IsCacheable>false</IsCacheable>
 <AllowZeroKeys>false</AllowZeroKeys>
 <AlwaysAllowPaging>false</AlwaysAllowPaging>
 <Namespace>SalesLedger</Namespace>
 <PagingFields />
 <TransactionMode>Required</TransactionMode>
 <IsStoredProcedure>false</IsStoredProcedure>
 <ProcedureReturnType />
 </PersistentObject>
 <PersistentObject Name="MCSSopOrderss">
 <TableName />
 <Description />
 <Fields>
 <Field Name="CustomerID">
 <DbType>Int64</DbType>
 <Precision>11</Precision>
 <Scale>0</Scale>
 <FillType>None</FillType>
 <IsNullable>true</IsNullable>
 <IsReadOnly>false</IsReadOnly>
 <AllowOverwrite>True</AllowOverwrite>
 <IsPrimaryKey>false</IsPrimaryKey>
 <IsDeltaField>false</IsDeltaField>
 <IsIndexed>false</IsIndexed>
 <IsTransient>false</IsTransient>
 <IsUnique>false</IsUnique>
 <OverrideFormatting>false</OverrideFormatting>
 <IsLockable>false</IsLockable>
 <Direction>Input</Direction>
 <ValueSetByDatabase>false</ValueSetByDatabase>
 <FormatScale>0</FormatScale>
 <FormatMask>99999999999</FormatMask>
 <NegativeFormatting>Standard</NegativeFormatting>
 <Group>false</Group>
 <AggregateFunction>None</AggregateFunction>
 <IsExcludedFromCopy>false</IsExcludedFromCopy>



 <IsExpression>false</IsExpression>
 <FriendlyName>Customer ID</FriendlyName>
 <IsBrowsable>true</IsBrowsable>
 <IsQueryable>true</IsQueryable>
 <IsEnumeration>false</IsEnumeration>
 <IsAddInPrimaryKey>false</IsAddInPrimaryKey>
 <AddInTableName />
 <AddInRelationField />
 <IsMember>false</IsMember>
 <IsExcludedFromReset>false</IsExcludedFromReset>
 </Field>
 <Field Name="TestDate">
 <DbType>Date</DbType>
 <Precision>3</Precision>
 <Scale>0</Scale>
 <FillType>None</FillType>
 <IsNullable>true</IsNullable>
 <IsReadOnly>false</IsReadOnly>
 <AllowOverwrite>True</AllowOverwrite>
 <IsPrimaryKey>false</IsPrimaryKey>
 <IsDeltaField>false</IsDeltaField>
 <IsIndexed>false</IsIndexed>
 <IsTransient>false</IsTransient>
 <IsUnique>false</IsUnique>
 <OverrideFormatting>false</OverrideFormatting>
 <IsLockable>false</IsLockable>
 <Direction>Input</Direction>
 <ValueSetByDatabase>false</ValueSetByDatabase>
 <FormatScale>0</FormatScale>
 <FormatMask>99/99/9999</FormatMask>
 <NegativeFormatting>Standard</NegativeFormatting>
 <Group>false</Group>
 <AggregateFunction>None</AggregateFunction>
 <IsExcludedFromCopy>false</IsExcludedFromCopy>
 <IsExpression>false</IsExpression>
 <FriendlyName>test</FriendlyName>
 <IsBrowsable>true</IsBrowsable>
 <IsQueryable>true</IsQueryable>
 <IsEnumeration>false</IsEnumeration>
 <IsAddInPrimaryKey>false</IsAddInPrimaryKey>
 <AddInTableName />
 <AddInRelationField />
 <IsMember>false</IsMember>
 <IsExcludedFromReset>false</IsExcludedFromReset>
 </Field>
 <Field Name="TestString">
 <DbType>String</DbType>
 <Precision>64</Precision>
 <Scale>2</Scale>
 <FillType>None</FillType>
 <IsNullable>false</IsNullable>
 <IsReadOnly>false</IsReadOnly>
 <AllowOverwrite>True</AllowOverwrite>
 <IsPrimaryKey>false</IsPrimaryKey>
 <IsDeltaField>false</IsDeltaField>
 <IsIndexed>false</IsIndexed>
 <IsTransient>false</IsTransient>
 <IsUnique>false</IsUnique>
 <OverrideFormatting>false</OverrideFormatting>
 <IsLockable>false</IsLockable>
 <Direction>Input</Direction>
 <ValueSetByDatabase>false</ValueSetByDatabase>
 <FormatScale>2</FormatScale>
 <NegativeFormatting>Standard</NegativeFormatting>
 <Group>false</Group>
 <AggregateFunction>None</AggregateFunction>
 <IsExcludedFromCopy>false</IsExcludedFromCopy>
 <IsExpression>false</IsExpression>
 <FriendlyName>Test String</FriendlyName>
 <IsBrowsable>true</IsBrowsable>
 <IsQueryable>true</IsQueryable>
 <IsEnumeration>false</IsEnumeration>
 <IsAddInPrimaryKey>false</IsAddInPrimaryKey>
 <AddInTableName />
 <AddInRelationField />
 <IsMember>false</IsMember>
 <IsExcludedFromReset>false</IsExcludedFromReset>
 </Field>
 <Field Name="TestMoney">
 <UserDataType>MonetaryValue2dp</UserDataType>
 <DbType>String</DbType>
 <Precision>12</Precision>
 <Scale>2</Scale>
 <FillType>None</FillType>
 <IsNullable>false</IsNullable>
 <IsReadOnly>false</IsReadOnly>
 <AllowOverwrite>True</AllowOverwrite>
 <IsPrimaryKey>false</IsPrimaryKey>
 <IsDeltaField>false</IsDeltaField>
 <IsIndexed>false</IsIndexed>
 <IsTransient>false</IsTransient>
 <IsUnique>false</IsUnique>
 <OverrideFormatting>false</OverrideFormatting>
 <IsLockable>false</IsLockable>
 <Direction>Input</Direction>
 <ValueSetByDatabase>false</ValueSetByDatabase>
 <FormatScale>2</FormatScale>
 <NegativeFormatting>Standard</NegativeFormatting>
 <Group>false</Group>
 <AggregateFunction>None</AggregateFunction>
 <IsExcludedFromCopy>false</IsExcludedFromCopy>
 <IsExpression>false</IsExpression>
 <FriendlyName>Test Money</FriendlyName>
 <IsBrowsable>true</IsBrowsable>
 <IsQueryable>true</IsQueryable>
 <IsEnumeration>false</IsEnumeration>
 <IsAddInPrimaryKey>false</IsAddInPrimaryKey>
 <AddInTableName />
 <AddInRelationField />
 <IsMember>false</IsMember>
 <IsExcludedFromReset>false</IsExcludedFromReset>
 </Field>
 <Field Name="TestDecimal">
 <DbType>Decimal</DbType>
 <Precision>18</Precision>
 <Scale>0</Scale>
 <FillType>None</FillType>
 <IsNullable>false</IsNullable>
 <IsReadOnly>false</IsReadOnly>
 <AllowOverwrite>True</AllowOverwrite>
 <IsPrimaryKey>false</IsPrimaryKey>
 <IsDeltaField>false</IsDeltaField>
 <IsIndexed>false</IsIndexed>
 <IsTransient>false</IsTransient>
 <IsUnique>false</IsUnique>
 <OverrideFormatting>false</OverrideFormatting>
 <IsLockable>false</IsLockable>
 <Direction>Input</Direction>
 <ValueSetByDatabase>false</ValueSetByDatabase>
 <FormatScale>0</FormatScale>
 <FormatMask>999999999999999999.</FormatMask>
 <NegativeFormatting>Standard</NegativeFormatting>
 <Group>false</Group>
 <AggregateFunction>None</AggregateFunction>
 <IsExcludedFromCopy>false</IsExcludedFromCopy>
 <IsExpression>false</IsExpression>
 <FriendlyName>Test Decimal</FriendlyName>
 <IsBrowsable>true</IsBrowsable>
 <IsQueryable>true</IsQueryable>
 <IsEnumeration>false</IsEnumeration>
 <IsAddInPrimaryKey>false</IsAddInPrimaryKey>
 <AddInTableName />
 <AddInRelationField />
 <IsMember>false</IsMember>
 <IsExcludedFromReset>false</IsExcludedFromReset>
 </Field>
 <Field Name="TestCurrency">
 <DbType>Currency</DbType>
 <Precision>11</Precision>
 <Scale>2</Scale>
 <FillType>None</FillType>
 <IsNullable>false</IsNullable>
 <IsReadOnly>false</IsReadOnly>
 <AllowOverwrite>True</AllowOverwrite>
 <IsPrimaryKey>false</IsPrimaryKey>
 <IsDeltaField>false</IsDeltaField>
 <IsIndexed>false</IsIndexed>
 <IsTransient>false</IsTransient>
 <IsUnique>false</IsUnique>
 <OverrideFormatting>false</OverrideFormatting>
 <IsLockable>false</IsLockable>
 <Direction>Input</Direction>
 <ValueSetByDatabase>false</ValueSetByDatabase>
 <FormatScale>2</FormatScale>
 <FormatMask>99999999999.99</FormatMask>
 <NegativeFormatting>Standard</NegativeFormatting>
 <Group>false</Group>
 <AggregateFunction>None</AggregateFunction>
 <IsExcludedFromCopy>false</IsExcludedFromCopy>
 <IsExpression>false</IsExpression>
 <FriendlyName>Test Currency</FriendlyName>
 <IsBrowsable>true</IsBrowsable>
 <IsQueryable>true</IsQueryable>
 <IsEnumeration>false</IsEnumeration>
 <IsAddInPrimaryKey>false</IsAddInPrimaryKey>
 <AddInTableName />
 <AddInRelationField />
 <IsMember>false</IsMember>
 <IsExcludedFromReset>false</IsExcludedFromReset>
 </Field>
 <Field Name="Test">
 <DbType>String</DbType>
 <Precision>64</Precision>
 <Scale>2</Scale>
 <FillType>None</FillType>
 <IsNullable>false</IsNullable>
 <IsReadOnly>false</IsReadOnly>
 <AllowOverwrite>True</AllowOverwrite>
 <IsPrimaryKey>false</IsPrimaryKey>
 <IsDeltaField>false</IsDeltaField>
 <IsIndexed>false</IsIndexed>
 <IsTransient>false</IsTransient>
 <IsUnique>false</IsUnique>
 <OverrideFormatting>false</OverrideFormatting>
 <IsLockable>false</IsLockable>
 <Direction>Input</Direction>
 <ValueSetByDatabase>false</ValueSetByDatabase>
 <FormatScale>2</FormatScale>
 <NegativeFormatting>Standard</NegativeFormatting>
 <Group>false</Group>
 <AggregateFunction>None</AggregateFunction>
 <IsExcludedFromCopy>false</IsExcludedFromCopy>
 <IsExpression>false</IsExpression>
 <FriendlyName>Test</FriendlyName>
 <IsBrowsable>true</IsBrowsable>
 <IsQueryable>true</IsQueryable>
 <IsEnumeration>false</IsEnumeration>
 <IsAddInPrimaryKey>false</IsAddInPrimaryKey>
 <AddInTableName />
 <AddInRelationField />
 <IsMember>false</IsMember>
 <IsExcludedFromReset>false</IsExcludedFromReset>
 </Field>
 </Fields>
 <IsCacheable>false</IsCacheable>
 <AllowZeroKeys>false</AllowZeroKeys>
 <AlwaysAllowPaging>false</AlwaysAllowPaging>
 <Namespace />
 <PagingFields />
 <TransactionMode>Required</TransactionMode>
 <IsStoredProcedure>false</IsStoredProcedure>
 <ProcedureReturnType />
 </PersistentObject>
 </PersistentObjects>
 <Relationships>
 <Relationship>
 <ParentObject>Customer</ParentObject>
 <ParentKey>SLCustomerAccountID</ParentKey>
 <ChildObject>MCSSopOrderss</ChildObject>
 <ChildKey>CustomerID</ChildKey>
 <InsertOperation>CheckParentExists</InsertOperation>
 <DeleteOperation>CheckForAnyChildren</DeleteOperation>
 <IsOneToMany>true</IsOneToMany>

 </Relationship>
 </Relationships>
 <DataTypes />
 <Enumerations />
 <BaselineSchema>C:Program Files (x86)Sage 200 
 SDKSageObjectStore.xml</BaselineSchema>
 </ObjectStore>


However what I am getting is the following For that table there is 44 objects in the field list list so for fields it should be printing that and as you can see its ignorning the name property i am setting on persitent object as well.



 <?xml version="1.0" encoding="utf-16"?>
 <ObjectStore xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema">
 <PersistentObjects>
 <PersistentObject>
 <Fields />
 <IsCacheable>false</IsCacheable>
 <AllowZeroKeys>false</AllowZeroKeys>
 <TransactionMode>Required</TransactionMode>
 <ProcedureReturnType />
 <IsStoredProcedure>false</IsStoredProcedure>
 </PersistentObject>
 </PersistentObjects>
 <PersistentObject>
 <PersistentObject>
 <Fields />
 <IsCacheable>false</IsCacheable>
 <AllowZeroKeys>false</AllowZeroKeys>
 <TransactionMode>Required</TransactionMode>
 <ProcedureReturnType />
 <IsStoredProcedure>false</IsStoredProcedure>
 </PersistentObject>
 </PersistentObject>
 </ObjectStore>


My Class for the above.



 public class SageXmlDefiniation
 
 public class ObjectStore

 
 public List<PersistentObject> PersistentObjects = new 
 List<PersistentObject>();
 public string ApplicationnameSpace get; set; 
 public string MemberVariablePrefix get; set; 
 public string ClassPrefix get; set; 
 public string ClassSuffix get; set; 
 public string Language get; set; 
 public string Path get; set; 
 public string GenerateBusinessObjects get; set; 
 public string GenerateSeparateFiles get; set; 

 public List<PersistentObject> PersistentObject
 
 get return PersistentObjects; 
 set PersistentObjects = value; 
 

 
 public class PersistentObject
 
 private List<FieldSchemaXml> _Fields = new List<FieldSchemaXml>();

 [XmlAttribute("Name")]
 public string Name get; set; 

 public string TableName get; set; 
 public string Description get; set; 
 [XmlArray("Fields")]
 [XmlArrayItem("Field")]
 public List<FieldSchemaXml> FieldsList
 
 get return _Fields; 
 set _Fields = value; 
 
 public string IsCacheable get; set; 
 public string AllowZeroKeys get; set; 
 public string NameSapce get; set; 

 public string PagingFields get; set; 
 public string TransactionMode get; set; 
 public string ProcedureReturnType get; set; 
 public string IsStoredProcedure get; set; 
 
 public class FieldSchemaXml
 
 [XmlAttribute("Name")]
 public string Name get; set; 

 public string DBType get; set; 
 public string Precision get; set; 
 public string Scale get; set; 
 public string FillType get; set; 
 public string IsNullable get; set; 
 public string IsReadOnly get; set; 
 public string AllowOverwrite get; set; 
 public string IsPrimaryKey get; set; 

 public string IsDeltaField get; set; 
 public string IsIndexed get; set; 
 public string IsTransient get; set; 
 public string IsUnique get; set; 

 public string OverrideFormatting get; set; 
 public string IsLockable get; set; 
 public string Direction get; set; 
 public string ValueSetByDatabase get; set; 
 public string FormatScale get; set; 
 public string FormatMask get; set; 
 public string NegativeFormatting get; set; 
 public string Group get; set; 
 public string AggregateFunction get; set; 
 public string IsExcludedFromCopy get; set; 
 public string IsExpression get; set; 
 public string FriendlyName get; set; 
 public string IsBrowsable get; set; 
 public string IsQueryable get; set; 
 public string IsEnumeration get; set; 

 public string IsAddInPrimaryKey get; set; 
 public string AddInTableName get; set; 
 public string AddInRelationField get; set; 
 public string IsMember get; set; 
 public string IsExcludedFromReset get; set;


My code which returns correct 44 fields for the above table.



public List<TableDefnition> GetALLTableDeiniations(string tableName)

 string sql = @"SELECT c.name Field, 
t.name Type,
c.max_length MaxLength,
c.Precision, 
c.Scale,
c.is_nullable,
c.collation_name
FROM sys.columns c
INNER JOIN sys.types t ON t.system_type_id = c.system_type_id
WHERE object_id = object_id('"+ tableName + "') ORDER BY column_id";

using (var connection = new 
sqlConnection(ConfigurationManager.AppSettings["ConnectionString"]))

 List<TableDefnition> _tableDefnitions = connection.Query<TableDefnition>(sql).ToList();
 return _tableDefnitions;







c# xml xml-serialization







share|improve this question














I am trying to build a schema xml using the following but I am having issues items our being repeated twice and the fields are not being populated.



Basically what happens is the program goes out to sql gets the columns names of the chosen tables then it should produce a schema simlar to as follows not identically in term of values but yes in terms of structure



 public List<TableNames> _tablesNamesList = new List<TableNames>();

 public void BuildSchema()
 

 foreach (var table in _tablesNamesList)
 
 PersistentObject _newObject = new PersistentObject();
 List<PersistentObject> _newPersistantObjectList = new List<PersistentObject>();

 List<TableDefnition> _newList = db.GetALLTableDeiniations(table.TABLE_NAME);

 List<FieldSchemaXml> _newFieldList = new List<FieldSchemaXml>();


 foreach (var item in _newList)
 

 FieldSchemaXml _newSchema = new FieldSchemaXml();


 _newSchema = ConvertSQLDataTypeToSage(item.Type, _newSchema, item);


 _newSchema.Name = item.Field;
 _newSchema.IsUnique = "false";
 _newSchema.IsReadOnly = "false";
 _newSchema.IsQueryable = "true";
 if (item.is_nullable == 1)
 

 _newSchema.IsNullable = "true";
 
 else
 
 _newSchema.IsNullable = "false";
 

 _newSchema.IsReadOnly = "false";
 _newSchema.IsUnique = "false";
 _newSchema.Group = "false";

 _newSchema.IsLockable = "false";
 _newSchema.IsDeltaField = "false";
 _newSchema.IsPrimaryKey = "false";
 _newSchema.FillType = "None";
 _newSchema.Direction = "Input";
 _newSchema.OverrideFormatting = "false";
 _newSchema.ValueSetByDatabase = "false";
 _newSchema.FormatScale = "0";
 _newSchema.NegativeFormatting = "Standard";
 _newSchema.AggregateFunction = "false";
 _newSchema.IsExpression = "false";
 _newSchema.IsBrowsable = "true";
 _newSchema.IsQueryable = "true";
 _newSchema.IsEnumeration = "false";
 _newSchema.IsAddInPrimaryKey = "false";
 _newSchema.IsExcludedFromReset = "false";
 _newSchema.IsMember = "false";
 _newSchema.AddInTableName = "";


 _newObject.IsCacheable = "false";

 _newObject.AllowZeroKeys = "false";
 _newObject.TransactionMode = "Required";
 _newObject.IsStoredProcedure = "false";
 _newObject.ProcedureReturnType = "";
 _newFieldList.Add(_newSchema);

 
 _newPersistantObjectList.Add(_newObject);
 _newPObject.PersistentObject.AddRange(_newPersistantObjectList);
 
 schemeContent.Text = HelperXml.ToXML(_newPObject);


Example 1.1



 <?xml version="1.0" encoding="utf-8"?>
 <ObjectStore xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns="urn:SageObjectStore">
 <ApplicationNamespace>BusinessObjects</ApplicationNamespace>
 <MemberVariablePrefix>_</MemberVariablePrefix>
 <ClassPrefix>Persistent</ClassPrefix>
 <ClassSuffix />
 <Language>VB</Language>
 <Path>C:Sage200SchemaExtensions</Path>
 <GenerateBusinessObjects>false</GenerateBusinessObjects>
 <GenerateSeparateFiles>false</GenerateSeparateFiles>
 <PersistentObjects>
 <PersistentObject Name="Customer">
 <TableName>SLCustomerAccount</TableName>
 <Description />
 <Fields>
 <Field Name="SLCustomerAccountID">
 <DbType>Int64</DbType>
 <Precision>19</Precision>
 <Scale>0</Scale>
 <FillType>None</FillType>
 <IsNullable>false</IsNullable>
 <IsReadOnly>true</IsReadOnly>
 <AllowOverwrite>Equal</AllowOverwrite>
 <IsPrimaryKey>true</IsPrimaryKey>
 <IsDeltaField>false</IsDeltaField>
 <IsIndexed>true</IsIndexed>
 <IsTransient>false</IsTransient>
 <IsUnique>true</IsUnique>
 <OverrideFormatting>false</OverrideFormatting>
 <IsLockable>false</IsLockable>
 <Direction>Input</Direction>
 <ValueSetByDatabase>false</ValueSetByDatabase>
 <FormatScale>0</FormatScale>
 <FormatMask>9999999999999999999</FormatMask>
 <NegativeFormatting>Standard</NegativeFormatting>
 <Group>false</Group>
 <AggregateFunction>None</AggregateFunction>
 <IsExcludedFromCopy>false</IsExcludedFromCopy>
 <IsExpression>false</IsExpression>
 <FriendlyName>SLCustomer Account ID</FriendlyName>
 <IsBrowsable>true</IsBrowsable>
 <IsQueryable>true</IsQueryable>
 <IsEnumeration>false</IsEnumeration>
 <IsAddInPrimaryKey>false</IsAddInPrimaryKey>
 <AddInTableName />
 <AddInRelationField />
 <IsMember>false</IsMember>
 <IsExcludedFromReset>false</IsExcludedFromReset>
 </Field>
 </Fields>
 <IsCacheable>false</IsCacheable>
 <AllowZeroKeys>false</AllowZeroKeys>
 <AlwaysAllowPaging>false</AlwaysAllowPaging>
 <Namespace>SalesLedger</Namespace>
 <PagingFields />
 <TransactionMode>Required</TransactionMode>
 <IsStoredProcedure>false</IsStoredProcedure>
 <ProcedureReturnType />
 </PersistentObject>
 <PersistentObject Name="MCSSopOrderss">
 <TableName />
 <Description />
 <Fields>
 <Field Name="CustomerID">
 <DbType>Int64</DbType>
 <Precision>11</Precision>
 <Scale>0</Scale>
 <FillType>None</FillType>
 <IsNullable>true</IsNullable>
 <IsReadOnly>false</IsReadOnly>
 <AllowOverwrite>True</AllowOverwrite>
 <IsPrimaryKey>false</IsPrimaryKey>
 <IsDeltaField>false</IsDeltaField>
 <IsIndexed>false</IsIndexed>
 <IsTransient>false</IsTransient>
 <IsUnique>false</IsUnique>
 <OverrideFormatting>false</OverrideFormatting>
 <IsLockable>false</IsLockable>
 <Direction>Input</Direction>
 <ValueSetByDatabase>false</ValueSetByDatabase>
 <FormatScale>0</FormatScale>
 <FormatMask>99999999999</FormatMask>
 <NegativeFormatting>Standard</NegativeFormatting>
 <Group>false</Group>
 <AggregateFunction>None</AggregateFunction>
 <IsExcludedFromCopy>false</IsExcludedFromCopy>



 <IsExpression>false</IsExpression>
 <FriendlyName>Customer ID</FriendlyName>
 <IsBrowsable>true</IsBrowsable>
 <IsQueryable>true</IsQueryable>
 <IsEnumeration>false</IsEnumeration>
 <IsAddInPrimaryKey>false</IsAddInPrimaryKey>
 <AddInTableName />
 <AddInRelationField />
 <IsMember>false</IsMember>
 <IsExcludedFromReset>false</IsExcludedFromReset>
 </Field>
 <Field Name="TestDate">
 <DbType>Date</DbType>
 <Precision>3</Precision>
 <Scale>0</Scale>
 <FillType>None</FillType>
 <IsNullable>true</IsNullable>
 <IsReadOnly>false</IsReadOnly>
 <AllowOverwrite>True</AllowOverwrite>
 <IsPrimaryKey>false</IsPrimaryKey>
 <IsDeltaField>false</IsDeltaField>
 <IsIndexed>false</IsIndexed>
 <IsTransient>false</IsTransient>
 <IsUnique>false</IsUnique>
 <OverrideFormatting>false</OverrideFormatting>
 <IsLockable>false</IsLockable>
 <Direction>Input</Direction>
 <ValueSetByDatabase>false</ValueSetByDatabase>
 <FormatScale>0</FormatScale>
 <FormatMask>99/99/9999</FormatMask>
 <NegativeFormatting>Standard</NegativeFormatting>
 <Group>false</Group>
 <AggregateFunction>None</AggregateFunction>
 <IsExcludedFromCopy>false</IsExcludedFromCopy>
 <IsExpression>false</IsExpression>
 <FriendlyName>test</FriendlyName>
 <IsBrowsable>true</IsBrowsable>
 <IsQueryable>true</IsQueryable>
 <IsEnumeration>false</IsEnumeration>
 <IsAddInPrimaryKey>false</IsAddInPrimaryKey>
 <AddInTableName />
 <AddInRelationField />
 <IsMember>false</IsMember>
 <IsExcludedFromReset>false</IsExcludedFromReset>
 </Field>
 <Field Name="TestString">
 <DbType>String</DbType>
 <Precision>64</Precision>
 <Scale>2</Scale>
 <FillType>None</FillType>
 <IsNullable>false</IsNullable>
 <IsReadOnly>false</IsReadOnly>
 <AllowOverwrite>True</AllowOverwrite>
 <IsPrimaryKey>false</IsPrimaryKey>
 <IsDeltaField>false</IsDeltaField>
 <IsIndexed>false</IsIndexed>
 <IsTransient>false</IsTransient>
 <IsUnique>false</IsUnique>
 <OverrideFormatting>false</OverrideFormatting>
 <IsLockable>false</IsLockable>
 <Direction>Input</Direction>
 <ValueSetByDatabase>false</ValueSetByDatabase>
 <FormatScale>2</FormatScale>
 <NegativeFormatting>Standard</NegativeFormatting>
 <Group>false</Group>
 <AggregateFunction>None</AggregateFunction>
 <IsExcludedFromCopy>false</IsExcludedFromCopy>
 <IsExpression>false</IsExpression>
 <FriendlyName>Test String</FriendlyName>
 <IsBrowsable>true</IsBrowsable>
 <IsQueryable>true</IsQueryable>
 <IsEnumeration>false</IsEnumeration>
 <IsAddInPrimaryKey>false</IsAddInPrimaryKey>
 <AddInTableName />
 <AddInRelationField />
 <IsMember>false</IsMember>
 <IsExcludedFromReset>false</IsExcludedFromReset>
 </Field>
 <Field Name="TestMoney">
 <UserDataType>MonetaryValue2dp</UserDataType>
 <DbType>String</DbType>
 <Precision>12</Precision>
 <Scale>2</Scale>
 <FillType>None</FillType>
 <IsNullable>false</IsNullable>
 <IsReadOnly>false</IsReadOnly>
 <AllowOverwrite>True</AllowOverwrite>
 <IsPrimaryKey>false</IsPrimaryKey>
 <IsDeltaField>false</IsDeltaField>
 <IsIndexed>false</IsIndexed>
 <IsTransient>false</IsTransient>
 <IsUnique>false</IsUnique>
 <OverrideFormatting>false</OverrideFormatting>
 <IsLockable>false</IsLockable>
 <Direction>Input</Direction>
 <ValueSetByDatabase>false</ValueSetByDatabase>
 <FormatScale>2</FormatScale>
 <NegativeFormatting>Standard</NegativeFormatting>
 <Group>false</Group>
 <AggregateFunction>None</AggregateFunction>
 <IsExcludedFromCopy>false</IsExcludedFromCopy>
 <IsExpression>false</IsExpression>
 <FriendlyName>Test Money</FriendlyName>
 <IsBrowsable>true</IsBrowsable>
 <IsQueryable>true</IsQueryable>
 <IsEnumeration>false</IsEnumeration>
 <IsAddInPrimaryKey>false</IsAddInPrimaryKey>
 <AddInTableName />
 <AddInRelationField />
 <IsMember>false</IsMember>
 <IsExcludedFromReset>false</IsExcludedFromReset>
 </Field>
 <Field Name="TestDecimal">
 <DbType>Decimal</DbType>
 <Precision>18</Precision>
 <Scale>0</Scale>
 <FillType>None</FillType>
 <IsNullable>false</IsNullable>
 <IsReadOnly>false</IsReadOnly>
 <AllowOverwrite>True</AllowOverwrite>
 <IsPrimaryKey>false</IsPrimaryKey>
 <IsDeltaField>false</IsDeltaField>
 <IsIndexed>false</IsIndexed>
 <IsTransient>false</IsTransient>
 <IsUnique>false</IsUnique>
 <OverrideFormatting>false</OverrideFormatting>
 <IsLockable>false</IsLockable>
 <Direction>Input</Direction>
 <ValueSetByDatabase>false</ValueSetByDatabase>
 <FormatScale>0</FormatScale>
 <FormatMask>999999999999999999.</FormatMask>
 <NegativeFormatting>Standard</NegativeFormatting>
 <Group>false</Group>
 <AggregateFunction>None</AggregateFunction>
 <IsExcludedFromCopy>false</IsExcludedFromCopy>
 <IsExpression>false</IsExpression>
 <FriendlyName>Test Decimal</FriendlyName>
 <IsBrowsable>true</IsBrowsable>
 <IsQueryable>true</IsQueryable>
 <IsEnumeration>false</IsEnumeration>
 <IsAddInPrimaryKey>false</IsAddInPrimaryKey>
 <AddInTableName />
 <AddInRelationField />
 <IsMember>false</IsMember>
 <IsExcludedFromReset>false</IsExcludedFromReset>
 </Field>
 <Field Name="TestCurrency">
 <DbType>Currency</DbType>
 <Precision>11</Precision>
 <Scale>2</Scale>
 <FillType>None</FillType>
 <IsNullable>false</IsNullable>
 <IsReadOnly>false</IsReadOnly>
 <AllowOverwrite>True</AllowOverwrite>
 <IsPrimaryKey>false</IsPrimaryKey>
 <IsDeltaField>false</IsDeltaField>
 <IsIndexed>false</IsIndexed>
 <IsTransient>false</IsTransient>
 <IsUnique>false</IsUnique>
 <OverrideFormatting>false</OverrideFormatting>
 <IsLockable>false</IsLockable>
 <Direction>Input</Direction>
 <ValueSetByDatabase>false</ValueSetByDatabase>
 <FormatScale>2</FormatScale>
 <FormatMask>99999999999.99</FormatMask>
 <NegativeFormatting>Standard</NegativeFormatting>
 <Group>false</Group>
 <AggregateFunction>None</AggregateFunction>
 <IsExcludedFromCopy>false</IsExcludedFromCopy>
 <IsExpression>false</IsExpression>
 <FriendlyName>Test Currency</FriendlyName>
 <IsBrowsable>true</IsBrowsable>
 <IsQueryable>true</IsQueryable>
 <IsEnumeration>false</IsEnumeration>
 <IsAddInPrimaryKey>false</IsAddInPrimaryKey>
 <AddInTableName />
 <AddInRelationField />
 <IsMember>false</IsMember>
 <IsExcludedFromReset>false</IsExcludedFromReset>
 </Field>
 <Field Name="Test">
 <DbType>String</DbType>
 <Precision>64</Precision>
 <Scale>2</Scale>
 <FillType>None</FillType>
 <IsNullable>false</IsNullable>
 <IsReadOnly>false</IsReadOnly>
 <AllowOverwrite>True</AllowOverwrite>
 <IsPrimaryKey>false</IsPrimaryKey>
 <IsDeltaField>false</IsDeltaField>
 <IsIndexed>false</IsIndexed>
 <IsTransient>false</IsTransient>
 <IsUnique>false</IsUnique>
 <OverrideFormatting>false</OverrideFormatting>
 <IsLockable>false</IsLockable>
 <Direction>Input</Direction>
 <ValueSetByDatabase>false</ValueSetByDatabase>
 <FormatScale>2</FormatScale>
 <NegativeFormatting>Standard</NegativeFormatting>
 <Group>false</Group>
 <AggregateFunction>None</AggregateFunction>
 <IsExcludedFromCopy>false</IsExcludedFromCopy>
 <IsExpression>false</IsExpression>
 <FriendlyName>Test</FriendlyName>
 <IsBrowsable>true</IsBrowsable>
 <IsQueryable>true</IsQueryable>
 <IsEnumeration>false</IsEnumeration>
 <IsAddInPrimaryKey>false</IsAddInPrimaryKey>
 <AddInTableName />
 <AddInRelationField />
 <IsMember>false</IsMember>
 <IsExcludedFromReset>false</IsExcludedFromReset>
 </Field>
 </Fields>
 <IsCacheable>false</IsCacheable>
 <AllowZeroKeys>false</AllowZeroKeys>
 <AlwaysAllowPaging>false</AlwaysAllowPaging>
 <Namespace />
 <PagingFields />
 <TransactionMode>Required</TransactionMode>
 <IsStoredProcedure>false</IsStoredProcedure>
 <ProcedureReturnType />
 </PersistentObject>
 </PersistentObjects>
 <Relationships>
 <Relationship>
 <ParentObject>Customer</ParentObject>
 <ParentKey>SLCustomerAccountID</ParentKey>
 <ChildObject>MCSSopOrderss</ChildObject>
 <ChildKey>CustomerID</ChildKey>
 <InsertOperation>CheckParentExists</InsertOperation>
 <DeleteOperation>CheckForAnyChildren</DeleteOperation>
 <IsOneToMany>true</IsOneToMany>

 </Relationship>
 </Relationships>
 <DataTypes />
 <Enumerations />
 <BaselineSchema>C:Program Files (x86)Sage 200 
 SDKSageObjectStore.xml</BaselineSchema>
 </ObjectStore>


However what I am getting is the following For that table there is 44 objects in the field list list so for fields it should be printing that and as you can see its ignorning the name property i am setting on persitent object as well.



 <?xml version="1.0" encoding="utf-16"?>
 <ObjectStore xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema">
 <PersistentObjects>
 <PersistentObject>
 <Fields />
 <IsCacheable>false</IsCacheable>
 <AllowZeroKeys>false</AllowZeroKeys>
 <TransactionMode>Required</TransactionMode>
 <ProcedureReturnType />
 <IsStoredProcedure>false</IsStoredProcedure>
 </PersistentObject>
 </PersistentObjects>
 <PersistentObject>
 <PersistentObject>
 <Fields />
 <IsCacheable>false</IsCacheable>
 <AllowZeroKeys>false</AllowZeroKeys>
 <TransactionMode>Required</TransactionMode>
 <ProcedureReturnType />
 <IsStoredProcedure>false</IsStoredProcedure>
 </PersistentObject>
 </PersistentObject>
 </ObjectStore>


My Class for the above.



 public class SageXmlDefiniation
 
 public class ObjectStore

 
 public List<PersistentObject> PersistentObjects = new 
 List<PersistentObject>();
 public string ApplicationnameSpace get; set; 
 public string MemberVariablePrefix get; set; 
 public string ClassPrefix get; set; 
 public string ClassSuffix get; set; 
 public string Language get; set; 
 public string Path get; set; 
 public string GenerateBusinessObjects get; set; 
 public string GenerateSeparateFiles get; set; 

 public List<PersistentObject> PersistentObject
 
 get return PersistentObjects; 
 set PersistentObjects = value; 
 

 
 public class PersistentObject
 
 private List<FieldSchemaXml> _Fields = new List<FieldSchemaXml>();

 [XmlAttribute("Name")]
 public string Name get; set; 

 public string TableName get; set; 
 public string Description get; set; 
 [XmlArray("Fields")]
 [XmlArrayItem("Field")]
 public List<FieldSchemaXml> FieldsList
 
 get return _Fields; 
 set _Fields = value; 
 
 public string IsCacheable get; set; 
 public string AllowZeroKeys get; set; 
 public string NameSapce get; set; 

 public string PagingFields get; set; 
 public string TransactionMode get; set; 
 public string ProcedureReturnType get; set; 
 public string IsStoredProcedure get; set; 
 
 public class FieldSchemaXml
 
 [XmlAttribute("Name")]
 public string Name get; set; 

 public string DBType get; set; 
 public string Precision get; set; 
 public string Scale get; set; 
 public string FillType get; set; 
 public string IsNullable get; set; 
 public string IsReadOnly get; set; 
 public string AllowOverwrite get; set; 
 public string IsPrimaryKey get; set; 

 public string IsDeltaField get; set; 
 public string IsIndexed get; set; 
 public string IsTransient get; set; 
 public string IsUnique get; set; 

 public string OverrideFormatting get; set; 
 public string IsLockable get; set; 
 public string Direction get; set; 
 public string ValueSetByDatabase get; set; 
 public string FormatScale get; set; 
 public string FormatMask get; set; 
 public string NegativeFormatting get; set; 
 public string Group get; set; 
 public string AggregateFunction get; set; 
 public string IsExcludedFromCopy get; set; 
 public string IsExpression get; set; 
 public string FriendlyName get; set; 
 public string IsBrowsable get; set; 
 public string IsQueryable get; set; 
 public string IsEnumeration get; set; 

 public string IsAddInPrimaryKey get; set; 
 public string AddInTableName get; set; 
 public string AddInRelationField get; set; 
 public string IsMember get; set; 
 public string IsExcludedFromReset get; set;


My code which returns correct 44 fields for the above table.



public List<TableDefnition> GetALLTableDeiniations(string tableName)

 string sql = @"SELECT c.name Field, 
t.name Type,
c.max_length MaxLength,
c.Precision, 
c.Scale,
c.is_nullable,
c.collation_name
FROM sys.columns c
INNER JOIN sys.types t ON t.system_type_id = c.system_type_id
WHERE object_id = object_id('"+ tableName + "') ORDER BY column_id";

using (var connection = new 
sqlConnection(ConfigurationManager.AppSettings["ConnectionString"]))

 List<TableDefnition> _tableDefnitions = connection.Query<TableDefnition>(sql).ToList();
 return _tableDefnitions;







c# xml xml-serialization




c# xml xml-serialization






share|improve this question













share|improve this question











share|improve this question




share|improve this question










asked Mar 24 at 17:10









DaveDave

989




989












  • I don't see anywhere you set a Name on PersistentObject (which is _newObject). I don't see anywhere you set or add to the FieldsList either.

    – Charles Mager
    Mar 24 at 18:22


















  • I don't see anywhere you set a Name on PersistentObject (which is _newObject). I don't see anywhere you set or add to the FieldsList either.

    – Charles Mager
    Mar 24 at 18:22

















I don't see anywhere you set a Name on PersistentObject (which is _newObject). I don't see anywhere you set or add to the FieldsList either.

– Charles Mager
Mar 24 at 18:22






I don't see anywhere you set a Name on PersistentObject (which is _newObject). I don't see anywhere you set or add to the FieldsList either.

– Charles Mager
Mar 24 at 18:22













0






active

oldest

votes












Your Answer






StackExchange.ifUsing("editor", function ()
StackExchange.using("externalEditor", function ()
StackExchange.using("snippets", function ()
StackExchange.snippets.init();
);
);
, "code-snippets");

StackExchange.ready(function()
var channelOptions =
tags: "".split(" "),
id: "1"
;
initTagRenderer("".split(" "), "".split(" "), channelOptions);

StackExchange.using("externalEditor", function()
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled)
StackExchange.using("snippets", function()
createEditor();
);

else
createEditor();

);

function createEditor()
StackExchange.prepareEditor(
heartbeatType: 'answer',
autoActivateHeartbeat: false,
convertImagesToLinks: true,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: 10,
bindNavPrevention: true,
postfix: "",
imageUploader:
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
,
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
);



);













draft saved

draft discarded


















StackExchange.ready(
function ()
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f55326354%2fxml-not-matching-expected-results%23new-answer', 'question_page');

);

Post as a guest















Required, but never shown

























0






active

oldest

votes








0






active

oldest

votes









active

oldest

votes






active

oldest

votes















draft saved

draft discarded
















































Thanks for contributing an answer to Stack Overflow!


  • Please be sure to answer the question. Provide details and share your research!

But avoid …


  • Asking for help, clarification, or responding to other answers.

  • Making statements based on opinion; back them up with references or personal experience.

To learn more, see our tips on writing great answers.




draft saved


draft discarded














StackExchange.ready(
function ()
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f55326354%2fxml-not-matching-expected-results%23new-answer', 'question_page');

);

Post as a guest















Required, but never shown





















































Required, but never shown














Required, but never shown












Required, but never shown







Required, but never shown

































Required, but never shown














Required, but never shown












Required, but never shown







Required, but never shown







-

Popular posts from this blog

Kamusi Yaliyomo Aina za kamusi | Muundo wa kamusi | Faida za kamusi | Dhima ya picha katika kamusi | Marejeo | Tazama pia | Viungo vya nje | UrambazajiKuhusu kamusiGo-SwahiliWiki-KamusiKamusi ya Kiswahili na Kiingerezakuihariri na kuongeza habari

Image
Pages using ISBN magic linksMbegu za lughaKamusiIsimu nenoKiarabukitabulughaKiswahilialfabetimaanaufafanuzimanenomuhtasarisarufividahizoalfabeti Kamusi Kutoka Wikipedia, kamusi elezo huru Jump to navigation Jump to search Kamusi za Kiswahili Kamusi ya Kiswahili-Kiswahili (kamusi wahidiya) Kamusi ya Kiswahili - Kiingereza (kamusi thania) Kamusi (kutoka neno la Kiarabu قاموس qamus ) ni kitabu ambacho kinaorodhesha maneno ya lugha yaliyokusanywa kutoka kwa watumiaji wa lugha fulani, kwa mfano lugha ya Kiswahili. Maneno hupangwa kwa mtindo wa alfabeti, hutoa maana, asili na ufafanuzi wa utumizi wa maneno na jinsi yanavyotumika au yanavyotamkwa. [1] Yaliyomo 1 Aina za kamusi 2 Muundo wa kamusi 2.1 1. Utangulizi wa kamusi 2.2 2. Matini ya kamusi 2.3 3. Sherehe ya kamusi 3 Faida za kamusi 4 Dhima ya picha katika kamusi 5 Marejeo 6 Tazama pia 7 Viungo vya nje Aina za kamusi | Kuna aina mbalimbali za kamusi ambazo n...
Read more

SQL error code 1064 with creating Laravel foreign keysForeign key constraints: When to use ON UPDATE and ON DELETEDropping column with foreign key Laravel error: General error: 1025 Error on renameLaravel SQL Can't create tableLaravel Migration foreign key errorLaravel php artisan migrate:refresh giving a syntax errorSQLSTATE[42S01]: Base table or view already exists or Base table or view already exists: 1050 Tableerror in migrating laravel file to xampp serverSyntax error or access violation: 1064:syntax to use near 'unsigned not null, modelName varchar(191) not null, title varchar(191) not nLaravel cannot create new table field in mysqlLaravel 5.7:Last migration creates table but is not registered in the migration table

Image
Does a multiclassed wizard start with a spellbook? Minimizing medical costs with HSA Boss has banned cycling to work because he thinks it's unsafe Is there a typical layout to blocking installed for backing in new construction framing? In the Seventh Seal why does Death let the chess game happen? Why has Novell never written its own boot loader? Should I warn my boss I might take sick leave Why is the saxophone not common in classical repertoire? Is it possible to spoof an IP address to an exact number? Motorcyle Chain needs to be cleaned every time you lube it? Bypass with wrong cvv of debit card and getting OTP Do we have a much compact and generalized version of erase–remove idiom? how can i make this execution plan more efficient? Why did moving the mouse cursor cause Windows 95 to run more quickly? What's the big deal about the Nazgûl losing their horses? Has chattel slavery ever been used as a criminal punishment in the USA since the passag...
Read more

은진 송씨 목차 역사 본관 분파 인물 조선 왕실과의 인척 관계 집성촌 항렬자 인구 같이 보기 각주 둘러보기 메뉴은진 송씨세종실록 149권, 지리지 충청도 공주목 은진현

Image
송씨은진 송씨충청남도 소재 성씨논산시 충청남도논산시은진면한국의 성씨고려송명의회덕 황씨류준고흥 류씨송유조선송준길문묘송시열좌의정문묘종묘송준길송규렴송상기송시열송인수송환기송치규송근수충청남도논산시은진면백제757년충청남도은진군논산군논산시은진면송유 은...
Read more