<?xml version="1.0" encoding="utf-8"?> <xs:schema id="ds" targetNamespace="http://tempuri.org/ds.xsd" xmlns:mstns="http://tempuri.org/ds.xsd" xmlns="http://tempuri.org/ds.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="0" FunctionsComponentName="QueriesTableAdapter" Modifier="AutoLayout, AnsiClass, Class, Public" SchemaSerializationMode="IncludeSchema" xmlns="urn:schemas-microsoft-com:xml-msdatasource"> <Connections /> <Tables /> <Sources /> </DataSource> </xs:appinfo> </xs:annotation> <xs:element name="ds" msdata:IsDataSet="true" msdata:UseCurrentLocale="true" msprop:Generator_UserDSName="ds" msprop:Generator_DataSetName="ds" msprop:EnableTableAdapterManager="true"> <xs:complexType> <xs:choice minOccurs="0" maxOccurs="unbounded"> <xs:element name="Category" msprop:Generator_UserTableName="Category" msprop:Generator_RowDeletedName="CategoryRowDeleted" msprop:Generator_RowChangedName="CategoryRowChanged" msprop:Generator_RowClassName="CategoryRow" msprop:Generator_RowChangingName="CategoryRowChanging" msprop:Generator_RowEvArgName="CategoryRowChangeEvent" msprop:Generator_RowEvHandlerName="CategoryRowChangeEventHandler" msprop:Generator_TableClassName="CategoryDataTable" msprop:Generator_TableVarName="tableCategory" msprop:Generator_RowDeletingName="CategoryRowDeleting" msprop:Generator_TablePropName="Category"> <xs:complexType> <xs:sequence> <xs:element name="Category_ID" msdata:AutoIncrement="true" msdata:AutoIncrementSeed="1" msprop:Generator_UserColumnName="Category_ID" msprop:Generator_ColumnVarNameInTable="columnCategory_ID" msprop:Generator_ColumnPropNameInRow="Category_ID" msprop:Generator_ColumnPropNameInTable="Category_IDColumn" type="xs:int" /> <xs:element name="Category" msprop:Generator_UserColumnName="Category" msprop:Generator_ColumnVarNameInTable="columnCategory" msprop:Generator_ColumnPropNameInRow="Category" msprop:Generator_ColumnPropNameInTable="CategoryColumn" type="xs:string" minOccurs="0" /> </xs:sequence> </xs:complexType> </xs:element> <xs:element name="User" msprop:Generator_UserTableName="User" msprop:Generator_RowDeletedName="UserRowDeleted" msprop:Generator_RowChangedName="UserRowChanged" msprop:Generator_RowClassName="UserRow" msprop:Generator_RowChangingName="UserRowChanging" msprop:Generator_RowEvArgName="UserRowChangeEvent" msprop:Generator_RowEvHandlerName="UserRowChangeEventHandler" msprop:Generator_TableClassName="UserDataTable" msprop:Generator_TableVarName="tableUser" msprop:Generator_RowDeletingName="UserRowDeleting" msprop:Generator_TablePropName="User"> <xs:complexType> <xs:sequence> <xs:element name="User_ID" msprop:Generator_UserColumnName="User_ID" msprop:Generator_ColumnVarNameInTable="columnUser_ID" msprop:Generator_ColumnPropNameInRow="User_ID" msprop:Generator_ColumnPropNameInTable="User_IDColumn" type="xs:int" /> <xs:element name="User" msprop:Generator_UserColumnName="User" msprop:Generator_ColumnVarNameInTable="columnUser" msprop:Generator_ColumnPropNameInRow="User" msprop:Generator_ColumnPropNameInTable="UserColumn" type="xs:string" minOccurs="0" /> </xs:sequence> </xs:complexType> </xs:element> <xs:element name="Portlet" msprop:Generator_UserTableName="Portlet" msprop:Generator_RowDeletedName="PortletRowDeleted" msprop:Generator_RowChangedName="PortletRowChanged" msprop:Generator_RowClassName="PortletRow" msprop:Generator_RowChangingName="PortletRowChanging" msprop:Generator_RowEvArgName="PortletRowChangeEvent" msprop:Generator_RowEvHandlerName="PortletRowChangeEventHandler" msprop:Generator_TableClassName="PortletDataTable" msprop:Generator_TableVarName="tablePortlet" msprop:Generator_RowDeletingName="PortletRowDeleting" msprop:Generator_TablePropName="Portlet"> <xs:complexType> <xs:sequence> <xs:element name="Portlet_ID" msdata:AutoIncrement="true" msdata:AutoIncrementSeed="1" msprop:Generator_UserColumnName="Portlet_ID" msprop:Generator_ColumnVarNameInTable="columnPortlet_ID" msprop:Generator_ColumnPropNameInRow="Portlet_ID" msprop:Generator_ColumnPropNameInTable="Portlet_IDColumn" type="xs:int" /> <xs:element name="Category_ID" msprop:Generator_UserColumnName="Category_ID" msprop:Generator_ColumnVarNameInTable="columnCategory_ID" msprop:Generator_ColumnPropNameInRow="Category_ID" msprop:Generator_ColumnPropNameInTable="Category_IDColumn" type="xs:int" minOccurs="0" /> <xs:element name="Link" msprop:Generator_UserColumnName="Link" msprop:Generator_ColumnVarNameInTable="columnLink" msprop:Generator_ColumnPropNameInRow="Link" msprop:Generator_ColumnPropNameInTable="LinkColumn" type="xs:string" minOccurs="0" /> <xs:element name="Column_No" msprop:Generator_UserColumnName="Column_No" msprop:Generator_ColumnVarNameInTable="columnColumn_No" msprop:Generator_ColumnPropNameInRow="Column_No" msprop:Generator_ColumnPropNameInTable="Column_NoColumn" type="xs:int" minOccurs="0" /> <xs:element name="Title" msprop:Generator_UserColumnName="Title" msprop:Generator_ColumnVarNameInTable="columnTitle" msprop:Generator_ColumnPropNameInRow="Title" msprop:Generator_ColumnPropNameInTable="TitleColumn" type="xs:string" minOccurs="0" /> <xs:element name="Row_Sequence" msprop:Generator_UserColumnName="Row_Sequence" msprop:Generator_ColumnPropNameInRow="Row_Sequence" msprop:Generator_ColumnVarNameInTable="columnRow_Sequence" msprop:Generator_ColumnPropNameInTable="Row_SequenceColumn" type="xs:int" minOccurs="0" /> <xs:element name="Is_Image_Allowed" msprop:Generator_UserColumnName="Is_Image_Allowed" msprop:Generator_ColumnPropNameInRow="Is_Image_Allowed" msprop:Generator_ColumnVarNameInTable="columnIs_Image_Allowed" msprop:Generator_ColumnPropNameInTable="Is_Image_AllowedColumn" type="xs:boolean" minOccurs="0" /> <xs:element name="RSS_Feed" msprop:Generator_UserColumnName="RSS_Feed" msprop:Generator_ColumnPropNameInRow="RSS_Feed" msprop:Generator_ColumnVarNameInTable="columnRSS_Feed" msprop:Generator_ColumnPropNameInTable="RSS_FeedColumn" type="xs:string" minOccurs="0" /> </xs:sequence> </xs:complexType> </xs:element> <xs:element name="Portlet_User" msprop:Generator_UserTableName="Portlet_User" msprop:Generator_RowDeletedName="Portlet_UserRowDeleted" msprop:Generator_RowChangedName="Portlet_UserRowChanged" msprop:Generator_RowClassName="Portlet_UserRow" msprop:Generator_RowChangingName="Portlet_UserRowChanging" msprop:Generator_RowEvArgName="Portlet_UserRowChangeEvent" msprop:Generator_RowEvHandlerName="Portlet_UserRowChangeEventHandler" msprop:Generator_TableClassName="Portlet_UserDataTable" msprop:Generator_TableVarName="tablePortlet_User" msprop:Generator_RowDeletingName="Portlet_UserRowDeleting" msprop:Generator_TablePropName="Portlet_User"> <xs:complexType> <xs:sequence> <xs:element name="Category_ID" msprop:Generator_UserColumnName="Category_ID" msprop:Generator_ColumnVarNameInTable="columnCategory_ID" msprop:Generator_ColumnPropNameInRow="Category_ID" msprop:Generator_ColumnPropNameInTable="Category_IDColumn" type="xs:int" /> <xs:element name="User_ID" msprop:Generator_UserColumnName="User_ID" msprop:Generator_ColumnVarNameInTable="columnUser_ID" msprop:Generator_ColumnPropNameInRow="User_ID" msprop:Generator_ColumnPropNameInTable="User_IDColumn" type="xs:int" /> <xs:element name="Portlet_ID" msprop:Generator_UserColumnName="Portlet_ID" msprop:Generator_ColumnVarNameInTable="columnPortlet_ID" msprop:Generator_ColumnPropNameInRow="Portlet_ID" msprop:Generator_ColumnPropNameInTable="Portlet_IDColumn" type="xs:int" /> <xs:element name="Column_No" msprop:Generator_UserColumnName="Column_No" msprop:Generator_ColumnVarNameInTable="columnColumn_No" msprop:Generator_ColumnPropNameInRow="Column_No" msprop:Generator_ColumnPropNameInTable="Column_NoColumn" type="xs:int" minOccurs="0" /> <xs:element name="Row_Sequence" msprop:Generator_UserColumnName="Row_Sequence" msprop:Generator_ColumnPropNameInRow="Row_Sequence" msprop:Generator_ColumnVarNameInTable="columnRow_Sequence" msprop:Generator_ColumnPropNameInTable="Row_SequenceColumn" type="xs:string" minOccurs="0" /> <xs:element name="Title" msprop:Generator_UserColumnName="Title" msprop:Generator_ColumnVarNameInTable="columnTitle" msprop:Generator_ColumnPropNameInRow="Title" msprop:Generator_ColumnPropNameInTable="TitleColumn" type="xs:string" minOccurs="0" /> <xs:element name="Is_Image_Allowed" msprop:Generator_UserColumnName="Is_Image_Allowed" msprop:Generator_ColumnPropNameInRow="Is_Image_Allowed" msprop:Generator_ColumnVarNameInTable="columnIs_Image_Allowed" msprop:Generator_ColumnPropNameInTable="Is_Image_AllowedColumn" type="xs:boolean" minOccurs="0" /> <xs:element name="Is_Active" msprop:Generator_UserColumnName="Is_Active" msprop:Generator_ColumnVarNameInTable="columnIs_Active" msprop:Generator_ColumnPropNameInRow="Is_Active" msprop:Generator_ColumnPropNameInTable="Is_ActiveColumn" type="xs:boolean" minOccurs="0" /> </xs:sequence> </xs:complexType> </xs:element> </xs:choice> </xs:complexType> <xs:unique name="Constraint1" msdata:PrimaryKey="true"> <xs:selector xpath=".//mstns:Category" /> <xs:field xpath="mstns:Category_ID" /> </xs:unique> <xs:unique name="User_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true"> <xs:selector xpath=".//mstns:User" /> <xs:field xpath="mstns:User_ID" /> </xs:unique> <xs:unique name="Portlet_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true"> <xs:selector xpath=".//mstns:Portlet" /> <xs:field xpath="mstns:Portlet_ID" /> </xs:unique> <xs:unique name="Portlet_User_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true"> <xs:selector xpath=".//mstns:Portlet_User" /> <xs:field xpath="mstns:Category_ID" /> <xs:field xpath="mstns:User_ID" /> <xs:field xpath="mstns:Portlet_ID" /> </xs:unique> <xs:keyref name="FK_Category_Porlet_Item" refer="Constraint1" msprop:rel_Generator_UserRelationName="FK_Category_Porlet_Item" msprop:rel_Generator_RelationVarName="relationFK_Category_Porlet_Item" msprop:rel_Generator_UserChildTable="Portlet" msprop:rel_Generator_UserParentTable="Category" msprop:rel_Generator_ParentPropName="CategoryRow" msprop:rel_Generator_ChildPropName="GetPortletRows"> <xs:selector xpath=".//mstns:Portlet" /> <xs:field xpath="mstns:Category_ID" /> </xs:keyref> </xs:element> <xs:annotation> <xs:appinfo> <msdata:Relationship name="Portlet_Portlet_User" msdata:parent="Portlet" msdata:child="Portlet_User" msdata:parentkey="Portlet_ID" msdata:childkey="Portlet_ID" msprop:Generator_UserRelationName="Portlet_Portlet_User" msprop:Generator_RelationVarName="relationPortlet_Portlet_User" msprop:Generator_UserChildTable="Portlet_User" msprop:Generator_UserParentTable="Portlet" msprop:Generator_ParentPropName="PortletRow" msprop:Generator_ChildPropName="GetPortlet_UserRows" /> <msdata:Relationship name="Category_Portlet_User" msdata:parent="Category" msdata:child="Portlet_User" msdata:parentkey="Category_ID" msdata:childkey="Category_ID" msprop:Generator_UserRelationName="Category_Portlet_User" msprop:Generator_RelationVarName="relationCategory_Portlet_User" msprop:Generator_UserChildTable="Portlet_User" msprop:Generator_UserParentTable="Category" msprop:Generator_ParentPropName="CategoryRow" msprop:Generator_ChildPropName="GetPortlet_UserRows" /> <msdata:Relationship name="User_Portlet_User" msdata:parent="User" msdata:child="Portlet_User" msdata:parentkey="User_ID" msdata:childkey="User_ID" msprop:Generator_UserRelationName="User_Portlet_User" msprop:Generator_RelationVarName="relationUser_Portlet_User" msprop:Generator_UserChildTable="Portlet_User" msprop:Generator_UserParentTable="User" msprop:Generator_ParentPropName="UserRow" msprop:Generator_ChildPropName="GetPortlet_UserRows" /> </xs:appinfo> </xs:annotation> </xs:schema>
By viewing downloads associated with this article you agree to the Terms of Service and the article's licence.
If a file you wish to view isn't highlighted, and is a text file (not binary), please let us know and we'll add colourisation support for it.
This article, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)