MSDataSetGenerator fails to generate dataset

  • Thread starter Thread starter Crazy Cat
  • Start date Start date
C

Crazy Cat

I am developing a winforms application in Visual Studio 2005. The
applicaiton is written in Visual Basic.

I have a dataset created with the dataset designer. The dataset has
about 10 datatables and dataadapters.

Just the other day I found that the dataset was not compiling.

Here's the dataset

<?xml version="1.0" encoding="utf-8"?>
<xs:schema id="FCASTDataSet" targetNamespace="http://tempuri.org/
FCASTDataSet.xsd" xmlns:mstns="http://tempuri.org/FCASTDataSet.xsd"
xmlns="http://tempuri.org/FCASTDataSet.xsd" xmlns:xs="http://
www.w3.org/2001/XMLSchema" xmlns:msdata="urn:schemas-microsoft-com:xml-
msdata" xmlns:msprop="urn:schemas-microsoft-com:xml-msprop"
attributeFormDefault="qualified" elementFormDefault="qualified">
<xs:annotation>
<xs:appinfo source="urn:schemas-microsoft-com:xml-msdatasource">
<DataSource DefaultConnectionIndex="1"
FunctionsComponentName="QueriesTableAdapter"
GeneratorFunctionsComponentClassName="QueriesTableAdapter"
Modifier="AutoLayout, AnsiClass, Class, Public"
SchemaSerializationMode="IncludeSchema"
UserFunctionsComponentName="QueriesTableAdapter" xmlns="urn:schemas-
microsoft-com:xml-msdatasource">
<Connections>
<Connection AppSettingsObjectName="MySettings"
AppSettingsPropertyName="FCASTConnectionString"
IsAppSettingsProperty="True" Modifier="Assembly"
Name="FCASTConnectionString (MySettings)" ParameterPrefix="@"
PropertyReference="ApplicationSettings.FCAST.My.MySettings.GlobalReference.Default.FCASTConnectionString"
Provider="System.Data.SqlClient">
</Connection>
<Connection AppSettingsObjectName="MySettings"
AppSettingsPropertyName="FCastConnectionString"
ConnectionStringObject="" IsAppSettingsProperty="True"
Modifier="Assembly" Name="FCastConnectionString (MySettings)"
ParameterPrefix="@"
PropertyReference="ApplicationSettings.FCAST.My.MySettings.GlobalReference.Default.FCastConnectionString"
Provider="System.Data.SqlClient">
</Connection>
</Connections>
<Tables>
<TableAdapter BaseClass="System.ComponentModel.Component"
DataAccessorModifier="AutoLayout, AnsiClass, Class, Public"
DataAccessorName="StructureTypesTableAdapter"
GeneratorDataComponentClassName="StructureTypesTableAdapter"
Name="StructureTypes"
UserDataComponentName="StructureTypesTableAdapter">
<MainSource>
<DbSource ConnectionRef="FCastConnectionString
(MySettings)" DbObjectName="FCast.CAT.usp_select_StructureTypes"
DbObjectType="StoredProcedure" FillMethodModifier="Public"
FillMethodName="Fill" GenerateMethods="Both"
GenerateShortCommands="False" GeneratorGetMethodName="GetData"
GeneratorSourceName="Fill" GetMethodModifier="Public"
GetMethodName="GetData" QueryType="Rowset"
ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0,
Culture=neutral, PublicKeyToken=b77a5c561934e089"
UseOptimisticConcurrency="False" UserGetMethodName="GetData"
UserSourceName="Fill">
<SelectCommand>
<DbCommand CommandType="StoredProcedure"
ModifiedByUser="False">
<CommandText>CAT.usp_select_StructureTypes</
CommandText>
<Parameters>
<Parameter AllowDbNull="True"
AutogeneratedName="" DataSourceName="" DbType="Int32"
Direction="ReturnValue" ParameterName="@RETURN_VALUE" Precision="10"
ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="False"
SourceVersion="Current">
</Parameter>
<Parameter AllowDbNull="True"
AutogeneratedName="" DataSourceName="" DbType="AnsiStringFixedLength"
Direction="Input" ParameterName="@StructureType" Precision="0"
ProviderType="Char" Scale="0" Size="1" SourceColumnNullMapping="False"
SourceVersion="Current">
</Parameter>
<Parameter AllowDbNull="True"
AutogeneratedName="" DataSourceName="" DbType="AnsiStringFixedLength"
Direction="Input" ParameterName="@BusinessType" Precision="0"
ProviderType="Char" Scale="0" Size="1" SourceColumnNullMapping="False"
SourceVersion="Current">
</Parameter>
</Parameters>
</DbCommand>
</SelectCommand>
</DbSource>
</MainSource>
<Mappings>
<Mapping SourceColumn="StructureTypeId"
DataSetColumn="StructureTypeId" />
<Mapping SourceColumn="StructureCode"
DataSetColumn="StructureCode" />
<Mapping SourceColumn="StructureName"
DataSetColumn="StructureName" />
<Mapping SourceColumn="StructureDescr"
DataSetColumn="StructureDescr" />
<Mapping SourceColumn="StructureType"
DataSetColumn="StructureType" />
<Mapping SourceColumn="Constant"
DataSetColumn="Constant" />
<Mapping SourceColumn="Parent" DataSetColumn="Parent" />
<Mapping SourceColumn="DimLevel"
DataSetColumn="DimLevel" />
</Mappings>
<Sources>
<DbSource ConnectionRef="FCastConnectionString
(MySettings)" DbObjectName="[C:\NET\PROJECTS\FCAST\FCAST
\FCAST.MDF].CAT.usp_select_all_StructureTypes"
DbObjectType="StoredProcedure" FillMethodModifier="Public"
FillMethodName="FillAll" GenerateMethods="Both"
GenerateShortCommands="True" GeneratorGetMethodName="GetAll"
GeneratorSourceName="FillAll" GetMethodModifier="Public"
GetMethodName="GetAll" QueryType="Rowset"
ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0,
Culture=neutral, PublicKeyToken=b77a5c561934e089"
UseOptimisticConcurrency="True" UserGetMethodName="GetAll"
UserSourceName="FillAll">
<SelectCommand>
<DbCommand CommandType="StoredProcedure"
ModifiedByUser="False">
<CommandText>CAT.usp_select_all_StructureTypes</
CommandText>
<Parameters>
<Parameter AllowDbNull="True"
AutogeneratedName="" DataSourceName="" DbType="Int32"
Direction="ReturnValue" ParameterName="@RETURN_VALUE" Precision="10"
ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="False"
SourceVersion="Current">
</Parameter>
</Parameters>
</DbCommand>
</SelectCommand>
</DbSource>
<DbSource ConnectionRef="FCastConnectionString
(MySettings)" DbObjectName="FCast.CAT.usp_select_StructureTypeById"
DbObjectType="StoredProcedure" FillMethodModifier="Public"
FillMethodName="FillById" GenerateMethods="Both"
GenerateShortCommands="True" GeneratorGetMethodName="GetDataById"
GeneratorSourceName="FillById" GetMethodModifier="Public"
GetMethodName="GetDataById" QueryType="Rowset"
ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0,
Culture=neutral, PublicKeyToken=b77a5c561934e089"
UseOptimisticConcurrency="True" UserGetMethodName="GetDataById"
UserSourceName="FillById">
<SelectCommand>
<DbCommand CommandType="StoredProcedure"
ModifiedByUser="False">
<CommandText>CAT.usp_select_StructureTypeById</
CommandText>
<Parameters>
<Parameter AllowDbNull="True"
AutogeneratedName="" DataSourceName="" DbType="Int32"
Direction="ReturnValue" ParameterName="@RETURN_VALUE" Precision="10"
ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="False"
SourceVersion="Current">
</Parameter>
<Parameter AllowDbNull="True"
AutogeneratedName="" DataSourceName="" DbType="Int32"
Direction="Input" ParameterName="@StructureTypeId" Precision="10"
ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="False"
SourceVersion="Current">
</Parameter>
</Parameters>
</DbCommand>
</SelectCommand>
</DbSource>
<DbSource ConnectionRef="FCastConnectionString
(MySettings)" DbObjectName="FCast.CAT.usp_select_primary_struct"
DbObjectType="StoredProcedure" FillMethodModifier="Public"
FillMethodName="FillPrimaryStructures" GenerateMethods="Both"
GenerateShortCommands="True"
GeneratorGetMethodName="GetPrimaryStructures"
GeneratorSourceName="FillPrimaryStructures" GetMethodModifier="Public"
GetMethodName="GetPrimaryStructures" QueryType="Rowset"
ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0,
Culture=neutral, PublicKeyToken=b77a5c561934e089"
UseOptimisticConcurrency="True"
UserGetMethodName="GetPrimaryStructures"
UserSourceName="FillPrimaryStructures">
<SelectCommand>
<DbCommand CommandType="StoredProcedure"
ModifiedByUser="False">
<CommandText>CAT.usp_select_primary_struct</
CommandText>
<Parameters>
<Parameter AllowDbNull="True"
AutogeneratedName="" DataSourceName="" DbType="Int32"
Direction="ReturnValue" ParameterName="@RETURN_VALUE" Precision="10"
ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="False"
SourceVersion="Current">
</Parameter>
</Parameters>
</DbCommand>
</SelectCommand>
</DbSource>
</Sources>
</TableAdapter>
<TableAdapter BaseClass="System.ComponentModel.Component"
DataAccessorModifier="AutoLayout, AnsiClass, Class, Public"
DataAccessorName="BuildingComponentsTableAdapter"
GeneratorDataComponentClassName="BuildingComponentsTableAdapter"
Name="BuildingComponents"
UserDataComponentName="BuildingComponentsTableAdapter">
<MainSource>
<DbSource ConnectionRef="FCastConnectionString
(MySettings)" DbObjectName="FCast.CAT.usp_select_BuildingComponents"
DbObjectType="StoredProcedure" FillMethodModifier="Public"
FillMethodName="Fill" GenerateMethods="Both"
GenerateShortCommands="True" GeneratorGetMethodName="GetData"
GeneratorSourceName="Fill" GetMethodModifier="Public"
GetMethodName="GetData" QueryType="Rowset"
ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0,
Culture=neutral, PublicKeyToken=b77a5c561934e089"
UseOptimisticConcurrency="True" UserGetMethodName="GetData"
UserSourceName="Fill">
<DeleteCommand>
<DbCommand CommandType="StoredProcedure"
ModifiedByUser="False">
<CommandText>CAT.usp_delete_buildingComponents</
CommandText>
<Parameters>
<Parameter AllowDbNull="True"
AutogeneratedName="" DataSourceName="" DbType="Int32"
Direction="ReturnValue" ParameterName="@RETURN_VALUE" Precision="10"
ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="False"
SourceVersion="Current">
</Parameter>
<Parameter AllowDbNull="True"
AutogeneratedName="" DataSourceName="" DbType="Int32"
Direction="Input" ParameterName="@BuildingId" Precision="10"
ProviderType="Int" Scale="0" Size="4" SourceColumn="BuildingId"
SourceColumnNullMapping="False" SourceVersion="Current">
</Parameter>
</Parameters>
</DbCommand>
</DeleteCommand>
<InsertCommand>
<DbCommand CommandType="StoredProcedure"
ModifiedByUser="False">
<CommandText>CAT.usp_insert_buildingComponent</
CommandText>
<Parameters>
<Parameter AllowDbNull="True"
AutogeneratedName="" DataSourceName="" DbType="Int32"
Direction="ReturnValue" ParameterName="@RETURN_VALUE" Precision="10"
ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="False"
SourceVersion="Current">
</Parameter>
<Parameter AllowDbNull="True"
AutogeneratedName="" DataSourceName="" DbType="Int32"
Direction="Input" ParameterName="@BuildingId" Precision="10"
ProviderType="Int" Scale="0" Size="4" SourceColumn="BuildingId"
SourceColumnNullMapping="False" SourceVersion="Current">
</Parameter>
<Parameter AllowDbNull="True"
AutogeneratedName="" DataSourceName="" DbType="Int32"
Direction="Input" ParameterName="@ComponentId" Precision="10"
ProviderType="Int" Scale="0" Size="4" SourceColumn="ComponentId"
SourceColumnNullMapping="False" SourceVersion="Current">
</Parameter>
<Parameter AllowDbNull="True"
AutogeneratedName="" DataSourceName="" DbType="Byte" Direction="Input"
ParameterName="@Priority" Precision="3" ProviderType="TinyInt"
Scale="0" Size="1" SourceColumn="Priority"
SourceColumnNullMapping="False" SourceVersion="Current">
</Parameter>
<Parameter AllowDbNull="True"
AutogeneratedName="" DataSourceName="" DbType="Decimal"
Direction="Input" ParameterName="@ComponentBD_Percent" Precision="9"
ProviderType="Decimal" Scale="6" Size="5"
SourceColumn="ComponentBD_Percent" SourceColumnNullMapping="False"
SourceVersion="Current">
</Parameter>
<Parameter AllowDbNull="True"
AutogeneratedName="" DataSourceName="" DbType="DateTime"
Direction="Input" ParameterName="@ComponentDt" Precision="23"
ProviderType="DateTime" Scale="3" Size="8" SourceColumn="ComponentDt"
SourceColumnNullMapping="False" SourceVersion="Current">
</Parameter>
<Parameter AllowDbNull="True"
AutogeneratedName="" DataSourceName="" DbType="Int16"
Direction="Input" ParameterName="@EUL" Precision="5"
ProviderType="SmallInt" Scale="0" Size="2" SourceColumn="EUL"
SourceColumnNullMapping="False" SourceVersion="Current">
</Parameter>
<Parameter AllowDbNull="True"
AutogeneratedName="" DataSourceName="" DbType="Currency"
Direction="Input" ParameterName="@RepairVal" Precision="19"
ProviderType="Money" Scale="4" Size="8" SourceColumn="RepairVal"
SourceColumnNullMapping="False" SourceVersion="Current">
</Parameter>
<Parameter AllowDbNull="True"
AutogeneratedName="" DataSourceName="" DbType="Decimal"
Direction="Input" ParameterName="@Repair_Percent" Precision="9"
ProviderType="Decimal" Scale="8" Size="5"
SourceColumn="Repair_Percent" SourceColumnNullMapping="False"
SourceVersion="Current">
</Parameter>
<Parameter AllowDbNull="True"
AutogeneratedName="" DataSourceName="" DbType="Boolean"
Direction="Input" ParameterName="@RepairChosen" Precision="1"
ProviderType="Bit" Scale="0" Size="1" SourceColumn="RepairChosen"
SourceColumnNullMapping="False" SourceVersion="Current">
</Parameter>
<Parameter AllowDbNull="True"
AutogeneratedName="" DataSourceName="" DbType="AnsiStringFixedLength"
Direction="Input" ParameterName="@Action" Precision="0"
ProviderType="Char" Scale="0" Size="1" SourceColumn="Action"
SourceColumnNullMapping="False" SourceVersion="Current">
</Parameter>
</Parameters>
</DbCommand>
</InsertCommand>
<SelectCommand>
<DbCommand CommandType="StoredProcedure"
ModifiedByUser="False">
<CommandText>CAT.usp_select_BuildingComponents</
CommandText>
<Parameters>
<Parameter AllowDbNull="True"
AutogeneratedName="" DataSourceName="" DbType="Int32"
Direction="ReturnValue" ParameterName="@RETURN_VALUE" Precision="10"
ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="False"
SourceVersion="Current">
</Parameter>
<Parameter AllowDbNull="True"
AutogeneratedName="" DataSourceName="" DbType="Int16"
Direction="Input" ParameterName="@BuildingId" Precision="5"
ProviderType="SmallInt" Scale="0" Size="2"
SourceColumnNullMapping="False" SourceVersion="Current">
</Parameter>
</Parameters>
</DbCommand>
</SelectCommand>
<UpdateCommand>
<DbCommand CommandType="StoredProcedure"
ModifiedByUser="False">
<CommandText>CAT.usp_update_buildingComponent</
CommandText>
<Parameters>
<Parameter AllowDbNull="True"
AutogeneratedName="" DataSourceName="" DbType="Int32"
Direction="ReturnValue" ParameterName="@RETURN_VALUE" Precision="10"
ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="False"
SourceVersion="Current">
</Parameter>
<Parameter AllowDbNull="True"
AutogeneratedName="" DataSourceName="" DbType="Int32"
Direction="Input" ParameterName="@BuildingId" Precision="10"
ProviderType="Int" Scale="0" Size="4" SourceColumn="BuildingId"
SourceColumnNullMapping="False" SourceVersion="Current">
</Parameter>
<Parameter AllowDbNull="True"
AutogeneratedName="" DataSourceName="" DbType="Int32"
Direction="Input" ParameterName="@ComponentId" Precision="10"
ProviderType="Int" Scale="0" Size="4" SourceColumn="ComponentId"
SourceColumnNullMapping="False" SourceVersion="Current">
</Parameter>
<Parameter AllowDbNull="True"
AutogeneratedName="" DataSourceName="" DbType="Byte" Direction="Input"
ParameterName="@Priority" Precision="3" ProviderType="TinyInt"
Scale="0" Size="1" SourceColumn="Priority"
SourceColumnNullMapping="False" SourceVersion="Current">
</Parameter>
<Parameter AllowDbNull="True"
AutogeneratedName="" DataSourceName="" DbType="Decimal"
Direction="Input" ParameterName="@ComponentBD_Percent" Precision="9"
ProviderType="Decimal" Scale="6" Size="5"
SourceColumn="ComponentBD_Percent" SourceColumnNullMapping="False"
SourceVersion="Current">
</Parameter>
<Parameter AllowDbNull="True"
AutogeneratedName="" DataSourceName="" DbType="Int16"
Direction="Input" ParameterName="@EUL" Precision="5"
ProviderType="SmallInt" Scale="0" Size="2" SourceColumn="EUL"
SourceColumnNullMapping="False" SourceVersion="Current">
</Parameter>
<Parameter AllowDbNull="True"
AutogeneratedName="" DataSourceName="" DbType="DateTime"
Direction="Input" ParameterName="@ComponentDt" Precision="23"
ProviderType="DateTime" Scale="3" Size="8" SourceColumn="ComponentDt"
SourceColumnNullMapping="False" SourceVersion="Current">
</Parameter>
<Parameter AllowDbNull="True"
AutogeneratedName="" DataSourceName="" DbType="Currency"
Direction="Input" ParameterName="@RepairVal" Precision="19"
ProviderType="Money" Scale="4" Size="8" SourceColumn="RepairVal"
SourceColumnNullMapping="False" SourceVersion="Current">
</Parameter>
<Parameter AllowDbNull="True"
AutogeneratedName="" DataSourceName="" DbType="Decimal"
Direction="Input" ParameterName="@Repair_Percent" Precision="9"
ProviderType="Decimal" Scale="8" Size="5"
SourceColumn="Repair_Percent" SourceColumnNullMapping="False"
SourceVersion="Current">
</Parameter>
<Parameter AllowDbNull="True"
AutogeneratedName="" DataSourceName="" DbType="Boolean"
Direction="Input" ParameterName="@RepairChosen" Precision="1"
ProviderType="Bit" Scale="0" Size="1" SourceColumn="RepairChosen"
SourceColumnNullMapping="False" SourceVersion="Current">
</Parameter>
<Parameter AllowDbNull="True"
AutogeneratedName="" DataSourceName="" DbType="AnsiStringFixedLength"
Direction="Input" ParameterName="@Action" Precision="0"
ProviderType="Char" Scale="0" Size="1" SourceColumn="Action"
SourceColumnNullMapping="False" SourceVersion="Current">
</Parameter>
</Parameters>
</DbCommand>
</UpdateCommand>
</DbSource>
</MainSource>
<Mappings>
<Mapping SourceColumn="BuildingId"
DataSetColumn="BuildingId" />
<Mapping SourceColumn="ComponentId"
DataSetColumn="ComponentId" />
<Mapping SourceColumn="Priority"
DataSetColumn="Priority" />
<Mapping SourceColumn="ComponentCode"
DataSetColumn="ComponentCode" />
<Mapping SourceColumn="ComponentName"
DataSetColumn="ComponentName" />
<Mapping SourceColumn="ComponentBD_Percent"
DataSetColumn="ComponentBD_Percent" />
<Mapping SourceColumn="EUL" DataSetColumn="EUL" />
<Mapping SourceColumn="RepairVal"
DataSetColumn="RepairVal" />
<Mapping SourceColumn="RepairChosen"
DataSetColumn="RepairChosen" />
<Mapping SourceColumn="CoefficientRoot"
DataSetColumn="CoefficientRoot" />
<Mapping SourceColumn="Action" DataSetColumn="Action" />
<Mapping SourceColumn="Repair_Percent"
DataSetColumn="Repair_Percent" />
<Mapping SourceColumn="ComponentDt"
DataSetColumn="ComponentDt" />
</Mappings>
<Sources>
</Sources>
</TableAdapter>
<TableAdapter BaseClass="System.ComponentModel.Component"
DataAccessorModifier="AutoLayout, AnsiClass, Class, Public"
DataAccessorName="BuildingComponentsByTypeTableAdapter"
GeneratorDataComponentClassName="BuildingComponentsByTypeTableAdapter"
Name="BuildingComponentsByType"
UserDataComponentName="BuildingComponentsByTypeTableAdapter">
<MainSource>
<DbSource ConnectionRef="FCastConnectionString
(MySettings)"
DbObjectName="FCast.CAT.usp_select_BuildingComponentsByType"
DbObjectType="StoredProcedure" FillMethodModifier="Public"
FillMethodName="Fill" GenerateMethods="Both"
GenerateShortCommands="False" GeneratorGetMethodName="GetData"
GeneratorSourceName="Fill" GetMethodModifier="Public"
GetMethodName="GetData" QueryType="Rowset"
ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0,
Culture=neutral, PublicKeyToken=b77a5c561934e089"
UseOptimisticConcurrency="False" UserGetMethodName="GetData"
UserSourceName="Fill">
<SelectCommand>
<DbCommand CommandType="StoredProcedure"
ModifiedByUser="False">

<CommandText>CAT.usp_select_BuildingComponentsByType</CommandText>
<Parameters>
<Parameter AllowDbNull="True"
AutogeneratedName="" DataSourceName="" DbType="Int32"
Direction="ReturnValue" ParameterName="@RETURN_VALUE" Precision="10"
ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="False"
SourceVersion="Current">
</Parameter>
<Parameter AllowDbNull="True"
AutogeneratedName="" DataSourceName="" DbType="Int16"
Direction="Input" ParameterName="@StructureTypeId" Precision="5"
ProviderType="SmallInt" Scale="0" Size="2"
SourceColumnNullMapping="False" SourceVersion="Current">
</Parameter>
</Parameters>
</DbCommand>
</SelectCommand>
</DbSource>
</MainSource>
<Mappings>
<Mapping SourceColumn="ComponentId"
DataSetColumn="ComponentId" />
<Mapping SourceColumn="ComponentCode"
DataSetColumn="ComponentCode" />
<Mapping SourceColumn="ComponentName"
DataSetColumn="ComponentName" />
<Mapping SourceColumn="Priority"
DataSetColumn="Priority" />
<Mapping SourceColumn="StructureTypeId"
DataSetColumn="StructureTypeId" />
<Mapping SourceColumn="EUL" DataSetColumn="EUL" />
<Mapping SourceColumn="PUC" DataSetColumn="PUC" />
<Mapping SourceColumn="CoefficientRoot"
DataSetColumn="CoefficientRoot" />
</Mappings>
<Sources>
</Sources>
</TableAdapter>
<TableAdapter BaseClass="System.ComponentModel.Component"
DataAccessorModifier="AutoLayout, AnsiClass, Class, Public"
DataAccessorName="CountriesTableAdapter"
GeneratorDataComponentClassName="CountriesTableAdapter"
Name="Countries" UserDataComponentName="CountriesTableAdapter">
<MainSource>
<DbSource ConnectionRef="FCastConnectionString
(MySettings)" DbObjectName="FCast.CAT.usp_select_countries"
DbObjectType="StoredProcedure" FillMethodModifier="Public"
FillMethodName="Fill" GenerateMethods="Both"
GenerateShortCommands="False" GeneratorGetMethodName="GetData"
GeneratorSourceName="Fill" GetMethodModifier="Public"
GetMethodName="GetData" QueryType="Rowset"
ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0,
Culture=neutral, PublicKeyToken=b77a5c561934e089"
UseOptimisticConcurrency="False" UserGetMethodName="GetData"
UserSourceName="Fill">
<SelectCommand>
<DbCommand CommandType="StoredProcedure"
ModifiedByUser="False">
<CommandText>CAT.usp_select_countries</
CommandText>
<Parameters>
<Parameter AllowDbNull="True"
AutogeneratedName="" DataSourceName="" DbType="Int32"
Direction="ReturnValue" ParameterName="@RETURN_VALUE" Precision="10"
ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="False"
SourceVersion="Current">
</Parameter>
</Parameters>
</DbCommand>
</SelectCommand>
</DbSource>
</MainSource>
<Mappings>
<Mapping SourceColumn="CountryID"
DataSetColumn="CountryID" />
<Mapping SourceColumn="RegionID"
DataSetColumn="RegionID" />
<Mapping SourceColumn="CountryCode"
DataSetColumn="CountryCode" />
<Mapping SourceColumn="CountryName"
DataSetColumn="CountryName" />
<Mapping SourceColumn="Recognized"
DataSetColumn="Recognized" />
</Mappings>
<Sources>
</Sources>
</TableAdapter>
<TableAdapter BaseClass="System.ComponentModel.Component"
DataAccessorModifier="AutoLayout, AnsiClass, Class, Public"
DataAccessorName="ProvincesTableAdapter"
GeneratorDataComponentClassName="ProvincesTableAdapter"
Name="Provinces" UserDataComponentName="ProvincesTableAdapter">
<MainSource>
<DbSource ConnectionRef="FCastConnectionString
(MySettings)" DbObjectName="FCast.CAT.usp_select_provinces"
DbObjectType="StoredProcedure" FillMethodModifier="Public"
FillMethodName="Fill" GenerateMethods="Both"
GenerateShortCommands="False" GeneratorGetMethodName="GetData"
GeneratorSourceName="Fill" GetMethodModifier="Public"
GetMethodName="GetData" QueryType="Rowset"
ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0,
Culture=neutral, PublicKeyToken=b77a5c561934e089"
UseOptimisticConcurrency="False" UserGetMethodName="GetData"
UserSourceName="Fill">
<SelectCommand>
<DbCommand CommandType="StoredProcedure"
ModifiedByUser="False">
<CommandText>CAT.usp_select_provinces</
CommandText>
<Parameters>
<Parameter AllowDbNull="True"
AutogeneratedName="" DataSourceName="" DbType="Int32"
Direction="ReturnValue" ParameterName="@RETURN_VALUE" Precision="10"
ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="False"
SourceVersion="Current">
</Parameter>
<Parameter AllowDbNull="True"
AutogeneratedName="" DataSourceName="" DbType="Int32"
Direction="Input" ParameterName="@CountryID" Precision="10"
ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="False"
SourceVersion="Current">
</Parameter>
</Parameters>
</DbCommand>
</SelectCommand>
</DbSource>
</MainSource>
<Mappings>
<Mapping SourceColumn="ProvinceID"
DataSetColumn="ProvinceID" />
<Mapping SourceColumn="CountryID"
DataSetColumn="CountryID" />
<Mapping SourceColumn="ProvinceCode"
DataSetColumn="ProvinceCode" />
<Mapping SourceColumn="ProvinceName"
DataSetColumn="ProvinceName" />
</Mappings>
<Sources>
</Sources>
</TableAdapter>
<TableAdapter BaseClass="System.ComponentModel.Component"
DataAccessorModifier="AutoLayout, AnsiClass, Class, Public"
DataAccessorName="buildingsTableAdapter"
GeneratorDataComponentClassName="buildingsTableAdapter"
Name="buildings" UserDataComponentName="buildingsTableAdapter">
<MainSource>
<DbSource ConnectionRef="FCastConnectionString
(MySettings)" DbObjectName="FCast.CAT.usp_select_buildings"
DbObjectType="StoredProcedure" FillMethodModifier="Public"
FillMethodName="Fill" GenerateMethods="Both"
GenerateShortCommands="True" GeneratorGetMethodName="GetData"
GeneratorSourceName="Fill" GetMethodModifier="Public"
GetMethodName="GetData" QueryType="Rowset"
ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0,
Culture=neutral, PublicKeyToken=b77a5c561934e089"
UseOptimisticConcurrency="True" UserGetMethodName="GetData"
UserSourceName="Fill">
<DeleteCommand>
<DbCommand CommandType="StoredProcedure"
ModifiedByUser="False">
<CommandText>CAT.usp_delete_building</CommandText>
<Parameters>
<Parameter AllowDbNull="True"
AutogeneratedName="" DataSourceName="" DbType="Int32"
Direction="ReturnValue" ParameterName="@RETURN_VALUE" Precision="10"
ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="False"
SourceVersion="Current">
</Parameter>
<Parameter AllowDbNull="True"
AutogeneratedName="" DataSourceName="" DbType="Int32"
Direction="Input" ParameterName="@BuildingId" Precision="10"
ProviderType="Int" Scale="0" Size="4" SourceColumn="BuildingId"
SourceColumnNullMapping="False" SourceVersion="Current">
</Parameter>
</Parameters>
</DbCommand>
</DeleteCommand>
<InsertCommand>
<DbCommand CommandType="StoredProcedure"
ModifiedByUser="False">
<CommandText>CAT.usp_insert_building</CommandText>
<Parameters>
<Parameter AllowDbNull="True"
AutogeneratedName="" DataSourceName="" DbType="Int32"
Direction="ReturnValue" ParameterName="@RETURN_VALUE" Precision="10"
ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="False"
SourceVersion="Current">
</Parameter>
<Parameter AllowDbNull="True"
AutogeneratedName="" DataSourceName="" DbType="AnsiString"
Direction="Input" ParameterName="@AssetID" Precision="0"
ProviderType="VarChar" Scale="0" Size="10" SourceColumn="AssetID"
SourceColumnNullMapping="False" SourceVersion="Current">
</Parameter>
<Parameter AllowDbNull="True"
AutogeneratedName="" DataSourceName="" DbType="AnsiStringFixedLength"
Direction="Input" ParameterName="@BusinessType" Precision="0"
ProviderType="Char" Scale="0" Size="1" SourceColumn="BusinessType"
SourceColumnNullMapping="False" SourceVersion="Current">
</Parameter>
<Parameter AllowDbNull="True"
AutogeneratedName="" DataSourceName="" DbType="String"
Direction="Input" ParameterName="@BuildingName" Precision="0"
ProviderType="NVarChar" Scale="0" Size="50"
SourceColumn="BuildingName" SourceColumnNullMapping="False"
SourceVersion="Current">
</Parameter>
<Parameter AllowDbNull="True"
AutogeneratedName="" DataSourceName="" DbType="String"
Direction="Input" ParameterName="@address" Precision="0"
ProviderType="NVarChar" Scale="0" Size="50" SourceColumn="Address"
SourceColumnNullMapping="False" SourceVersion="Current">
</Parameter>
<Parameter AllowDbNull="True"
AutogeneratedName="" DataSourceName="" DbType="String"
Direction="Input" ParameterName="@City" Precision="0"
ProviderType="NVarChar" Scale="0" Size="50" SourceColumn="City"
SourceColumnNullMapping="False" SourceVersion="Current">
</Parameter>
<Parameter AllowDbNull="True"
AutogeneratedName="" DataSourceName="" DbType="Int16"
Direction="Input" ParameterName="@ProvinceID" Precision="5"
ProviderType="SmallInt" Scale="0" Size="2" SourceColumn="ProvinceID"
SourceColumnNullMapping="False" SourceVersion="Current">
</Parameter>
<Parameter AllowDbNull="True"
AutogeneratedName="" DataSourceName="" DbType="AnsiString"
Direction="Input" ParameterName="@ZipCode" Precision="0"
ProviderType="VarChar" Scale="0" Size="10" SourceColumn="ZipCode"
SourceColumnNullMapping="False" SourceVersion="Current">
</Parameter>
<Parameter AllowDbNull="True"
AutogeneratedName="" DataSourceName="" DbType="Int16"
Direction="Input" ParameterName="@CountryID" Precision="5"
ProviderType="SmallInt" Scale="0" Size="2" SourceColumn="CountryID"
SourceColumnNullMapping="False" SourceVersion="Current">
</Parameter>
<Parameter AllowDbNull="True"
AutogeneratedName="" DataSourceName="" DbType="Int16"
Direction="Input" ParameterName="@StructureTypeId" Precision="5"
ProviderType="SmallInt" Scale="0" Size="2"
SourceColumn="StructureTypeId" SourceColumnNullMapping="False"
SourceVersion="Current">
</Parameter>
<Parameter AllowDbNull="True"
AutogeneratedName="" DataSourceName="" DbType="DateTime"
Direction="Input" ParameterName="@ConstructDt" Precision="23"
ProviderType="DateTime" Scale="3" Size="8" SourceColumn="ConstructDt"
SourceColumnNullMapping="False" SourceVersion="Current">
</Parameter>
<Parameter AllowDbNull="True"
AutogeneratedName="" DataSourceName="" DbType="DateTime"
Direction="Input" ParameterName="@RenovateDt" Precision="23"
ProviderType="DateTime" Scale="3" Size="8" SourceColumn="RenovateDt"
SourceColumnNullMapping="False" SourceVersion="Current">
</Parameter>
<Parameter AllowDbNull="True"
AutogeneratedName="" DataSourceName="" DbType="Currency"
Direction="Input" ParameterName="@ReplaceVal" Precision="19"
ProviderType="Money" Scale="4" Size="8" SourceColumn="ReplaceVal"
SourceColumnNullMapping="False" SourceVersion="Current">
</Parameter>
<Parameter AllowDbNull="True"
AutogeneratedName="" DataSourceName="" DbType="Boolean"
Direction="Input" ParameterName="@VisualAssessCompleted" Precision="1"
ProviderType="Bit" Scale="0" Size="1"
SourceColumn="VisualAssessCompleted" SourceColumnNullMapping="False"
SourceVersion="Current">
</Parameter>
<Parameter AllowDbNull="True"
AutogeneratedName="" DataSourceName="" DbType="DateTime"
Direction="Input" ParameterName="@VisualAssessDt" Precision="23"
ProviderType="DateTime" Scale="3" Size="8"
SourceColumn="VisualAssessDt" SourceColumnNullMapping="False"
SourceVersion="Current">
</Parameter>
<Parameter AllowDbNull="True"
AutogeneratedName="" DataSourceName="" DbType="Decimal"
Direction="Input" ParameterName="@VisualAssessScore" Precision="9"
ProviderType="Decimal" Scale="6" Size="5"
SourceColumn="VisualAssessScore" SourceColumnNullMapping="False"
SourceVersion="Current">
</Parameter>
<Parameter AllowDbNull="True"
AutogeneratedName="" DataSourceName="" DbType="Decimal"
Direction="Input" ParameterName="@ConditionIndex" Precision="9"
ProviderType="Decimal" Scale="6" Size="5"
SourceColumn="ConditionIndex" SourceColumnNullMapping="False"
SourceVersion="Current">
</Parameter>
<Parameter AllowDbNull="True"
AutogeneratedName="" DataSourceName="" DbType="Int32"
Direction="InputOutput" ParameterName="@BuildingId" Precision="10"
ProviderType="Int" Scale="0" Size="4" SourceColumn="BuildingId"
SourceColumnNullMapping="False" SourceVersion="Current">
</Parameter>
</Parameters>
</DbCommand>
</InsertCommand>
<SelectCommand>
<DbCommand CommandType="StoredProcedure"
ModifiedByUser="False">
<CommandText>CAT.usp_select_buildings</
CommandText>
<Parameters>
<Parameter AllowDbNull="True"
AutogeneratedName="" DataSourceName="" DbType="Int32"
Direction="ReturnValue" ParameterName="@RETURN_VALUE" Precision="10"
ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="False"
SourceVersion="Current">
</Parameter>
<Parameter AllowDbNull="True"
AutogeneratedName="" DataSourceName="" DbType="Int32"
Direction="Input" ParameterName="@BuildingId" Precision="10"
ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="False"
SourceVersion="Current">
</Parameter>
</Parameters>
</DbCommand>
</SelectCommand>
<UpdateCommand>
<DbCommand CommandType="StoredProcedure"
ModifiedByUser="False">
<CommandText>CAT.usp_update_building</CommandText>
<Parameters>
<Parameter AllowDbNull="True"
AutogeneratedName="" DataSourceName="" DbType="Int32"
Direction="ReturnValue" ParameterName="@RETURN_VALUE" Precision="10"
ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="False"
SourceVersion="Current">
</Parameter>
<Parameter AllowDbNull="True"
AutogeneratedName="" DataSourceName="" DbType="Int32"
Direction="Input" ParameterName="@BuildingId" Precision="10"
ProviderType="Int" Scale="0" Size="4" SourceColumn="BuildingId"
SourceColumnNullMapping="False" SourceVersion="Current">
</Parameter>
<Parameter AllowDbNull="True"
AutogeneratedName="" DataSourceName="" DbType="AnsiString"
Direction="Input" ParameterName="@AssetID" Precision="0"
ProviderType="VarChar" Scale="0" Size="10" SourceColumn="AssetID"
SourceColumnNullMapping="False" SourceVersion="Current">
</Parameter>
<Parameter AllowDbNull="True"
AutogeneratedName="" DataSourceName="" DbType="AnsiStringFixedLength"
Direction="Input" ParameterName="@BusinessType" Precision="0"
ProviderType="Char" Scale="0" Size="1" SourceColumn="BusinessType"
SourceColumnNullMapping="False" SourceVersion="Current">
</Parameter>
<Parameter AllowDbNull="True"
AutogeneratedName="" DataSourceName="" DbType="String"
Direction="Input" ParameterName="@BuildingName" Precision="0"
ProviderType="NVarChar" Scale="0" Size="50"
SourceColumn="BuildingName" SourceColumnNullMapping="False"
SourceVersion="Current">
</Parameter>
<Parameter AllowDbNull="True"
AutogeneratedName="" DataSourceName="" DbType="String"
Direction="Input" ParameterName="@address" Precision="0"
ProviderType="NVarChar" Scale="0" Size="50" SourceColumn="Address"
SourceColumnNullMapping="False" SourceVersion="Current">
</Parameter>
<Parameter AllowDbNull="True"
AutogeneratedName="" DataSourceName="" DbType="String"
Direction="Input" ParameterName="@City" Precision="0"
ProviderType="NVarChar" Scale="0" Size="50" SourceColumn="City"
SourceColumnNullMapping="False" SourceVersion="Current">
</Parameter>
<Parameter AllowDbNull="True"
AutogeneratedName="" DataSourceName="" DbType="Int16"
Direction="Input" ParameterName="@ProvinceID" Precision="5"
ProviderType="SmallInt" Scale="0" Size="2" SourceColumn="ProvinceID"
SourceColumnNullMapping="False" SourceVersion="Current">
</Parameter>
<Parameter AllowDbNull="True"
AutogeneratedName="" DataSourceName="" DbType="AnsiString"
Direction="Input" ParameterName="@ZipCode" Precision="0"
ProviderType="VarChar" Scale="0" Size="10" SourceColumn="ZipCode"
SourceColumnNullMapping="False" SourceVersion="Current">
</Parameter>
<Parameter AllowDbNull="True"
AutogeneratedName="" DataSourceName="" DbType="Int16"
Direction="Input" ParameterName="@CountryID" Precision="5"
ProviderType="SmallInt" Scale="0" Size="2" SourceColumn="CountryID"
SourceColumnNullMapping="False" SourceVersion="Current">
</Parameter>
<Parameter AllowDbNull="True"
AutogeneratedName="" DataSourceName="" DbType="Int16"
Direction="Input" ParameterName="@StructureTypeId" Precision="5"
ProviderType="SmallInt" Scale="0" Size="2"
SourceColumn="StructureTypeId" SourceColumnNullMapping="False"
SourceVersion="Current">
</Parameter>
<Parameter AllowDbNull="True"
AutogeneratedName="" DataSourceName="" DbType="DateTime"
Direction="Input" ParameterName="@ConstructDt" Precision="23"
ProviderType="DateTime" Scale="3" Size="8" SourceColumn="ConstructDt"
SourceColumnNullMapping="False" SourceVersion="Current">
</Parameter>
<Parameter AllowDbNull="True"
AutogeneratedName="" DataSourceName="" DbType="DateTime"
Direction="Input" ParameterName="@RenovateDt" Precision="23"
ProviderType="DateTime" Scale="3" Size="8" SourceColumn="RenovateDt"
SourceColumnNullMapping="False" SourceVersion="Current">
</Parameter>
<Parameter AllowDbNull="True"
AutogeneratedName="" DataSourceName="" DbType="Currency"
Direction="Input" ParameterName="@ReplaceVal" Precision="19"
ProviderType="Money" Scale="4" Size="8" SourceColumn="ReplaceVal"
SourceColumnNullMapping="False" SourceVersion="Current">
</Parameter>
<Parameter AllowDbNull="True"
AutogeneratedName="" DataSourceName="" DbType="Boolean"
Direction="Input" ParameterName="@VisualAssessCompleted" Precision="1"
ProviderType="Bit" Scale="0" Size="1"
SourceColumn="VisualAssessCompleted" SourceColumnNullMapping="False"
SourceVersion="Current">
</Parameter>
<Parameter AllowDbNull="True"
AutogeneratedName="" DataSourceName="" DbType="DateTime"
Direction="Input" ParameterName="@VisualAssessDt" Precision="23"
ProviderType="DateTime" Scale="3" Size="8"
SourceColumn="VisualAssessDt" SourceColumnNullMapping="False"
SourceVersion="Current">
</Parameter>
<Parameter AllowDbNull="True"
AutogeneratedName="" DataSourceName="" DbType="Decimal"
Direction="Input" ParameterName="@VisualAssessScore" Precision="9"
ProviderType="Decimal" Scale="6" Size="5"
SourceColumn="VisualAssessScore" SourceColumnNullMapping="False"
SourceVersion="Current">
</Parameter>
<Parameter AllowDbNull="True"
AutogeneratedName="" DataSourceName="" DbType="Decimal"
Direction="Input" ParameterName="@ConditionIndex" Precision="9"
ProviderType="Decimal" Scale="6" Size="5"
SourceColumn="ConditionIndex" SourceColumnNullMapping="False"
SourceVersion="Current">
</Parameter>
</Parameters>
</DbCommand>
</UpdateCommand>
</DbSource>
</MainSource>
<Mappings>
<Mapping SourceColumn="BuildingId"
DataSetColumn="BuildingId" />
<Mapping SourceColumn="AssetID" DataSetColumn="AssetID" /<Mapping SourceColumn="BusinessType"
DataSetColumn="BusinessType" />
<Mapping SourceColumn="BuildingName"
DataSetColumn="BuildingName" />
<Mapping SourceColumn="Address" DataSetColumn="Address" /<Mapping SourceColumn="City" DataSetColumn="City" />
<Mapping SourceColumn="ProvinceID"
DataSetColumn="ProvinceID" />
<Mapping SourceColumn="ZipCode" DataSetColumn="ZipCode" /<Mapping SourceColumn="CountryID"
DataSetColumn="CountryID" />
<Mapping SourceColumn="StructureTypeId"
DataSetColumn="StructureTypeId" />
<Mapping SourceColumn="ConstructDt"
DataSetColumn="ConstructDt" />
<Mapping SourceColumn="RenovateDt"
DataSetColumn="RenovateDt" />
<Mapping SourceColumn="ReplaceVal"
DataSetColumn="ReplaceVal" />
<Mapping SourceColumn="VisualAssessCompleted"
DataSetColumn="VisualAssessCompleted" />
<Mapping SourceColumn="VisualAssessDt"
DataSetColumn="VisualAssessDt" />
<Mapping SourceColumn="VisualAssessScore"
DataSetColumn="VisualAssessScore" />
<Mapping SourceColumn="ConditionIndex"
DataSetColumn="ConditionIndex" />
</Mappings>
<Sources>
<DbSource ConnectionRef="FCastConnectionString
(MySettings)" DbObjectName="FCast.CAT.usp_select_all_buildings"
DbObjectType="StoredProcedure" FillMethodModifier="Public"
FillMethodName="FillAll" GenerateMethods="Both"
GenerateShortCommands="True" GeneratorGetMethodName="GetAllData"
GeneratorSourceName="FillAll" GetMethodModifier="Public"
GetMethodName="GetAllData" QueryType="Rowset"
ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0,
Culture=neutral, PublicKeyToken=b77a5c561934e089"
UseOptimisticConcurrency="True" UserGetMethodName="GetAllData"
UserSourceName="FillAll">
<SelectCommand>
<DbCommand CommandType="StoredProcedure"
ModifiedByUser="False">
<CommandText>CAT.usp_select_all_buildings</
CommandText>
<Parameters>
<Parameter AllowDbNull="True"
AutogeneratedName="" DataSourceName="" DbType="Int32"
Direction="ReturnValue" ParameterName="@RETURN_VALUE" Precision="10"
ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="False"
SourceVersion="Current">
</Parameter>
</Parameters>
</DbCommand>
</SelectCommand>
</DbSource>
</Sources>
</TableAdapter>
<TableAdapter BaseClass="System.ComponentModel.Component"
DataAccessorModifier="AutoLayout, AnsiClass, Class, Public"
DataAccessorName="ComponentsTableAdapter"
GeneratorDataComponentClassName="ComponentsTableAdapter"
Name="Components" UserDataComponentName="ComponentsTableAdapter">
<MainSource>
<DbSource ConnectionRef="FCastConnectionString
(MySettings)" DbObjectName="FCast.CAT.usp_select_components"
DbObjectType="StoredProcedure" FillMethodModifier="Public"
FillMethodName="Fill" GenerateMethods="Both"
GenerateShortCommands="False" GeneratorGetMethodName="GetData"
GeneratorSourceName="Fill" GetMethodModifier="Public"
GetMethodName="GetData" QueryType="Rowset"
ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0,
Culture=neutral, PublicKeyToken=b77a5c561934e089"
UseOptimisticConcurrency="True" UserGetMethodName="GetData"
UserSourceName="Fill">
<SelectCommand>
<DbCommand CommandType="StoredProcedure"
ModifiedByUser="False">
<CommandText>CAT.usp_select_components</
CommandText>
<Parameters>
<Parameter AllowDbNull="True"
AutogeneratedName="" DataSourceName="" DbType="Int32"
Direction="ReturnValue" ParameterName="@RETURN_VALUE" Precision="10"
ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="False"
SourceVersion="Current">
</Parameter>
</Parameters>
</DbCommand>
</SelectCommand>
</DbSource>
</MainSource>
<Mappings>
<Mapping SourceColumn="ComponentId"
DataSetColumn="ComponentId" />
<Mapping SourceColumn="ComponentCode"
DataSetColumn="ComponentCode" />
<Mapping SourceColumn="ComponentName"
DataSetColumn="ComponentName" />
<Mapping SourceColumn="CoefficientRoot"
DataSetColumn="CoefficientRoot" />
<Mapping SourceColumn="Priority"
DataSetColumn="Priority" />
<Mapping SourceColumn="Parent" DataSetColumn="Parent" />
<Mapping SourceColumn="DimLevel"
DataSetColumn="DimLevel" />
</Mappings>
<Sources>
<DbSource ConnectionRef="FCastConnectionString
(MySettings)" DbObjectName="" DbObjectType="Unknown"
GenerateShortCommands="True" GeneratorGetMethodName="GetDataBy"
GeneratorSourceName="FillBy" Modifier="Public" Name="FillBy"
QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib,
Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089"
UseOptimisticConcurrency="True" UserGetMethodName="GetDataBy"
UserSourceName="FillBy">
</DbSource>
<DbSource ConnectionRef="FCastConnectionString
(MySettings)" DbObjectName="FCast.CAT.usp_select_component_by_id"
DbObjectType="StoredProcedure" FillMethodModifier="Public"
FillMethodName="FillById" GenerateMethods="Both"
GenerateShortCommands="True" GeneratorGetMethodName="GetDataById"
GeneratorSourceName="FillById" GetMethodModifier="Public"
GetMethodName="GetDataById" QueryType="Rowset"
ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0,
Culture=neutral, PublicKeyToken=b77a5c561934e089"
UseOptimisticConcurrency="True" UserGetMethodName="GetDataById"
UserSourceName="FillById">
<SelectCommand>
<DbCommand CommandType="StoredProcedure"
ModifiedByUser="False">
<CommandText>CAT.usp_select_component_by_id</
CommandText>
<Parameters>
<Parameter AllowDbNull="True"
AutogeneratedName="" DataSourceName="" DbType="Int32"
Direction="ReturnValue" ParameterName="@RETURN_VALUE" Precision="10"
ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="False"
SourceVersion="Current">
</Parameter>
<Parameter AllowDbNull="True"
AutogeneratedName="" DataSourceName="" DbType="Int32"
Direction="Input" ParameterName="@ComponentId" Precision="10"
ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="False"
SourceVersion="Current">
</Parameter>
</Parameters>
</DbCommand>
</SelectCommand>
</DbSource>
</Sources>
</TableAdapter>
<TableAdapter BaseClass="System.ComponentModel.Component"
DataAccessorModifier="AutoLayout, AnsiClass, Class, Public"
DataAccessorName="hierarchyTableAdapter"
GeneratorDataComponentClassName="hierarchyTableAdapter"
Name="hierarchy" UserDataComponentName="hierarchyTableAdapter">
<MainSource>
<DbSource ConnectionRef="FCastConnectionString
(MySettings)" DbObjectName="FCast.CAT.usp_select_hierarchy"
DbObjectType="StoredProcedure" FillMethodModifier="Public"
FillMethodName="Fill" GenerateMethods="Both"
GenerateShortCommands="True" GeneratorGetMethodName="GetData"
GeneratorSourceName="Fill" GetMethodModifier="Public"
GetMethodName="GetData" QueryType="Rowset"
ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0,
Culture=neutral, PublicKeyToken=b77a5c561934e089"
UseOptimisticConcurrency="True" UserGetMethodName="GetData"
UserSourceName="Fill">
<InsertCommand>
<DbCommand CommandType="StoredProcedure"
ModifiedByUser="False">
<CommandText>CAT.usp_insert_hierarchy</
CommandText>
<Parameters>
<Parameter AllowDbNull="True"
AutogeneratedName="" DataSourceName="" DbType="Int32"
Direction="ReturnValue" ParameterName="@RETURN_VALUE" Precision="10"
ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="False"
SourceVersion="Current">
</Parameter>
<Parameter AllowDbNull="True"
AutogeneratedName="" DataSourceName="" DbType="String"
Direction="Input" ParameterName="@HierarchyName" Precision="0"
ProviderType="NVarChar" Scale="0" Size="100"
SourceColumn="HierarchyName" SourceColumnNullMapping="False"
SourceVersion="Current">
</Parameter>
<Parameter AllowDbNull="True"
AutogeneratedName="" DataSourceName="" DbType="Int32"
Direction="Input" ParameterName="@TableId" Precision="10"
ProviderType="Int" Scale="0" Size="4" SourceColumn="TableId"
SourceColumnNullMapping="False" SourceVersion="Current">
</Parameter>
<Parameter AllowDbNull="True"
AutogeneratedName="" DataSourceName="" DbType="AnsiString"
Direction="Input" ParameterName="@TableName" Precision="0"
ProviderType="VarChar" Scale="0" Size="15" SourceColumn=""
SourceColumnNullMapping="False" SourceVersion="Current">
</Parameter>
<Parameter AllowDbNull="True"
AutogeneratedName="" DataSourceName="" DbType="Int32"
Direction="Input" ParameterName="@Parent" Precision="10"
ProviderType="Int" Scale="0" Size="4" SourceColumn="Parent"
SourceColumnNullMapping="False" SourceVersion="Current">
</Parameter>
<Parameter AllowDbNull="True"
AutogeneratedName="" DataSourceName="" DbType="Int16"
Direction="Input" ParameterName="@DimLevel" Precision="5"
ProviderType="SmallInt" Scale="0" Size="2" SourceColumn=""
SourceColumnNullMapping="False" SourceVersion="Current">
</Parameter>
<Parameter AllowDbNull="True"
AutogeneratedName="" DataSourceName="" DbType="Int32"
Direction="InputOutput" ParameterName="@HierarchyId" Precision="10"
ProviderType="Int" Scale="0" Size="4" SourceColumn="HierarchyId"
SourceColumnNullMapping="False" SourceVersion="Current">
</Parameter>
</Parameters>
</DbCommand>
</InsertCommand>
<SelectCommand>
<DbCommand CommandType="StoredProcedure"
ModifiedByUser="False">
<CommandText>CAT.usp_select_hierarchy</
CommandText>
<Parameters>
<Parameter AllowDbNull="True"
AutogeneratedName="" DataSourceName="" DbType="Int32"
Direction="ReturnValue" ParameterName="@RETURN_VALUE" Precision="10"
ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="False"
SourceVersion="Current">
</Parameter>
<Parameter AllowDbNull="True"
AutogeneratedName="" DataSourceName="" DbType="Int32"
Direction="Input" ParameterName="@HierarchyID" Precision="10"
ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="False"
SourceVersion="Current">
</Parameter>
</Parameters>
</DbCommand>
</SelectCommand>
<UpdateCommand>
<DbCommand CommandType="StoredProcedure"
ModifiedByUser="False">
<CommandText>CAT.usp_update_hierarchy</
CommandText>
<Parameters>
<Parameter AllowDbNull="True"
AutogeneratedName="" DataSourceName="" DbType="Int32"
Direction="ReturnValue" ParameterName="@RETURN_VALUE" Precision="10"
ProviderType="Int" Scale="0" Size="4" SourceColumnNullMapping="False"
SourceVersion="Current">
</Parameter>
<Parameter AllowDbNull="True"
AutogeneratedName="" DataSourceName="" DbType="Int32"
Direction="Input" ParameterName="@HierarchyID" Precision="10"
ProviderType="Int" Scale="0" Size="4" SourceColumn="HierarchyId"
SourceColumnNullMapping="False" SourceVersion="Current">
</Parameter>
<Parameter AllowDbNull="True"
AutogeneratedName="" DataSourceName="" DbType="AnsiString"
Direction="Input" ParameterName="@HierarchyName" Precision="0"
ProviderType="VarChar" Scale="0" Size="50"
SourceColumn="HierarchyName" SourceColumnNullMapping="False"
SourceVersion="Current">
</Parameter>
<Parameter AllowDbNull="True"
AutogeneratedName="" DataSourceName="" DbType="Int32"
Direction="Input" ParameterName="@Parent" Precision="10"
ProviderType="Int" Scale="0" Size="4" SourceColumn="Parent"
SourceColumnNullMapping="False" SourceVersion="Current">
</Parameter>
<Parameter AllowDbNull="True"
AutogeneratedName="" DataSourceName="" DbType="Int32"
Direction="Input" ParameterName="@TableId" Precision="10"
ProviderType="Int" Scale="0" Size="4" SourceColumn="TableId"
SourceColumnNullMapping="False" SourceVersion="Current">
</Parameter>
<Parameter AllowDbNull="True"
AutogeneratedName="" DataSourceName="" DbType="AnsiString"
Direction="Input" ParameterName="@TableName" Precision="0"
ProviderType="VarChar" Scale="0" Size="15" SourceColumn=""
SourceColumnNullMapping="False" SourceVersion="Current">
</Parameter>
<Parameter AllowDbNull="True"
AutogeneratedName="" DataSourceName="" DbType="Int16"
Direction="Input" ParameterName="@DimLevel" Precision="5"
ProviderType="SmallInt" Scale="0" Size="2" SourceColumn=""
SourceColumnNullMapping="False" SourceVersion="Current">
</Parameter>
</Parameters>
</DbCommand>
</UpdateCommand>
</DbSource>
</MainSource>
<Mappings>
<Mapping SourceColumn="HierarchyId"
DataSetColumn="HierarchyId" />
<Mapping SourceColumn="HierarchyName"
DataSetColumn="HierarchyName" />
<Mapping SourceColumn="TableId" DataSetColumn="TableId" /<Mapping SourceColumn="Parent" DataSetColumn="Parent" />
</Mappings>
<Sources>
</Sources>
</TableAdapter>
</Tables>
<Sources>
</Sources>
</DataSource>
</xs:appinfo>
</xs:annotation>
<xs:element name="FCASTDataSet" msdata:IsDataSet="true"
msdata:UseCurrentLocale="true"
msprop:Generator_UserDSName="FCASTDataSet"
msprop:Generator_DataSetName="FCASTDataSet">
<xs:complexType>
<xs:choice minOccurs="0" maxOccurs="unbounded">
<xs:element name="StructureTypes"
msprop:Generator_UserTableName="StructureTypes"
msprop:Generator_RowDeletedName="StructureTypesRowDeleted"
msprop:Generator_RowChangedName="StructureTypesRowChanged"
msprop:Generator_RowClassName="StructureTypesRow"
msprop:Generator_RowChangingName="StructureTypesRowChanging"
msprop:Generator_RowEvArgName="StructureTypesRowChangeEvent"
msprop:Generator_RowEvHandlerName="StructureTypesRowChangeEventHandler"
msprop:Generator_TableClassName="StructureTypesDataTable"
msprop:Generator_TableVarName="tableStructureTypes"
msprop:Generator_RowDeletingName="StructureTypesRowDeleting"
msprop:Generator_TablePropName="StructureTypes">
<xs:complexType>
<xs:sequence>
<xs:element name="StructureTypeId"
msdata:ReadOnly="true" msdata:AutoIncrement="true"
msprop:Generator_UserColumnName="StructureTypeId"
msprop:Generator_ColumnPropNameInRow="StructureTypeId"
msprop:Generator_ColumnVarNameInTable="columnStructureTypeId"
msprop:Generator_ColumnPropNameInTable="StructureTypeIdColumn"
type="xs:short" />
<xs:element name="StructureCode"
msprop:Generator_UserColumnName="StructureCode"
msprop:Generator_ColumnPropNameInRow="StructureCode"
msprop:Generator_ColumnVarNameInTable="columnStructureCode"
msprop:Generator_ColumnPropNameInTable="StructureCodeColumn"
minOccurs="0">
<xs:simpleType>
<xs:restriction base="xs:string">
<xs:maxLength value="5" />
</xs:restriction>
</xs:simpleType>
</xs:element>
<xs:element name="StructureName"
msprop:Generator_UserColumnName="StructureName"
msprop:Generator_ColumnPropNameInRow="StructureName"
msprop:Generator_ColumnVarNameInTable="columnStructureName"
msprop:Generator_ColumnPropNameInTable="StructureNameColumn">
<xs:simpleType>
<xs:restriction base="xs:string">
<xs:maxLength value="50" />
</xs:restriction>
</xs:simpleType>
</xs:element>
<xs:element name="StructureDescr"
msprop:Generator_UserColumnName="StructureDescr"
msprop:Generator_ColumnPropNameInRow="StructureDescr"
msprop:Generator_ColumnVarNameInTable="columnStructureDescr"
msprop:Generator_ColumnPropNameInTable="StructureDescrColumn"
minOccurs="0">
<xs:simpleType>
<xs:restriction base="xs:string">
<xs:maxLength value="600" />
</xs:restriction>
</xs:simpleType>
</xs:element>
<xs:element name="StructureType"
msprop:Generator_UserColumnName="StructureType"
msprop:Generator_ColumnPropNameInRow="StructureType"
msprop:Generator_ColumnVarNameInTable="columnStructureType"
msprop:Generator_ColumnPropNameInTable="StructureTypeColumn"
minOccurs="0">
<xs:simpleType>
<xs:restriction base="xs:string">
<xs:maxLength value="1" />
</xs:restriction>
</xs:simpleType>
</xs:element>
<xs:element name="Constant"
msprop:Generator_UserColumnName="Constant"
msprop:Generator_ColumnPropNameInRow="Constant"
msprop:Generator_ColumnVarNameInTable="columnConstant"
msprop:Generator_ColumnPropNameInTable="ConstantColumn"
type="xs:decimal" minOccurs="0" />
<xs:element name="Parent"
msprop:Generator_UserColumnName="Parent"
msprop:Generator_ColumnPropNameInRow="Parent"
msprop:Generator_ColumnVarNameInTable="columnParent"
msprop:Generator_ColumnPropNameInTable="ParentColumn" type="xs:short"
minOccurs="0" />
<xs:element name="DimLevel"
msprop:Generator_UserColumnName="DimLevel"
msprop:Generator_ColumnPropNameInRow="DimLevel"
msprop:Generator_ColumnVarNameInTable="columnDimLevel"
msprop:Generator_ColumnPropNameInTable="DimLevelColumn"
type="xs:short" minOccurs="0" />
</xs:sequence>
</xs:complexType>
</xs:element>
<xs:element name="BuildingComponents"
msprop:Generator_UserTableName="BuildingComponents"
msprop:Generator_RowDeletedName="BuildingComponentsRowDeleted"
msprop:Generator_RowChangedName="BuildingComponentsRowChanged"
msprop:Generator_RowClassName="BuildingComponentsRow"
msprop:Generator_RowChangingName="BuildingComponentsRowChanging"
msprop:Generator_RowEvArgName="BuildingComponentsRowChangeEvent"
msprop:Generator_RowEvHandlerName="BuildingComponentsRowChangeEventHandler"
msprop:Generator_TableClassName="BuildingComponentsDataTable"
msprop:Generator_TableVarName="tableBuildingComponents"
msprop:Generator_RowDeletingName="BuildingComponentsRowDeleting"
msprop:Generator_TablePropName="BuildingComponents">
<xs:complexType>
<xs:sequence>
<xs:element name="BuildingId"
msprop:Generator_UserColumnName="BuildingId"
msprop:Generator_ColumnVarNameInTable="columnBuildingId"
msprop:Generator_ColumnPropNameInRow="BuildingId"
msprop:Generator_ColumnPropNameInTable="BuildingIdColumn"
type="xs:int" />
<xs:element name="ComponentId"
msprop:Generator_UserColumnName="ComponentId"
msprop:Generator_ColumnVarNameInTable="columnComponentId"
msprop:Generator_ColumnPropNameInRow="ComponentId"
msprop:Generator_ColumnPropNameInTable="ComponentIdColumn"
type="xs:int" />
<xs:element name="Priority"
msprop:Generator_UserColumnName="Priority"
msprop:Generator_ColumnVarNameInTable="columnPriority"
msprop:Generator_ColumnPropNameInRow="Priority"
msprop:Generator_ColumnPropNameInTable="PriorityColumn"
type="xs:unsignedByte" minOccurs="0" />
<xs:element name="ComponentCode"
msprop:Generator_UserColumnName="ComponentCode"
msprop:Generator_ColumnVarNameInTable="columnComponentCode"
msprop:Generator_ColumnPropNameInRow="ComponentCode"
msprop:Generator_ColumnPropNameInTable="ComponentCodeColumn">
<xs:simpleType>
<xs:restriction base="xs:string">
<xs:maxLength value="5" />
</xs:restriction>
</xs:simpleType>
</xs:element>
<xs:element name="ComponentName"
msprop:Generator_UserColumnName="ComponentName"
msprop:Generator_ColumnVarNameInTable="columnComponentName"
msprop:Generator_ColumnPropNameInRow="ComponentName"
msprop:Generator_ColumnPropNameInTable="ComponentNameColumn">
<xs:simpleType>
<xs:restriction base="xs:string">
<xs:maxLength value="50" />
</xs:restriction>
</xs:simpleType>
</xs:element>
<xs:element name="ComponentBD_Percent"
msprop:Generator_UserColumnName="ComponentBD_Percent"
msprop:Generator_ColumnVarNameInTable="columnComponentBD_Percent"
msprop:Generator_ColumnPropNameInRow="ComponentBD_Percent"
msprop:Generator_ColumnPropNameInTable="ComponentBD_PercentColumn"
type="xs:decimal" />
<xs:element name="EUL"
msprop:Generator_UserColumnName="EUL"
msprop:Generator_ColumnVarNameInTable="columnEUL"
msprop:Generator_ColumnPropNameInRow="EUL"
msprop:Generator_ColumnPropNameInTable="EULColumn" type="xs:short" />
<xs:element name="RepairVal"
msprop:Generator_UserColumnName="RepairVal"
msprop:Generator_ColumnVarNameInTable="columnRepairVal"
msprop:Generator_ColumnPropNameInRow="RepairVal"
msprop:Generator_ColumnPropNameInTable="RepairValColumn"
type="xs:decimal" minOccurs="0" />
<xs:element name="RepairChosen"
msprop:Generator_UserColumnName="RepairChosen"
msprop:Generator_ColumnVarNameInTable="columnRepairChosen"
msprop:Generator_ColumnPropNameInRow="RepairChosen"
msprop:Generator_ColumnPropNameInTable="RepairChosenColumn"
type="xs:boolean" />
<xs:element name="CoefficientRoot"
msprop:Generator_UserColumnName="CoefficientRoot"
msprop:Generator_ColumnVarNameInTable="columnCoefficientRoot"
msprop:Generator_ColumnPropNameInRow="CoefficientRoot"
msprop:Generator_ColumnPropNameInTable="CoefficientRootColumn"
type="xs:unsignedByte" minOccurs="0" />
<xs:element name="Action"
msprop:Generator_UserColumnName="Action"
msprop:Generator_ColumnPropNameInRow="Action"
msprop:Generator_ColumnVarNameInTable="columnAction"
msprop:Generator_ColumnPropNameInTable="ActionColumn">
<xs:simpleType>
<xs:restriction base="xs:string">
<xs:maxLength value="1" />
</xs:restriction>
</xs:simpleType>
</xs:element>
<xs:element name="Repair_Percent"
msprop:Generator_UserColumnName="Repair_Percent"
msprop:Generator_ColumnVarNameInTable="columnRepair_Percent"
msprop:Generator_ColumnPropNameInRow="Repair_Percent"
msprop:Generator_ColumnPropNameInTable="Repair_PercentColumn"
type="xs:decimal" minOccurs="0" />
<xs:element name="ComponentDt"
msprop:Generator_UserColumnName="ComponentDt"
msprop:Generator_ColumnPropNameInRow="ComponentDt"
msprop:Generator_ColumnVarNameInTable="columnComponentDt"
msprop:Generator_ColumnPropNameInTable="ComponentDtColumn"
type="xs:dateTime" minOccurs="0" />
</xs:sequence>
</xs:complexType>
</xs:element>
<xs:element name="BuildingComponentsByType"
msprop:Generator_UserTableName="BuildingComponentsByType"
msprop:Generator_RowDeletedName="BuildingComponentsByTypeRowDeleted"
msprop:Generator_RowChangedName="BuildingComponentsByTypeRowChanged"
msprop:Generator_RowClassName="BuildingComponentsByTypeRow"
msprop:Generator_RowChangingName="BuildingComponentsByTypeRowChanging"
msprop:Generator_RowEvArgName="BuildingComponentsByTypeRowChangeEvent"
msprop:Generator_RowEvHandlerName="BuildingComponentsByTypeRowChangeEventHandler"
msprop:Generator_TableClassName="BuildingComponentsByTypeDataTable"
msprop:Generator_TableVarName="tableBuildingComponentsByType"
msprop:Generator_RowDeletingName="BuildingComponentsByTypeRowDeleting"
msprop:Generator_TablePropName="BuildingComponentsByType">
<xs:complexType>
<xs:sequence>
<xs:element name="ComponentId"
msprop:Generator_UserColumnName="ComponentId"
msprop:Generator_ColumnVarNameInTable="columnComponentId"
msprop:Generator_ColumnPropNameInRow="ComponentId"
msprop:Generator_ColumnPropNameInTable="ComponentIdColumn"
type="xs:int" />
<xs:element name="ComponentCode"
msprop:Generator_UserColumnName="ComponentCode"
msprop:Generator_ColumnVarNameInTable="columnComponentCode"
msprop:Generator_ColumnPropNameInRow="ComponentCode"
msprop:Generator_ColumnPropNameInTable="ComponentCodeColumn">
<xs:simpleType>
<xs:restriction base="xs:string">
<xs:maxLength value="5" />
</xs:restriction>
</xs:simpleType>
</xs:element>
<xs:element name="ComponentName"
msprop:Generator_UserColumnName="ComponentName"
msprop:Generator_ColumnVarNameInTable="columnComponentName"
msprop:Generator_ColumnPropNameInRow="ComponentName"
msprop:Generator_ColumnPropNameInTable="ComponentNameColumn">
<xs:simpleType>
<xs:restriction base="xs:string">
<xs:maxLength value="50" />
</xs:restriction>
</xs:simpleType>
</xs:element>
<xs:element name="Priority"
msprop:Generator_UserColumnName="Priority"
msprop:Generator_ColumnVarNameInTable="columnPriority"
msprop:Generator_ColumnPropNameInRow="Priority"
msprop:Generator_ColumnPropNameInTable="PriorityColumn"
type="xs:unsignedByte" minOccurs="0" />
<xs:element name="StructureTypeId"
msprop:Generator_UserColumnName="StructureTypeId"
msprop:Generator_ColumnVarNameInTable="columnStructureTypeId"
msprop:Generator_ColumnPropNameInRow="StructureTypeId"
msprop:Generator_ColumnPropNameInTable="StructureTypeIdColumn"
type="xs:short" />
<xs:element name="EUL"
msprop:Generator_UserColumnName="EUL"
msprop:Generator_ColumnVarNameInTable="columnEUL"
msprop:Generator_ColumnPropNameInRow="EUL"
msprop:Generator_ColumnPropNameInTable="EULColumn" type="xs:short" />
<xs:element name="PUC"
msprop:Generator_UserColumnName="PUC"
msprop:Generator_ColumnVarNameInTable="columnPUC"
msprop:Generator_ColumnPropNameInRow="PUC"
msprop:Generator_ColumnPropNameInTable="PUCColumn" type="xs:decimal" /<xs:element name="CoefficientRoot"
msprop:Generator_UserColumnName="CoefficientRoot"
msprop:Generator_ColumnVarNameInTable="columnCoefficientRoot"
msprop:Generator_ColumnPropNameInRow="CoefficientRoot"
msprop:Generator_ColumnPropNameInTable="CoefficientRootColumn"
type="xs:unsignedByte" minOccurs="0" />
</xs:sequence>
</xs:complexType>
</xs:element>
<xs:element name="Countries"
msprop:Generator_UserTableName="Countries"
msprop:Generator_RowDeletedName="CountriesRowDeleted"
msprop:Generator_RowChangedName="CountriesRowChanged"
msprop:Generator_RowClassName="CountriesRow"
msprop:Generator_RowChangingName="CountriesRowChanging"
msprop:Generator_RowEvArgName="CountriesRowChangeEvent"
msprop:Generator_RowEvHandlerName="CountriesRowChangeEventHandler"
msprop:Generator_TableClassName="CountriesDataTable"
msprop:Generator_TableVarName="tableCountries"
msprop:Generator_RowDeletingName="CountriesRowDeleting"
msprop:Generator_TablePropName="Countries">
<xs:complexType>
<xs:sequence>
<xs:element name="CountryID" msdata:ReadOnly="true"
msdata:AutoIncrement="true"
msprop:Generator_UserColumnName="CountryID"
msprop:Generator_ColumnPropNameInRow="CountryID"
msprop:Generator_ColumnVarNameInTable="columnCountryID"
msprop:Generator_ColumnPropNameInTable="CountryIDColumn"
type="xs:short" />
<xs:element name="RegionID"
msprop:Generator_UserColumnName="RegionID"
msprop:Generator_ColumnPropNameInRow="RegionID"
msprop:Generator_ColumnVarNameInTable="columnRegionID"
msprop:Generator_ColumnPropNameInTable="RegionIDColumn"
type="xs:short" />
<xs:element name="CountryCode"
msprop:Generator_UserColumnName="CountryCode"
msprop:Generator_ColumnPropNameInRow="CountryCode"
msprop:Generator_ColumnVarNameInTable="columnCountryCode"
msprop:Generator_ColumnPropNameInTable="CountryCodeColumn"
minOccurs="0">
<xs:simpleType>
<xs:restriction base="xs:string">
<xs:maxLength value="3" />
</xs:restriction>
</xs:simpleType>
</xs:element>
<xs:element name="CountryName"
msprop:Generator_UserColumnName="CountryName"
msprop:Generator_ColumnPropNameInRow="CountryName"
msprop:Generator_ColumnVarNameInTable="columnCountryName"
msprop:Generator_ColumnPropNameInTable="CountryNameColumn">
<xs:simpleType>
<xs:restriction base="xs:string">
<xs:maxLength value="100" />
</xs:restriction>
</xs:simpleType>
</xs:element>
<xs:element name="Recognized"
msprop:Generator_UserColumnName="Recognized"
msprop:Generator_ColumnPropNameInRow="Recognized"
msprop:Generator_ColumnVarNameInTable="columnRecognized"
msprop:Generator_ColumnPropNameInTable="RecognizedColumn"
type="xs:boolean" />
</xs:sequence>
</xs:complexType>
</xs:element>
<xs:element name="Provinces"
msprop:Generator_UserTableName="Provinces"
msprop:Generator_RowDeletedName="ProvincesRowDeleted"
msprop:Generator_RowChangedName="ProvincesRowChanged"
msprop:Generator_RowClassName="ProvincesRow"
msprop:Generator_RowChangingName="ProvincesRowChanging"
msprop:Generator_RowEvArgName="ProvincesRowChangeEvent"
msprop:Generator_RowEvHandlerName="ProvincesRowChangeEventHandler"
msprop:Generator_TableClassName="ProvincesDataTable"
msprop:Generator_TableVarName="tableProvinces"
msprop:Generator_RowDeletingName="ProvincesRowDeleting"
msprop:Generator_TablePropName="Provinces">
<xs:complexType>
<xs:sequence>
<xs:element name="ProvinceID" msdata:ReadOnly="true"
msdata:AutoIncrement="true"
msprop:Generator_UserColumnName="ProvinceID"
msprop:Generator_ColumnPropNameInRow="ProvinceID"
msprop:Generator_ColumnVarNameInTable="columnProvinceID"
msprop:Generator_ColumnPropNameInTable="ProvinceIDColumn"
type="xs:short" />
<xs:element name="CountryID"
msprop:Generator_UserColumnName="CountryID"
msprop:Generator_ColumnPropNameInRow="CountryID"
msprop:Generator_ColumnVarNameInTable="columnCountryID"
msprop:Generator_ColumnPropNameInTable="CountryIDColumn"
type="xs:short" />
<xs:element name="ProvinceCode"
msprop:Generator_UserColumnName="ProvinceCode"
msprop:Generator_ColumnPropNameInRow="ProvinceCode"
msprop:Generator_ColumnVarNameInTable="columnProvinceCode"
msprop:Generator_ColumnPropNameInTable="ProvinceCodeColumn"
minOccurs="0">
<xs:simpleType>
<xs:restriction base="xs:string">
<xs:maxLength value="5" />
</xs:restriction>
</xs:simpleType>
</xs:element>
<xs:element name="ProvinceName"
msprop:Generator_UserColumnName="ProvinceName"
msprop:Generator_ColumnPropNameInRow="ProvinceName"
msprop:Generator_ColumnVarNameInTable="columnProvinceName"
msprop:Generator_ColumnPropNameInTable="ProvinceNameColumn">
<xs:simpleType>
<xs:restriction base="xs:string">
<xs:maxLength value="60" />
</xs:restriction>
</xs:simpleType>
</xs:element>
</xs:sequence>
</xs:complexType>
</xs:element>
<xs:element name="buildings"
msprop:Generator_UserTableName="buildings"
msprop:Generator_RowDeletedName="buildingsRowDeleted"
msprop:Generator_RowChangedName="buildingsRowChanged"
msprop:Generator_RowClassName="buildingsRow"
msprop:Generator_RowChangingName="buildingsRowChanging"
msprop:Generator_RowEvArgName="buildingsRowChangeEvent"
msprop:Generator_RowEvHandlerName="buildingsRowChangeEventHandler"
msprop:Generator_TableClassName="buildingsDataTable"
msprop:Generator_TableVarName="tablebuildings"
msprop:Generator_RowDeletingName="buildingsRowDeleting"
msprop:Generator_TablePropName="buildings">
<xs:complexType>
<xs:sequence>
<xs:element name="BuildingId" msdata:ReadOnly="true"
msdata:AutoIncrement="true"
msprop:Generator_UserColumnName="BuildingId"
msprop:Generator_ColumnVarNameInTable="columnBuildingId"
msprop:Generator_ColumnPropNameInRow="BuildingId"
msprop:Generator_ColumnPropNameInTable="BuildingIdColumn"
type="xs:int" />
<xs:element name="AssetID"
msprop:Generator_UserColumnName="AssetID"
msprop:Generator_ColumnVarNameInTable="columnAssetID"
msprop:Generator_ColumnPropNameInRow="AssetID"
msprop:Generator_ColumnPropNameInTable="AssetIDColumn">
<xs:simpleType>
<xs:restriction base="xs:string">
<xs:maxLength value="10" />
</xs:restriction>
</xs:simpleType>
</xs:element>
<xs:element name="BusinessType"
msprop:Generator_UserColumnName="BusinessType"
msprop:Generator_ColumnVarNameInTable="columnBusinessType"
msprop:Generator_ColumnPropNameInRow="BusinessType"
msprop:Generator_ColumnPropNameInTable="BusinessTypeColumn">
<xs:simpleType>
<xs:restriction base="xs:string">
<xs:maxLength value="1" />
</xs:restriction>
</xs:simpleType>
</xs:element>
<xs:element name="BuildingName"
msprop:Generator_UserColumnName="BuildingName"
msprop:Generator_ColumnVarNameInTable="columnBuildingName"
msprop:Generator_ColumnPropNameInRow="BuildingName"
msprop:Generator_ColumnPropNameInTable="BuildingNameColumn">
<xs:simpleType>
<xs:restriction base="xs:string">
<xs:maxLength value="50" />
</xs:restriction>
</xs:simpleType>
</xs:element>
<xs:element name="Address"
msprop:Generator_UserColumnName="Address"
msprop:Generator_ColumnVarNameInTable="columnAddress"
msprop:Generator_ColumnPropNameInRow="Address"
msprop:Generator_ColumnPropNameInTable="AddressColumn">
<xs:simpleType>
<xs:restriction base="xs:string">
<xs:maxLength value="50" />
</xs:restriction>
</xs:simpleType>
</xs:element>
<xs:element name="City"
msprop:Generator_UserColumnName="City"
msprop:Generator_ColumnVarNameInTable="columnCity"
msprop:Generator_ColumnPropNameInRow="City"
msprop:Generator_ColumnPropNameInTable="CityColumn">
<xs:simpleType>
<xs:restriction base="xs:string">
<xs:maxLength value="50" />
</xs:restriction>
</xs:simpleType>
</xs:element>
<xs:element name="ProvinceID"
msprop:Generator_UserColumnName="ProvinceID"
msprop:Generator_ColumnVarNameInTable="columnProvinceID"
msprop:Generator_ColumnPropNameInRow="ProvinceID"
msprop:Generator_ColumnPropNameInTable="ProvinceIDColumn"
type="xs:short" minOccurs="0" />
<xs:element name="ZipCode"
msprop:Generator_UserColumnName="ZipCode"
msprop:Generator_ColumnVarNameInTable="columnZipCode"
msprop:Generator_ColumnPropNameInRow="ZipCode"
msprop:Generator_ColumnPropNameInTable="ZipCodeColumn" minOccurs="0">
<xs:simpleType>
<xs:restriction base="xs:string">
<xs:maxLength value="10" />
</xs:restriction>
</xs:simpleType>
</xs:element>
<xs:element name="CountryID"
msprop:Generator_UserColumnName="CountryID"
msprop:Generator_ColumnVarNameInTable="columnCountryID"
msprop:Generator_ColumnPropNameInRow="CountryID"
msprop:Generator_ColumnPropNameInTable="CountryIDColumn"
type="xs:short" />
<xs:element name="StructureTypeId"
msprop:Generator_UserColumnName="StructureTypeId"
msprop:Generator_ColumnVarNameInTable="columnStructureTypeId"
msprop:Generator_ColumnPropNameInRow="StructureTypeId"
msprop:Generator_ColumnPropNameInTable="StructureTypeIdColumn"
type="xs:short" />
<xs:element name="ConstructDt"
msprop:Generator_UserColumnName="ConstructDt"
msprop:Generator_ColumnVarNameInTable="columnConstructDt"
msprop:Generator_ColumnPropNameInRow="ConstructDt"
msprop:Generator_ColumnPropNameInTable="ConstructDtColumn"
type="xs:dateTime" />
<xs:element name="RenovateDt"
msprop:Generator_UserColumnName="RenovateDt"
msprop:Generator_ColumnVarNameInTable="columnRenovateDt"
msprop:Generator_ColumnPropNameInRow="RenovateDt"
msprop:Generator_ColumnPropNameInTable="RenovateDtColumn"
type="xs:dateTime" minOccurs="0" />
<xs:element name="ReplaceVal"
msprop:Generator_UserColumnName="ReplaceVal"
msprop:Generator_ColumnVarNameInTable="columnReplaceVal"
msprop:Generator_ColumnPropNameInRow="ReplaceVal"
msprop:Generator_ColumnPropNameInTable="ReplaceValColumn"
type="xs:decimal" minOccurs="0" />
<xs:element name="VisualAssessCompleted"
msprop:Generator_UserColumnName="VisualAssessCompleted"
msprop:Generator_ColumnVarNameInTable="columnVisualAssessCompleted"
msprop:Generator_ColumnPropNameInRow="VisualAssessCompleted"
msprop:Generator_ColumnPropNameInTable="VisualAssessCompletedColumn"
type="xs:boolean" />
<xs:element name="VisualAssessDt"
msprop:Generator_UserColumnName="VisualAssessDt"
msprop:Generator_ColumnVarNameInTable="columnVisualAssessDt"
msprop:Generator_ColumnPropNameInRow="VisualAssessDt"
msprop:Generator_ColumnPropNameInTable="VisualAssessDtColumn"
type="xs:dateTime" minOccurs="0" />
<xs:element name="VisualAssessScore"
msprop:Generator_UserColumnName="VisualAssessScore"
msprop:Generator_ColumnVarNameInTable="columnVisualAssessScore"
msprop:Generator_ColumnPropNameInRow="VisualAssessScore"
msprop:Generator_ColumnPropNameInTable="VisualAssessScoreColumn"
type="xs:decimal" minOccurs="0" />
<xs:element name="ConditionIndex"
msprop:Generator_UserColumnName="ConditionIndex"
msprop:Generator_ColumnVarNameInTable="columnConditionIndex"
msprop:Generator_ColumnPropNameInRow="ConditionIndex"
msprop:Generator_ColumnPropNameInTable="ConditionIndexColumn"
type="xs:decimal" minOccurs="0" />
</xs:sequence>
</xs:complexType>
</xs:element>
<xs:element name="Components"
msprop:Generator_UserTableName="Components"
msprop:Generator_RowDeletedName="ComponentsRowDeleted"
msprop:Generator_RowChangedName="ComponentsRowChanged"
msprop:Generator_RowClassName="ComponentsRow"
msprop:Generator_RowChangingName="ComponentsRowChanging"
msprop:Generator_RowEvArgName="ComponentsRowChangeEvent"
msprop:Generator_RowEvHandlerName="ComponentsRowChangeEventHandler"
msprop:Generator_TableClassName="ComponentsDataTable"
msprop:Generator_TableVarName="tableComponents"
msprop:Generator_RowDeletingName="ComponentsRowDeleting"
msprop:Generator_TablePropName="Components">
<xs:complexType>
<xs:sequence>
<xs:element name="ComponentId" msdata:ReadOnly="true"
msdata:AutoIncrement="true"
msprop:Generator_UserColumnName="ComponentId"
msprop:Generator_ColumnPropNameInRow="ComponentId"
msprop:Generator_ColumnVarNameInTable="columnComponentId"
msprop:Generator_ColumnPropNameInTable="ComponentIdColumn"
type="xs:int" />
<xs:element name="ComponentCode"
msprop:Generator_UserColumnName="ComponentCode"
msprop:Generator_ColumnPropNameInRow="ComponentCode"
msprop:Generator_ColumnVarNameInTable="columnComponentCode"
msprop:Generator_ColumnPropNameInTable="ComponentCodeColumn">
<xs:simpleType>
<xs:restriction base="xs:string">
<xs:maxLength value="5" />
</xs:restriction>
</xs:simpleType>
</xs:element>
<xs:element name="ComponentName"
msprop:Generator_UserColumnName="ComponentName"
msprop:Generator_ColumnPropNameInRow="ComponentName"
msprop:Generator_ColumnVarNameInTable="columnComponentName"
msprop:Generator_ColumnPropNameInTable="ComponentNameColumn">
<xs:simpleType>
<xs:restriction base="xs:string">
<xs:maxLength value="50" />
</xs:restriction>
</xs:simpleType>
</xs:element>
<xs:element name="CoefficientRoot"
msprop:Generator_UserColumnName="CoefficientRoot"
msprop:Generator_ColumnPropNameInRow="CoefficientRoot"
msprop:Generator_ColumnVarNameInTable="columnCoefficientRoot"
msprop:Generator_ColumnPropNameInTable="CoefficientRootColumn"
type="xs:unsignedByte" minOccurs="0" />
<xs:element name="Priority"
msprop:Generator_UserColumnName="Priority"
msprop:Generator_ColumnPropNameInRow="Priority"
msprop:Generator_ColumnVarNameInTable="columnPriority"
msprop:Generator_ColumnPropNameInTable="PriorityColumn"
type="xs:unsignedByte" minOccurs="0" />
<xs:element name="Parent"
msprop:Generator_UserColumnName="Parent"
msprop:Generator_ColumnPropNameInRow="Parent"
msprop:Generator_ColumnVarNameInTable="columnParent"
msprop:Generator_ColumnPropNameInTable="ParentColumn" type="xs:int"
minOccurs="0" />
<xs:element name="DimLevel"
msprop:Generator_UserColumnName="DimLevel"
msprop:Generator_ColumnPropNameInRow="DimLevel"
msprop:Generator_ColumnVarNameInTable="columnDimLevel"
msprop:Generator_ColumnPropNameInTable="DimLevelColumn"
type="xs:unsignedByte" minOccurs="0" />
</xs:sequence>
</xs:complexType>
</xs:element>
<xs:element name="hierarchy"
msprop:Generator_UserTableName="hierarchy"
msprop:Generator_RowDeletedName="hierarchyRowDeleted"
msprop:Generator_RowChangedName="hierarchyRowChanged"
msprop:Generator_RowClassName="hierarchyRow"
msprop:Generator_RowChangingName="hierarchyRowChanging"
msprop:Generator_RowEvArgName="hierarchyRowChangeEvent"
msprop:Generator_RowEvHandlerName="hierarchyRowChangeEventHandler"
msprop:Generator_TableClassName="hierarchyDataTable"
msprop:Generator_TableVarName="tablehierarchy"
msprop:Generator_RowDeletingName="hierarchyRowDeleting"
msprop:Generator_TablePropName="hierarchy">
<xs:complexType>
<xs:sequence>
<xs:element name="HierarchyId" msdata:ReadOnly="true"
msdata:AutoIncrement="true"
msprop:Generator_UserColumnName="HierarchyId"
msprop:Generator_ColumnVarNameInTable="columnHierarchyId"
msprop:Generator_ColumnPropNameInRow="HierarchyId"
msprop:Generator_ColumnPropNameInTable="HierarchyIdColumn"
type="xs:int" />
<xs:element name="HierarchyName"
msprop:Generator_UserColumnName="HierarchyName"
msprop:Generator_ColumnVarNameInTable="columnHierarchyName"
msprop:Generator_ColumnPropNameInRow="HierarchyName"
msprop:Generator_ColumnPropNameInTable="HierarchyNameColumn">
<xs:simpleType>
<xs:restriction base="xs:string">
<xs:maxLength value="100" />
</xs:restriction>
</xs:simpleType>
</xs:element>
<xs:element name="TableId"
msprop:Generator_UserColumnName="TableId"
msprop:Generator_ColumnVarNameInTable="columnTableId"
msprop:Generator_ColumnPropNameInRow="TableId"
msprop:Generator_ColumnPropNameInTable="TableIdColumn" type="xs:int"
minOccurs="0" />
<xs:element name="Parent"
msprop:Generator_UserColumnName="Parent"
msprop:Generator_ColumnVarNameInTable="columnParent"
msprop:Generator_ColumnPropNameInRow="Parent"
msprop:Generator_ColumnPropNameInTable="ParentColumn" type="xs:int"
minOccurs="0" />
</xs:sequence>
</xs:complexType>
</xs:element>
</xs:choice>
</xs:complexType>
<xs:unique name="Constraint1" msdata:PrimaryKey="true">
<xs:selector xpath=".//mstns:StructureTypes" />
<xs:field xpath="mstns:StructureTypeId" />
</xs:unique>
<xs:unique name="BuildingComponents_Constraint1"
msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
<xs:selector xpath=".//mstns:BuildingComponents" />
<xs:field xpath="mstns:BuildingId" />
<xs:field xpath="mstns:ComponentId" />
</xs:unique>
<xs:unique name="BuildingComponentsByType_Constraint1"
msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
<xs:selector xpath=".//mstns:BuildingComponentsByType" />
<xs:field xpath="mstns:ComponentId" />
<xs:field xpath="mstns:StructureTypeId" />
</xs:unique>
<xs:unique name="Countries_Constraint1"
msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
<xs:selector xpath=".//mstns:Countries" />
<xs:field xpath="mstns:CountryID" />
</xs:unique>
<xs:unique name="Provinces_Constraint1"
msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
<xs:selector xpath=".//mstns:Provinces" />
<xs:field xpath="mstns:ProvinceID" />
</xs:unique>
<xs:unique name="buildings_Constraint1"
msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
<xs:selector xpath=".//mstns:buildings" />
<xs:field xpath="mstns:BuildingId" />
</xs:unique>
<xs:unique name="Components_Constraint1"
msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
<xs:selector xpath=".//mstns:Components" />
<xs:field xpath="mstns:ComponentId" />
</xs:unique>
<xs:unique name="hierarchy_Constraint1"
msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
<xs:selector xpath=".//mstns:hierarchy" />
<xs:field xpath="mstns:HierarchyId" />
</xs:unique>
</xs:element>
</xs:schema>

Here is the error --

Custom tool error: Failed to generate code. Failed to generate code.
Object reference not set to an instance of an object. Object reference
not set to an instance of an object.

The custom tool is MSDataSetGenerator.

What can I do to fix this or troubleshoot it?
 
Back
Top