<?xml version="1.0" encoding="utf-8"?> <xs:schema id="ExampleDataSet" targetNamespace="http://tempuri.org/ExampleDataSet.xsd" xmlns:mstns="http://tempuri.org/ExampleDataSet.xsd" xmlns="http://tempuri.org/ExampleDataSet.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> <Connection ConnectionStringObject="Data Source=PC1;Initial Catalog=Example;Integrated Security=True;Encrypt=False" IsAppSettingsProperty="false" Modifier="Assembly" Name="pc1.Example.dbo" ParameterPrefix="@" Provider="System.Data.SqlClient" /> </Connections> <Tables> <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="OrderTableAdapter" GeneratorDataComponentClassName="OrderTableAdapter" Name="Order" UserDataComponentName="OrderTableAdapter"> <MainSource> <DbSource ConnectionRef="pc1.Example.dbo" DbObjectName="Example.dbo.[Order]" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill"> <DeleteCommand> <DbCommand CommandType="Text" ModifiedByUser="false"> <CommandText>DELETE FROM [dbo].[Order] WHERE (([ID_order] = @Original_ID_order) AND ([OrderNumber] = @Original_OrderNumber) AND ([ID_user] = @Original_ID_user) AND ([ID_product] = @Original_ID_product) AND ([NumberOfPosition] = @Original_NumberOfPosition) AND ([Address] = @Original_Address) AND ([TotalCost] = @Original_TotalCost))</CommandText> <Parameters> <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_ID_order" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ID_order" SourceColumnNullMapping="false" SourceVersion="Original" /> <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_OrderNumber" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="OrderNumber" SourceColumnNullMapping="false" SourceVersion="Original" /> <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_ID_user" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ID_user" SourceColumnNullMapping="false" SourceVersion="Original" /> <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_ID_product" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ID_product" SourceColumnNullMapping="false" SourceVersion="Original" /> <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_NumberOfPosition" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="NumberOfPosition" SourceColumnNullMapping="false" SourceVersion="Original" /> <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Address" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Address" SourceColumnNullMapping="false" SourceVersion="Original" /> <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="@Original_TotalCost" Precision="0" ProviderType="Float" Scale="0" Size="0" SourceColumn="TotalCost" SourceColumnNullMapping="false" SourceVersion="Original" /> </Parameters> </DbCommand> </DeleteCommand> <InsertCommand> <DbCommand CommandType="Text" ModifiedByUser="false"> <CommandText>INSERT INTO [dbo].[Order] ([ID_order], [OrderNumber], [ID_user], [ID_product], [NumberOfPosition], [Address], [TotalCost]) VALUES (@ID_order, @OrderNumber, @ID_user, @ID_product, @NumberOfPosition, @Address, @TotalCost); SELECT ID_order, OrderNumber, ID_user, ID_product, NumberOfPosition, Address, TotalCost FROM [Order] WHERE (ID_order = @ID_order)</CommandText> <Parameters> <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@ID_order" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ID_order" SourceColumnNullMapping="false" SourceVersion="Current" /> <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@OrderNumber" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="OrderNumber" SourceColumnNullMapping="false" SourceVersion="Current" /> <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@ID_user" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ID_user" SourceColumnNullMapping="false" SourceVersion="Current" /> <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@ID_product" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ID_product" SourceColumnNullMapping="false" SourceVersion="Current" /> <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@NumberOfPosition" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="NumberOfPosition" SourceColumnNullMapping="false" SourceVersion="Current" /> <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Address" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Address" SourceColumnNullMapping="false" SourceVersion="Current" /> <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="@TotalCost" Precision="0" ProviderType="Float" Scale="0" Size="0" SourceColumn="TotalCost" SourceColumnNullMapping="false" SourceVersion="Current" /> </Parameters> </DbCommand> </InsertCommand> <SelectCommand> <DbCommand CommandType="Text" ModifiedByUser="false"> <CommandText>SELECT ID_order, OrderNumber, ID_user, ID_product, NumberOfPosition, Address, TotalCost FROM dbo.[Order]</CommandText> <Parameters /> </DbCommand> </SelectCommand> <UpdateCommand> <DbCommand CommandType="Text" ModifiedByUser="false"> <CommandText>UPDATE [dbo].[Order] SET [ID_order] = @ID_order, [OrderNumber] = @OrderNumber, [ID_user] = @ID_user, [ID_product] = @ID_product, [NumberOfPosition] = @NumberOfPosition, [Address] = @Address, [TotalCost] = @TotalCost WHERE (([ID_order] = @Original_ID_order) AND ([OrderNumber] = @Original_OrderNumber) AND ([ID_user] = @Original_ID_user) AND ([ID_product] = @Original_ID_product) AND ([NumberOfPosition] = @Original_NumberOfPosition) AND ([Address] = @Original_Address) AND ([TotalCost] = @Original_TotalCost)); SELECT ID_order, OrderNumber, ID_user, ID_product, NumberOfPosition, Address, TotalCost FROM [Order] WHERE (ID_order = @ID_order)</CommandText> <Parameters> <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@ID_order" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ID_order" SourceColumnNullMapping="false" SourceVersion="Current" /> <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@OrderNumber" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="OrderNumber" SourceColumnNullMapping="false" SourceVersion="Current" /> <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@ID_user" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ID_user" SourceColumnNullMapping="false" SourceVersion="Current" /> <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@ID_product" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ID_product" SourceColumnNullMapping="false" SourceVersion="Current" /> <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@NumberOfPosition" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="NumberOfPosition" SourceColumnNullMapping="false" SourceVersion="Current" /> <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Address" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Address" SourceColumnNullMapping="false" SourceVersion="Current" /> <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="@TotalCost" Precision="0" ProviderType="Float" Scale="0" Size="0" SourceColumn="TotalCost" SourceColumnNullMapping="false" SourceVersion="Current" /> <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_ID_order" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ID_order" SourceColumnNullMapping="false" SourceVersion="Original" /> <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_OrderNumber" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="OrderNumber" SourceColumnNullMapping="false" SourceVersion="Original" /> <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_ID_user" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ID_user" SourceColumnNullMapping="false" SourceVersion="Original" /> <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_ID_product" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ID_product" SourceColumnNullMapping="false" SourceVersion="Original" /> <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_NumberOfPosition" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="NumberOfPosition" SourceColumnNullMapping="false" SourceVersion="Original" /> <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_Address" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="Address" SourceColumnNullMapping="false" SourceVersion="Original" /> <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="@Original_TotalCost" Precision="0" ProviderType="Float" Scale="0" Size="0" SourceColumn="TotalCost" SourceColumnNullMapping="false" SourceVersion="Original" /> </Parameters> </DbCommand> </UpdateCommand> </DbSource> </MainSource> <Mappings> <Mapping SourceColumn="ID_order" DataSetColumn="ID_order" /> <Mapping SourceColumn="OrderNumber" DataSetColumn="OrderNumber" /> <Mapping SourceColumn="ID_user" DataSetColumn="ID_user" /> <Mapping SourceColumn="ID_product" DataSetColumn="ID_product" /> <Mapping SourceColumn="NumberOfPosition" DataSetColumn="NumberOfPosition" /> <Mapping SourceColumn="Address" DataSetColumn="Address" /> <Mapping SourceColumn="TotalCost" DataSetColumn="TotalCost" /> </Mappings> <Sources /> </TableAdapter> <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="ProductTableAdapter" GeneratorDataComponentClassName="ProductTableAdapter" Name="Product" UserDataComponentName="ProductTableAdapter"> <MainSource> <DbSource ConnectionRef="pc1.Example.dbo" DbObjectName="Example.dbo.Product" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill"> <DeleteCommand> <DbCommand CommandType="Text" ModifiedByUser="false"> <CommandText>DELETE FROM [dbo].[Product] WHERE (([ID_product] = @Original_ID_product) AND ([TitleProduct] = @Original_TitleProduct) AND ([DescriptionProduct] = @Original_DescriptionProduct) AND ([Cost] = @Original_Cost) AND ([QuanityStock] = @Original_QuanityStock) AND ([ExpirationDate] = @Original_ExpirationDate))</CommandText> <Parameters> <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_ID_product" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ID_product" SourceColumnNullMapping="false" SourceVersion="Original" /> <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_TitleProduct" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="TitleProduct" SourceColumnNullMapping="false" SourceVersion="Original" /> <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_DescriptionProduct" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="DescriptionProduct" SourceColumnNullMapping="false" SourceVersion="Original" /> <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="@Original_Cost" Precision="0" ProviderType="Float" Scale="0" Size="0" SourceColumn="Cost" SourceColumnNullMapping="false" SourceVersion="Original" /> <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_QuanityStock" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="QuanityStock" SourceColumnNullMapping="false" SourceVersion="Original" /> <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Date" Direction="Input" ParameterName="@Original_ExpirationDate" Precision="0" ProviderType="Date" Scale="0" Size="0" SourceColumn="ExpirationDate" SourceColumnNullMapping="false" SourceVersion="Original" /> </Parameters> </DbCommand> </DeleteCommand> <InsertCommand> <DbCommand CommandType="Text" ModifiedByUser="false"> <CommandText>INSERT INTO [dbo].[Product] ([ID_product], [TitleProduct], [DescriptionProduct], [Cost], [QuanityStock], [ExpirationDate]) VALUES (@ID_product, @TitleProduct, @DescriptionProduct, @Cost, @QuanityStock, @ExpirationDate); SELECT ID_product, TitleProduct, DescriptionProduct, Cost, QuanityStock, ExpirationDate FROM Product WHERE (ID_product = @ID_product)</CommandText> <Parameters> <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@ID_product" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ID_product" SourceColumnNullMapping="false" SourceVersion="Current" /> <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@TitleProduct" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="TitleProduct" SourceColumnNullMapping="false" SourceVersion="Current" /> <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@DescriptionProduct" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="DescriptionProduct" SourceColumnNullMapping="false" SourceVersion="Current" /> <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="@Cost" Precision="0" ProviderType="Float" Scale="0" Size="0" SourceColumn="Cost" SourceColumnNullMapping="false" SourceVersion="Current" /> <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@QuanityStock" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="QuanityStock" SourceColumnNullMapping="false" SourceVersion="Current" /> <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Date" Direction="Input" ParameterName="@ExpirationDate" Precision="0" ProviderType="Date" Scale="0" Size="0" SourceColumn="ExpirationDate" SourceColumnNullMapping="false" SourceVersion="Current" /> </Parameters> </DbCommand> </InsertCommand> <SelectCommand> <DbCommand CommandType="Text" ModifiedByUser="false"> <CommandText>SELECT ID_product, TitleProduct, DescriptionProduct, Cost, QuanityStock, ExpirationDate FROM dbo.Product</CommandText> <Parameters /> </DbCommand> </SelectCommand> <UpdateCommand> <DbCommand CommandType="Text" ModifiedByUser="false"> <CommandText>UPDATE [dbo].[Product] SET [ID_product] = @ID_product, [TitleProduct] = @TitleProduct, [DescriptionProduct] = @DescriptionProduct, [Cost] = @Cost, [QuanityStock] = @QuanityStock, [ExpirationDate] = @ExpirationDate WHERE (([ID_product] = @Original_ID_product) AND ([TitleProduct] = @Original_TitleProduct) AND ([DescriptionProduct] = @Original_DescriptionProduct) AND ([Cost] = @Original_Cost) AND ([QuanityStock] = @Original_QuanityStock) AND ([ExpirationDate] = @Original_ExpirationDate)); SELECT ID_product, TitleProduct, DescriptionProduct, Cost, QuanityStock, ExpirationDate FROM Product WHERE (ID_product = @ID_product)</CommandText> <Parameters> <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@ID_product" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ID_product" SourceColumnNullMapping="false" SourceVersion="Current" /> <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@TitleProduct" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="TitleProduct" SourceColumnNullMapping="false" SourceVersion="Current" /> <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@DescriptionProduct" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="DescriptionProduct" SourceColumnNullMapping="false" SourceVersion="Current" /> <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="@Cost" Precision="0" ProviderType="Float" Scale="0" Size="0" SourceColumn="Cost" SourceColumnNullMapping="false" SourceVersion="Current" /> <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@QuanityStock" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="QuanityStock" SourceColumnNullMapping="false" SourceVersion="Current" /> <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Date" Direction="Input" ParameterName="@ExpirationDate" Precision="0" ProviderType="Date" Scale="0" Size="0" SourceColumn="ExpirationDate" SourceColumnNullMapping="false" SourceVersion="Current" /> <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_ID_product" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ID_product" SourceColumnNullMapping="false" SourceVersion="Original" /> <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_TitleProduct" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="TitleProduct" SourceColumnNullMapping="false" SourceVersion="Original" /> <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_DescriptionProduct" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="DescriptionProduct" SourceColumnNullMapping="false" SourceVersion="Original" /> <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="@Original_Cost" Precision="0" ProviderType="Float" Scale="0" Size="0" SourceColumn="Cost" SourceColumnNullMapping="false" SourceVersion="Original" /> <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_QuanityStock" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="QuanityStock" SourceColumnNullMapping="false" SourceVersion="Original" /> <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Date" Direction="Input" ParameterName="@Original_ExpirationDate" Precision="0" ProviderType="Date" Scale="0" Size="0" SourceColumn="ExpirationDate" SourceColumnNullMapping="false" SourceVersion="Original" /> </Parameters> </DbCommand> </UpdateCommand> </DbSource> </MainSource> <Mappings> <Mapping SourceColumn="ID_product" DataSetColumn="ID_product" /> <Mapping SourceColumn="TitleProduct" DataSetColumn="TitleProduct" /> <Mapping SourceColumn="DescriptionProduct" DataSetColumn="DescriptionProduct" /> <Mapping SourceColumn="Cost" DataSetColumn="Cost" /> <Mapping SourceColumn="QuanityStock" DataSetColumn="QuanityStock" /> <Mapping SourceColumn="ExpirationDate" DataSetColumn="ExpirationDate" /> </Mappings> <Sources /> </TableAdapter> <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="RoleTableAdapter" GeneratorDataComponentClassName="RoleTableAdapter" Name="Role" UserDataComponentName="RoleTableAdapter"> <MainSource> <DbSource ConnectionRef="pc1.Example.dbo" DbObjectName="Example.dbo.Role" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill"> <DeleteCommand> <DbCommand CommandType="Text" ModifiedByUser="false"> <CommandText>DELETE FROM [dbo].[Role] WHERE (([ID_role] = @Original_ID_role) AND ([TitleRole] = @Original_TitleRole) AND ([DescriptionRole] = @Original_DescriptionRole))</CommandText> <Parameters> <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_ID_role" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ID_role" SourceColumnNullMapping="false" SourceVersion="Original" /> <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_TitleRole" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="TitleRole" SourceColumnNullMapping="false" SourceVersion="Original" /> <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_DescriptionRole" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="DescriptionRole" SourceColumnNullMapping="false" SourceVersion="Original" /> </Parameters> </DbCommand> </DeleteCommand> <InsertCommand> <DbCommand CommandType="Text" ModifiedByUser="false"> <CommandText>INSERT INTO [dbo].[Role] ([ID_role], [TitleRole], [DescriptionRole]) VALUES (@ID_role, @TitleRole, @DescriptionRole); SELECT ID_role, TitleRole, DescriptionRole FROM Role WHERE (ID_role = @ID_role)</CommandText> <Parameters> <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@ID_role" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ID_role" SourceColumnNullMapping="false" SourceVersion="Current" /> <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@TitleRole" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="TitleRole" SourceColumnNullMapping="false" SourceVersion="Current" /> <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@DescriptionRole" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="DescriptionRole" SourceColumnNullMapping="false" SourceVersion="Current" /> </Parameters> </DbCommand> </InsertCommand> <SelectCommand> <DbCommand CommandType="Text" ModifiedByUser="false"> <CommandText>SELECT ID_role, TitleRole, DescriptionRole FROM dbo.Role</CommandText> <Parameters /> </DbCommand> </SelectCommand> <UpdateCommand> <DbCommand CommandType="Text" ModifiedByUser="false"> <CommandText>UPDATE [dbo].[Role] SET [ID_role] = @ID_role, [TitleRole] = @TitleRole, [DescriptionRole] = @DescriptionRole WHERE (([ID_role] = @Original_ID_role) AND ([TitleRole] = @Original_TitleRole) AND ([DescriptionRole] = @Original_DescriptionRole)); SELECT ID_role, TitleRole, DescriptionRole FROM Role WHERE (ID_role = @ID_role)</CommandText> <Parameters> <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@ID_role" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ID_role" SourceColumnNullMapping="false" SourceVersion="Current" /> <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@TitleRole" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="TitleRole" SourceColumnNullMapping="false" SourceVersion="Current" /> <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@DescriptionRole" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="DescriptionRole" SourceColumnNullMapping="false" SourceVersion="Current" /> <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_ID_role" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ID_role" SourceColumnNullMapping="false" SourceVersion="Original" /> <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_TitleRole" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="TitleRole" SourceColumnNullMapping="false" SourceVersion="Original" /> <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_DescriptionRole" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="DescriptionRole" SourceColumnNullMapping="false" SourceVersion="Original" /> </Parameters> </DbCommand> </UpdateCommand> </DbSource> </MainSource> <Mappings> <Mapping SourceColumn="ID_role" DataSetColumn="ID_role" /> <Mapping SourceColumn="TitleRole" DataSetColumn="TitleRole" /> <Mapping SourceColumn="DescriptionRole" DataSetColumn="DescriptionRole" /> </Mappings> <Sources /> </TableAdapter> <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="UsersTableAdapter" GeneratorDataComponentClassName="UsersTableAdapter" Name="Users" UserDataComponentName="UsersTableAdapter"> <MainSource> <DbSource ConnectionRef="pc1.Example.dbo" DbObjectName="Example.dbo.Users" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill"> <DeleteCommand> <DbCommand CommandType="Text" ModifiedByUser="false"> <CommandText>DELETE FROM [dbo].[Users] WHERE (([ID_user] = @Original_ID_user) AND ([NameUser] = @Original_NameUser) AND ([SurnameUser] = @Original_SurnameUser) AND ([LoginUser] = @Original_LoginUser) AND ([PasswordUser] = @Original_PasswordUser) AND ([ID_role] = @Original_ID_role))</CommandText> <Parameters> <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_ID_user" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ID_user" SourceColumnNullMapping="false" SourceVersion="Original" /> <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_NameUser" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="NameUser" SourceColumnNullMapping="false" SourceVersion="Original" /> <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_SurnameUser" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="SurnameUser" SourceColumnNullMapping="false" SourceVersion="Original" /> <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_LoginUser" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="LoginUser" SourceColumnNullMapping="false" SourceVersion="Original" /> <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_PasswordUser" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="PasswordUser" SourceColumnNullMapping="false" SourceVersion="Original" /> <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_ID_role" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ID_role" SourceColumnNullMapping="false" SourceVersion="Original" /> </Parameters> </DbCommand> </DeleteCommand> <InsertCommand> <DbCommand CommandType="Text" ModifiedByUser="false"> <CommandText>INSERT INTO [dbo].[Users] ([ID_user], [NameUser], [SurnameUser], [LoginUser], [PasswordUser], [ID_role]) VALUES (@ID_user, @NameUser, @SurnameUser, @LoginUser, @PasswordUser, @ID_role); SELECT ID_user, NameUser, SurnameUser, LoginUser, PasswordUser, ID_role FROM Users WHERE (ID_user = @ID_user)</CommandText> <Parameters> <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@ID_user" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ID_user" SourceColumnNullMapping="false" SourceVersion="Current" /> <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@NameUser" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="NameUser" SourceColumnNullMapping="false" SourceVersion="Current" /> <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@SurnameUser" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="SurnameUser" SourceColumnNullMapping="false" SourceVersion="Current" /> <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@LoginUser" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="LoginUser" SourceColumnNullMapping="false" SourceVersion="Current" /> <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@PasswordUser" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="PasswordUser" SourceColumnNullMapping="false" SourceVersion="Current" /> <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@ID_role" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ID_role" SourceColumnNullMapping="false" SourceVersion="Current" /> </Parameters> </DbCommand> </InsertCommand> <SelectCommand> <DbCommand CommandType="Text" ModifiedByUser="false"> <CommandText>SELECT ID_user, NameUser, SurnameUser, LoginUser, PasswordUser, ID_role FROM dbo.Users</CommandText> <Parameters /> </DbCommand> </SelectCommand> <UpdateCommand> <DbCommand CommandType="Text" ModifiedByUser="false"> <CommandText>UPDATE [dbo].[Users] SET [ID_user] = @ID_user, [NameUser] = @NameUser, [SurnameUser] = @SurnameUser, [LoginUser] = @LoginUser, [PasswordUser] = @PasswordUser, [ID_role] = @ID_role WHERE (([ID_user] = @Original_ID_user) AND ([NameUser] = @Original_NameUser) AND ([SurnameUser] = @Original_SurnameUser) AND ([LoginUser] = @Original_LoginUser) AND ([PasswordUser] = @Original_PasswordUser) AND ([ID_role] = @Original_ID_role)); SELECT ID_user, NameUser, SurnameUser, LoginUser, PasswordUser, ID_role FROM Users WHERE (ID_user = @ID_user)</CommandText> <Parameters> <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@ID_user" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ID_user" SourceColumnNullMapping="false" SourceVersion="Current" /> <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@NameUser" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="NameUser" SourceColumnNullMapping="false" SourceVersion="Current" /> <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@SurnameUser" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="SurnameUser" SourceColumnNullMapping="false" SourceVersion="Current" /> <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@LoginUser" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="LoginUser" SourceColumnNullMapping="false" SourceVersion="Current" /> <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@PasswordUser" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="PasswordUser" SourceColumnNullMapping="false" SourceVersion="Current" /> <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@ID_role" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ID_role" SourceColumnNullMapping="false" SourceVersion="Current" /> <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_ID_user" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ID_user" SourceColumnNullMapping="false" SourceVersion="Original" /> <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_NameUser" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="NameUser" SourceColumnNullMapping="false" SourceVersion="Original" /> <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_SurnameUser" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="SurnameUser" SourceColumnNullMapping="false" SourceVersion="Original" /> <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_LoginUser" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="LoginUser" SourceColumnNullMapping="false" SourceVersion="Original" /> <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_PasswordUser" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="PasswordUser" SourceColumnNullMapping="false" SourceVersion="Original" /> <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_ID_role" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ID_role" SourceColumnNullMapping="false" SourceVersion="Original" /> </Parameters> </DbCommand> </UpdateCommand> </DbSource> </MainSource> <Mappings> <Mapping SourceColumn="ID_user" DataSetColumn="ID_user" /> <Mapping SourceColumn="NameUser" DataSetColumn="NameUser" /> <Mapping SourceColumn="SurnameUser" DataSetColumn="SurnameUser" /> <Mapping SourceColumn="LoginUser" DataSetColumn="LoginUser" /> <Mapping SourceColumn="PasswordUser" DataSetColumn="PasswordUser" /> <Mapping SourceColumn="ID_role" DataSetColumn="ID_role" /> </Mappings> <Sources /> </TableAdapter> </Tables> <Sources /> </DataSource> </xs:appinfo> </xs:annotation> <xs:element name="ExampleDataSet" msdata:IsDataSet="true" msdata:UseCurrentLocale="true" msprop:EnableTableAdapterManager="True" msprop:Generator_UserDSName="ExampleDataSet" msprop:Generator_DataSetName="ExampleDataSet"> <xs:complexType> <xs:choice minOccurs="0" maxOccurs="unbounded"> <xs:element name="Order" msprop:Generator_RowEvHandlerName="OrderRowChangeEventHandler" msprop:Generator_RowDeletedName="OrderRowDeleted" msprop:Generator_RowDeletingName="OrderRowDeleting" msprop:Generator_RowEvArgName="OrderRowChangeEvent" msprop:Generator_TablePropName="Order" msprop:Generator_RowChangedName="OrderRowChanged" msprop:Generator_RowChangingName="OrderRowChanging" msprop:Generator_TableClassName="OrderDataTable" msprop:Generator_RowClassName="OrderRow" msprop:Generator_TableVarName="tableOrder" msprop:Generator_UserTableName="Order"> <xs:complexType> <xs:sequence> <xs:element name="ID_order" msprop:Generator_ColumnPropNameInRow="ID_order" msprop:Generator_ColumnPropNameInTable="ID_orderColumn" msprop:Generator_ColumnVarNameInTable="columnID_order" msprop:Generator_UserColumnName="ID_order" type="xs:int" /> <xs:element name="OrderNumber" msprop:Generator_ColumnPropNameInRow="OrderNumber" msprop:Generator_ColumnPropNameInTable="OrderNumberColumn" msprop:Generator_ColumnVarNameInTable="columnOrderNumber" msprop:Generator_UserColumnName="OrderNumber" type="xs:int" /> <xs:element name="ID_user" msprop:Generator_ColumnPropNameInRow="ID_user" msprop:Generator_ColumnPropNameInTable="ID_userColumn" msprop:Generator_ColumnVarNameInTable="columnID_user" msprop:Generator_UserColumnName="ID_user" type="xs:int" /> <xs:element name="ID_product" msprop:Generator_ColumnPropNameInRow="ID_product" msprop:Generator_ColumnPropNameInTable="ID_productColumn" msprop:Generator_ColumnVarNameInTable="columnID_product" msprop:Generator_UserColumnName="ID_product" type="xs:int" /> <xs:element name="NumberOfPosition" msprop:Generator_ColumnPropNameInRow="NumberOfPosition" msprop:Generator_ColumnPropNameInTable="NumberOfPositionColumn" msprop:Generator_ColumnVarNameInTable="columnNumberOfPosition" msprop:Generator_UserColumnName="NumberOfPosition" type="xs:int" /> <xs:element name="Address" msprop:Generator_ColumnPropNameInRow="Address" msprop:Generator_ColumnPropNameInTable="AddressColumn" msprop:Generator_ColumnVarNameInTable="columnAddress" msprop:Generator_UserColumnName="Address"> <xs:simpleType> <xs:restriction base="xs:string"> <xs:maxLength value="20" /> </xs:restriction> </xs:simpleType> </xs:element> <xs:element name="TotalCost" msprop:Generator_ColumnPropNameInRow="TotalCost" msprop:Generator_ColumnPropNameInTable="TotalCostColumn" msprop:Generator_ColumnVarNameInTable="columnTotalCost" msprop:Generator_UserColumnName="TotalCost" type="xs:double" /> </xs:sequence> </xs:complexType> </xs:element> <xs:element name="Product" msprop:Generator_RowEvHandlerName="ProductRowChangeEventHandler" msprop:Generator_RowDeletedName="ProductRowDeleted" msprop:Generator_RowDeletingName="ProductRowDeleting" msprop:Generator_RowEvArgName="ProductRowChangeEvent" msprop:Generator_TablePropName="Product" msprop:Generator_RowChangedName="ProductRowChanged" msprop:Generator_RowChangingName="ProductRowChanging" msprop:Generator_TableClassName="ProductDataTable" msprop:Generator_RowClassName="ProductRow" msprop:Generator_TableVarName="tableProduct" msprop:Generator_UserTableName="Product"> <xs:complexType> <xs:sequence> <xs:element name="ID_product" msprop:Generator_ColumnPropNameInRow="ID_product" msprop:Generator_ColumnPropNameInTable="ID_productColumn" msprop:Generator_ColumnVarNameInTable="columnID_product" msprop:Generator_UserColumnName="ID_product" type="xs:int" /> <xs:element name="TitleProduct" msprop:Generator_ColumnPropNameInRow="TitleProduct" msprop:Generator_ColumnPropNameInTable="TitleProductColumn" msprop:Generator_ColumnVarNameInTable="columnTitleProduct" msprop:Generator_UserColumnName="TitleProduct"> <xs:simpleType> <xs:restriction base="xs:string"> <xs:maxLength value="50" /> </xs:restriction> </xs:simpleType> </xs:element> <xs:element name="DescriptionProduct" msprop:Generator_ColumnPropNameInRow="DescriptionProduct" msprop:Generator_ColumnPropNameInTable="DescriptionProductColumn" msprop:Generator_ColumnVarNameInTable="columnDescriptionProduct" msprop:Generator_UserColumnName="DescriptionProduct"> <xs:simpleType> <xs:restriction base="xs:string"> <xs:maxLength value="50" /> </xs:restriction> </xs:simpleType> </xs:element> <xs:element name="Cost" msprop:Generator_ColumnPropNameInRow="Cost" msprop:Generator_ColumnPropNameInTable="CostColumn" msprop:Generator_ColumnVarNameInTable="columnCost" msprop:Generator_UserColumnName="Cost" type="xs:double" /> <xs:element name="QuanityStock" msprop:Generator_ColumnPropNameInRow="QuanityStock" msprop:Generator_ColumnPropNameInTable="QuanityStockColumn" msprop:Generator_ColumnVarNameInTable="columnQuanityStock" msprop:Generator_UserColumnName="QuanityStock" type="xs:int" /> <xs:element name="ExpirationDate" msprop:Generator_ColumnPropNameInRow="ExpirationDate" msprop:Generator_ColumnPropNameInTable="ExpirationDateColumn" msprop:Generator_ColumnVarNameInTable="columnExpirationDate" msprop:Generator_UserColumnName="ExpirationDate" type="xs:dateTime" /> </xs:sequence> </xs:complexType> </xs:element> <xs:element name="Role" msprop:Generator_RowEvHandlerName="RoleRowChangeEventHandler" msprop:Generator_RowDeletedName="RoleRowDeleted" msprop:Generator_RowDeletingName="RoleRowDeleting" msprop:Generator_RowEvArgName="RoleRowChangeEvent" msprop:Generator_TablePropName="Role" msprop:Generator_RowChangedName="RoleRowChanged" msprop:Generator_RowChangingName="RoleRowChanging" msprop:Generator_TableClassName="RoleDataTable" msprop:Generator_RowClassName="RoleRow" msprop:Generator_TableVarName="tableRole" msprop:Generator_UserTableName="Role"> <xs:complexType> <xs:sequence> <xs:element name="ID_role" msprop:Generator_ColumnPropNameInRow="ID_role" msprop:Generator_ColumnPropNameInTable="ID_roleColumn" msprop:Generator_ColumnVarNameInTable="columnID_role" msprop:Generator_UserColumnName="ID_role" type="xs:int" /> <xs:element name="TitleRole" msprop:Generator_ColumnPropNameInRow="TitleRole" msprop:Generator_ColumnPropNameInTable="TitleRoleColumn" msprop:Generator_ColumnVarNameInTable="columnTitleRole" msprop:Generator_UserColumnName="TitleRole"> <xs:simpleType> <xs:restriction base="xs:string"> <xs:maxLength value="50" /> </xs:restriction> </xs:simpleType> </xs:element> <xs:element name="DescriptionRole" msprop:Generator_ColumnPropNameInRow="DescriptionRole" msprop:Generator_ColumnPropNameInTable="DescriptionRoleColumn" msprop:Generator_ColumnVarNameInTable="columnDescriptionRole" msprop:Generator_UserColumnName="DescriptionRole"> <xs:simpleType> <xs:restriction base="xs:string"> <xs:maxLength value="100" /> </xs:restriction> </xs:simpleType> </xs:element> </xs:sequence> </xs:complexType> </xs:element> <xs:element name="Users" msprop:Generator_RowEvHandlerName="UsersRowChangeEventHandler" msprop:Generator_RowDeletedName="UsersRowDeleted" msprop:Generator_RowDeletingName="UsersRowDeleting" msprop:Generator_RowEvArgName="UsersRowChangeEvent" msprop:Generator_TablePropName="Users" msprop:Generator_RowChangedName="UsersRowChanged" msprop:Generator_RowChangingName="UsersRowChanging" msprop:Generator_TableClassName="UsersDataTable" msprop:Generator_RowClassName="UsersRow" msprop:Generator_TableVarName="tableUsers" msprop:Generator_UserTableName="Users"> <xs:complexType> <xs:sequence> <xs:element name="ID_user" msprop:Generator_ColumnPropNameInRow="ID_user" msprop:Generator_ColumnPropNameInTable="ID_userColumn" msprop:Generator_ColumnVarNameInTable="columnID_user" msprop:Generator_UserColumnName="ID_user" type="xs:int" /> <xs:element name="NameUser" msprop:Generator_ColumnPropNameInRow="NameUser" msprop:Generator_ColumnPropNameInTable="NameUserColumn" msprop:Generator_ColumnVarNameInTable="columnNameUser" msprop:Generator_UserColumnName="NameUser"> <xs:simpleType> <xs:restriction base="xs:string"> <xs:maxLength value="50" /> </xs:restriction> </xs:simpleType> </xs:element> <xs:element name="SurnameUser" msprop:Generator_ColumnPropNameInRow="SurnameUser" msprop:Generator_ColumnPropNameInTable="SurnameUserColumn" msprop:Generator_ColumnVarNameInTable="columnSurnameUser" msprop:Generator_UserColumnName="SurnameUser"> <xs:simpleType> <xs:restriction base="xs:string"> <xs:maxLength value="50" /> </xs:restriction> </xs:simpleType> </xs:element> <xs:element name="LoginUser" msprop:Generator_ColumnPropNameInRow="LoginUser" msprop:Generator_ColumnPropNameInTable="LoginUserColumn" msprop:Generator_ColumnVarNameInTable="columnLoginUser" msprop:Generator_UserColumnName="LoginUser"> <xs:simpleType> <xs:restriction base="xs:string"> <xs:maxLength value="50" /> </xs:restriction> </xs:simpleType> </xs:element> <xs:element name="PasswordUser" msprop:Generator_ColumnPropNameInRow="PasswordUser" msprop:Generator_ColumnPropNameInTable="PasswordUserColumn" msprop:Generator_ColumnVarNameInTable="columnPasswordUser" msprop:Generator_UserColumnName="PasswordUser"> <xs:simpleType> <xs:restriction base="xs:string"> <xs:maxLength value="50" /> </xs:restriction> </xs:simpleType> </xs:element> <xs:element name="ID_role" msprop:Generator_ColumnPropNameInRow="ID_role" msprop:Generator_ColumnPropNameInTable="ID_roleColumn" msprop:Generator_ColumnVarNameInTable="columnID_role" msprop:Generator_UserColumnName="ID_role" type="xs:int" /> </xs:sequence> </xs:complexType> </xs:element> </xs:choice> </xs:complexType> <xs:unique name="Constraint1" msdata:PrimaryKey="true"> <xs:selector xpath=".//mstns:Order" /> <xs:field xpath="mstns:ID_order" /> </xs:unique> <xs:unique name="Product_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true"> <xs:selector xpath=".//mstns:Product" /> <xs:field xpath="mstns:ID_product" /> </xs:unique> <xs:unique name="Role_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true"> <xs:selector xpath=".//mstns:Role" /> <xs:field xpath="mstns:ID_role" /> </xs:unique> <xs:unique name="Users_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true"> <xs:selector xpath=".//mstns:Users" /> <xs:field xpath="mstns:ID_user" /> </xs:unique> </xs:element> <xs:annotation> <xs:appinfo> <msdata:Relationship name="FK__Order__ID_produc__44FF419A" msdata:parent="Product" msdata:child="Order" msdata:parentkey="ID_product" msdata:childkey="ID_product" msprop:Generator_UserParentTable="Product" msprop:Generator_UserChildTable="Order" msprop:Generator_RelationVarName="relationFK__Order__ID_produc__44FF419A" msprop:Generator_UserRelationName="FK__Order__ID_produc__44FF419A" msprop:Generator_ChildPropName="GetOrderRows" msprop:Generator_ParentPropName="ProductRow" /> <msdata:Relationship name="FK__Order__ID_user__440B1D61" msdata:parent="Users" msdata:child="Order" msdata:parentkey="ID_user" msdata:childkey="ID_user" msprop:Generator_UserParentTable="Users" msprop:Generator_UserChildTable="Order" msprop:Generator_RelationVarName="relationFK__Order__ID_user__440B1D61" msprop:Generator_UserRelationName="FK__Order__ID_user__440B1D61" msprop:Generator_ChildPropName="GetOrderRows" msprop:Generator_ParentPropName="UsersRow" /> <msdata:Relationship name="FK__Users__ID_role__3F466844" msdata:parent="Role" msdata:child="Users" msdata:parentkey="ID_role" msdata:childkey="ID_role" msprop:Generator_UserParentTable="Role" msprop:Generator_UserChildTable="Users" msprop:Generator_RelationVarName="relationFK__Users__ID_role__3F466844" msprop:Generator_ChildPropName="GetUsersRows" msprop:Generator_ParentPropName="RoleRow" msprop:Generator_UserRelationName="FK__Users__ID_role__3F466844" /> </xs:appinfo> </xs:annotation> </xs:schema>