rasz/CSharpLibrary
1
0
Fork 0
Code Issues Pull Requests Projects Releases Wiki Activity
CSharpLibrary/tbTrabalhoDataSet.xsd

927 lines
137 KiB
XML
Raw Permalink Normal View History

initial commit
2021-09-02 08:04:56 -03:00
<?xml version="1.0" encoding="utf-8"?>
<xs:schema id="tbTrabalhoDataSet" targetNamespace="http://tempuri.org/tbTrabalhoDataSet.xsd" xmlns:mstns="http://tempuri.org/tbTrabalhoDataSet.xsd" xmlns="http://tempuri.org/tbTrabalhoDataSet.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 AppSettingsObjectName="Settings" AppSettingsPropertyName="tbTrabalhoConnectionString" ConnectionStringObject="" IsAppSettingsProperty="true" Modifier="Assembly" Name="tbTrabalhoConnectionString (Settings)" ParameterPrefix="@" PropertyReference="ApplicationSettings.CSharpLibrary.Properties.Settings.GlobalReference.Default.tbTrabalhoConnectionString" Provider="System.Data.SqlClient" />
</Connections>
<Tables>
<TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="tbClienteTableAdapter" GeneratorDataComponentClassName="tbClienteTableAdapter" Name="tbCliente" UserDataComponentName="tbClienteTableAdapter">
<MainSource>
<DbSource ConnectionRef="tbTrabalhoConnectionString (Settings)" DbObjectName="tbTrabalho.dbo.tbCliente" 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].[tbCliente] WHERE (([idCliente] = @Original_idCliente) AND ((@IsNull_nomeCliente = 1 AND [nomeCliente] IS NULL) OR ([nomeCliente] = @Original_nomeCliente)) AND ((@IsNull_rgCliente = 1 AND [rgCliente] IS NULL) OR ([rgCliente] = @Original_rgCliente)) AND ((@IsNull_cpfCliente = 1 AND [cpfCliente] IS NULL) OR ([cpfCliente] = @Original_cpfCliente)) AND ((@IsNull_telCliente = 1 AND [telCliente] IS NULL) OR ([telCliente] = @Original_telCliente)) AND ((@IsNull_celCliente = 1 AND [celCliente] IS NULL) OR ([celCliente] = @Original_celCliente)) AND ((@IsNull_ruaCliente = 1 AND [ruaCliente] IS NULL) OR ([ruaCliente] = @Original_ruaCliente)) AND ((@IsNull_numeroCliente = 1 AND [numeroCliente] IS NULL) OR ([numeroCliente] = @Original_numeroCliente)) AND ((@IsNull_cidadeCliente = 1 AND [cidadeCliente] IS NULL) OR ([cidadeCliente] = @Original_cidadeCliente)) AND ((@IsNull_statusCliente = 1 AND [statusCliente] IS NULL) OR ([statusCliente] = @Original_statusCliente)))</CommandText>
<Parameters>
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_idCliente" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="idCliente" SourceColumnNullMapping="false" SourceVersion="Original" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_nomeCliente" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="nomeCliente" SourceColumnNullMapping="true" SourceVersion="Original" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_nomeCliente" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="nomeCliente" SourceColumnNullMapping="false" SourceVersion="Original" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_rgCliente" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="rgCliente" SourceColumnNullMapping="true" SourceVersion="Original" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_rgCliente" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="rgCliente" SourceColumnNullMapping="false" SourceVersion="Original" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_cpfCliente" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="cpfCliente" SourceColumnNullMapping="true" SourceVersion="Original" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_cpfCliente" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="cpfCliente" SourceColumnNullMapping="false" SourceVersion="Original" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_telCliente" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="telCliente" SourceColumnNullMapping="true" SourceVersion="Original" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_telCliente" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="telCliente" SourceColumnNullMapping="false" SourceVersion="Original" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_celCliente" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="celCliente" SourceColumnNullMapping="true" SourceVersion="Original" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_celCliente" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="celCliente" SourceColumnNullMapping="false" SourceVersion="Original" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_ruaCliente" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ruaCliente" SourceColumnNullMapping="true" SourceVersion="Original" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_ruaCliente" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="ruaCliente" SourceColumnNullMapping="false" SourceVersion="Original" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_numeroCliente" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="numeroCliente" SourceColumnNullMapping="true" SourceVersion="Original" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_numeroCliente" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="numeroCliente" SourceColumnNullMapping="false" SourceVersion="Original" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_cidadeCliente" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="cidadeCliente" SourceColumnNullMapping="true" SourceVersion="Original" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_cidadeCliente" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="cidadeCliente" SourceColumnNullMapping="false" SourceVersion="Original" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_statusCliente" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="statusCliente" SourceColumnNullMapping="true" SourceVersion="Original" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_statusCliente" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="statusCliente" SourceColumnNullMapping="false" SourceVersion="Original" />
</Parameters>
</DbCommand>
</DeleteCommand>
<InsertCommand>
<DbCommand CommandType="Text" ModifiedByUser="false">
<CommandText>INSERT INTO [dbo].[tbCliente] ([idCliente], [nomeCliente], [rgCliente], [cpfCliente], [telCliente], [celCliente], [ruaCliente], [numeroCliente], [cidadeCliente], [statusCliente]) VALUES (@idCliente, @nomeCliente, @rgCliente, @cpfCliente, @telCliente, @celCliente, @ruaCliente, @numeroCliente, @cidadeCliente, @statusCliente);
SELECT idCliente, nomeCliente, rgCliente, cpfCliente, telCliente, celCliente, ruaCliente, numeroCliente, cidadeCliente, statusCliente FROM tbCliente WHERE (idCliente = @idCliente)</CommandText>
<Parameters>
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@idCliente" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="idCliente" SourceColumnNullMapping="false" SourceVersion="Current" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@nomeCliente" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="nomeCliente" SourceColumnNullMapping="false" SourceVersion="Current" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@rgCliente" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="rgCliente" SourceColumnNullMapping="false" SourceVersion="Current" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@cpfCliente" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="cpfCliente" SourceColumnNullMapping="false" SourceVersion="Current" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@telCliente" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="telCliente" SourceColumnNullMapping="false" SourceVersion="Current" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@celCliente" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="celCliente" SourceColumnNullMapping="false" SourceVersion="Current" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@ruaCliente" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="ruaCliente" SourceColumnNullMapping="false" SourceVersion="Current" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@numeroCliente" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="numeroCliente" SourceColumnNullMapping="false" SourceVersion="Current" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@cidadeCliente" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="cidadeCliente" SourceColumnNullMapping="false" SourceVersion="Current" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@statusCliente" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="statusCliente" SourceColumnNullMapping="false" SourceVersion="Current" />
</Parameters>
</DbCommand>
</InsertCommand>
<SelectCommand>
<DbCommand CommandType="Text" ModifiedByUser="false">
<CommandText>SELECT idCliente, nomeCliente, rgCliente, cpfCliente, telCliente, celCliente, ruaCliente, numeroCliente, cidadeCliente, statusCliente FROM dbo.tbCliente</CommandText>
<Parameters />
</DbCommand>
</SelectCommand>
<UpdateCommand>
<DbCommand CommandType="Text" ModifiedByUser="false">
<CommandText>UPDATE [dbo].[tbCliente] SET [idCliente] = @idCliente, [nomeCliente] = @nomeCliente, [rgCliente] = @rgCliente, [cpfCliente] = @cpfCliente, [telCliente] = @telCliente, [celCliente] = @celCliente, [ruaCliente] = @ruaCliente, [numeroCliente] = @numeroCliente, [cidadeCliente] = @cidadeCliente, [statusCliente] = @statusCliente WHERE (([idCliente] = @Original_idCliente) AND ((@IsNull_nomeCliente = 1 AND [nomeCliente] IS NULL) OR ([nomeCliente] = @Original_nomeCliente)) AND ((@IsNull_rgCliente = 1 AND [rgCliente] IS NULL) OR ([rgCliente] = @Original_rgCliente)) AND ((@IsNull_cpfCliente = 1 AND [cpfCliente] IS NULL) OR ([cpfCliente] = @Original_cpfCliente)) AND ((@IsNull_telCliente = 1 AND [telCliente] IS NULL) OR ([telCliente] = @Original_telCliente)) AND ((@IsNull_celCliente = 1 AND [celCliente] IS NULL) OR ([celCliente] = @Original_celCliente)) AND ((@IsNull_ruaCliente = 1 AND [ruaCliente] IS NULL) OR ([ruaCliente] = @Original_ruaCliente)) AND ((@IsNull_numeroCliente = 1 AND [numeroCliente] IS NULL) OR ([numeroCliente] = @Original_numeroCliente)) AND ((@IsNull_cidadeCliente = 1 AND [cidadeCliente] IS NULL) OR ([cidadeCliente] = @Original_cidadeCliente)) AND ((@IsNull_statusCliente = 1 AND [statusCliente] IS NULL) OR ([statusCliente] = @Original_statusCliente)));
SELECT idCliente, nomeCliente, rgCliente, cpfCliente, telCliente, celCliente, ruaCliente, numeroCliente, cidadeCliente, statusCliente FROM tbCliente WHERE (idCliente = @idCliente)</CommandText>
<Parameters>
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@idCliente" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="idCliente" SourceColumnNullMapping="false" SourceVersion="Current" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@nomeCliente" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="nomeCliente" SourceColumnNullMapping="false" SourceVersion="Current" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@rgCliente" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="rgCliente" SourceColumnNullMapping="false" SourceVersion="Current" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@cpfCliente" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="cpfCliente" SourceColumnNullMapping="false" SourceVersion="Current" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@telCliente" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="telCliente" SourceColumnNullMapping="false" SourceVersion="Current" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@celCliente" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="celCliente" SourceColumnNullMapping="false" SourceVersion="Current" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@ruaCliente" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="ruaCliente" SourceColumnNullMapping="false" SourceVersion="Current" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@numeroCliente" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="numeroCliente" SourceColumnNullMapping="false" SourceVersion="Current" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@cidadeCliente" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="cidadeCliente" SourceColumnNullMapping="false" SourceVersion="Current" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@statusCliente" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="statusCliente" SourceColumnNullMapping="false" SourceVersion="Current" />
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_idCliente" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="idCliente" SourceColumnNullMapping="false" SourceVersion="Original" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_nomeCliente" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="nomeCliente" SourceColumnNullMapping="true" SourceVersion="Original" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_nomeCliente" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="nomeCliente" SourceColumnNullMapping="false" SourceVersion="Original" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_rgCliente" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="rgCliente" SourceColumnNullMapping="true" SourceVersion="Original" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_rgCliente" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="rgCliente" SourceColumnNullMapping="false" SourceVersion="Original" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_cpfCliente" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="cpfCliente" SourceColumnNullMapping="true" SourceVersion="Original" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_cpfCliente" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="cpfCliente" SourceColumnNullMapping="false" SourceVersion="Original" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_telCliente" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="telCliente" SourceColumnNullMapping="true" SourceVersion="Original" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_telCliente" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="telCliente" SourceColumnNullMapping="false" SourceVersion="Original" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_celCliente" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="celCliente" SourceColumnNullMapping="true" SourceVersion="Original" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_celCliente" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="celCliente" SourceColumnNullMapping="false" SourceVersion="Original" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_ruaCliente" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ruaCliente" SourceColumnNullMapping="true" SourceVersion="Original" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_ruaCliente" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="ruaCliente" SourceColumnNullMapping="false" SourceVersion="Original" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_numeroCliente" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="numeroCliente" SourceColumnNullMapping="true" SourceVersion="Original" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_numeroCliente" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="numeroCliente" SourceColumnNullMapping="false" SourceVersion="Original" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_cidadeCliente" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="cidadeCliente" SourceColumnNullMapping="true" SourceVersion="Original" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_cidadeCliente" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="cidadeCliente" SourceColumnNullMapping="false" SourceVersion="Original" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_statusCliente" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="statusCliente" SourceColumnNullMapping="true" SourceVersion="Original" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_statusCliente" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="statusCliente" SourceColumnNullMapping="false" SourceVersion="Original" />
</Parameters>
</DbCommand>
</UpdateCommand>
</DbSource>
</MainSource>
<Mappings>
<Mapping SourceColumn="idCliente" DataSetColumn="idCliente" />
<Mapping SourceColumn="nomeCliente" DataSetColumn="nomeCliente" />
<Mapping SourceColumn="rgCliente" DataSetColumn="rgCliente" />
<Mapping SourceColumn="cpfCliente" DataSetColumn="cpfCliente" />
<Mapping SourceColumn="telCliente" DataSetColumn="telCliente" />
<Mapping SourceColumn="celCliente" DataSetColumn="celCliente" />
<Mapping SourceColumn="ruaCliente" DataSetColumn="ruaCliente" />
<Mapping SourceColumn="numeroCliente" DataSetColumn="numeroCliente" />
<Mapping SourceColumn="cidadeCliente" DataSetColumn="cidadeCliente" />
<Mapping SourceColumn="statusCliente" DataSetColumn="statusCliente" />
</Mappings>
<Sources />
</TableAdapter>
<TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="tbEditoraTableAdapter" GeneratorDataComponentClassName="tbEditoraTableAdapter" Name="tbEditora" UserDataComponentName="tbEditoraTableAdapter">
<MainSource>
<DbSource ConnectionRef="tbTrabalhoConnectionString (Settings)" DbObjectName="tbTrabalho.dbo.tbEditora" 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].[tbEditora] WHERE (([idEditora] = @Original_idEditora) AND ((@IsNull_nomeEditora = 1 AND [nomeEditora] IS NULL) OR ([nomeEditora] = @Original_nomeEditora)))</CommandText>
<Parameters>
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_idEditora" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="idEditora" SourceColumnNullMapping="false" SourceVersion="Original" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_nomeEditora" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="nomeEditora" SourceColumnNullMapping="true" SourceVersion="Original" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_nomeEditora" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="nomeEditora" SourceColumnNullMapping="false" SourceVersion="Original" />
</Parameters>
</DbCommand>
</DeleteCommand>
<InsertCommand>
<DbCommand CommandType="Text" ModifiedByUser="false">
<CommandText>INSERT INTO [dbo].[tbEditora] ([idEditora], [nomeEditora]) VALUES (@idEditora, @nomeEditora);
SELECT idEditora, nomeEditora FROM tbEditora WHERE (idEditora = @idEditora)</CommandText>
<Parameters>
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@idEditora" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="idEditora" SourceColumnNullMapping="false" SourceVersion="Current" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@nomeEditora" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="nomeEditora" SourceColumnNullMapping="false" SourceVersion="Current" />
</Parameters>
</DbCommand>
</InsertCommand>
<SelectCommand>
<DbCommand CommandType="Text" ModifiedByUser="false">
<CommandText>SELECT idEditora, nomeEditora FROM dbo.tbEditora</CommandText>
<Parameters />
</DbCommand>
</SelectCommand>
<UpdateCommand>
<DbCommand CommandType="Text" ModifiedByUser="false">
<CommandText>UPDATE [dbo].[tbEditora] SET [idEditora] = @idEditora, [nomeEditora] = @nomeEditora WHERE (([idEditora] = @Original_idEditora) AND ((@IsNull_nomeEditora = 1 AND [nomeEditora] IS NULL) OR ([nomeEditora] = @Original_nomeEditora)));
SELECT idEditora, nomeEditora FROM tbEditora WHERE (idEditora = @idEditora)</CommandText>
<Parameters>
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@idEditora" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="idEditora" SourceColumnNullMapping="false" SourceVersion="Current" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@nomeEditora" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="nomeEditora" SourceColumnNullMapping="false" SourceVersion="Current" />
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_idEditora" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="idEditora" SourceColumnNullMapping="false" SourceVersion="Original" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_nomeEditora" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="nomeEditora" SourceColumnNullMapping="true" SourceVersion="Original" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_nomeEditora" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="nomeEditora" SourceColumnNullMapping="false" SourceVersion="Original" />
</Parameters>
</DbCommand>
</UpdateCommand>
</DbSource>
</MainSource>
<Mappings>
<Mapping SourceColumn="idEditora" DataSetColumn="idEditora" />
<Mapping SourceColumn="nomeEditora" DataSetColumn="nomeEditora" />
</Mappings>
<Sources />
</TableAdapter>
<TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="tbEmprestimoTableAdapter" GeneratorDataComponentClassName="tbEmprestimoTableAdapter" Name="tbEmprestimo" UserDataComponentName="tbEmprestimoTableAdapter">
<MainSource>
<DbSource ConnectionRef="tbTrabalhoConnectionString (Settings)" DbObjectName="tbTrabalho.dbo.tbEmprestimo" 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].[tbEmprestimo] WHERE (([idEmprestimo] = @Original_idEmprestimo) AND ((@IsNull_idFunc = 1 AND [idFunc] IS NULL) OR ([idFunc] = @Original_idFunc)) AND ((@IsNull_idCliente = 1 AND [idCliente] IS NULL) OR ([idCliente] = @Original_idCliente)) AND ((@IsNull_idItem = 1 AND [idItem] IS NULL) OR ([idItem] = @Original_idItem)) AND ((@IsNull_dataEmprestimo = 1 AND [dataEmprestimo] IS NULL) OR ([dataEmprestimo] = @Original_dataEmprestimo)) AND ((@IsNull_dataDevolucao = 1 AND [dataDevolucao] IS NULL) OR ([dataDevolucao] = @Original_dataDevolucao)) AND ((@IsNull_statusEmprestimo = 1 AND [statusEmprestimo] IS NULL) OR ([statusEmprestimo] = @Original_statusEmprestimo)))</CommandText>
<Parameters>
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_idEmprestimo" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="idEmprestimo" SourceColumnNullMapping="false" SourceVersion="Original" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_idFunc" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="idFunc" SourceColumnNullMapping="true" SourceVersion="Original" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_idFunc" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="idFunc" SourceColumnNullMapping="false" SourceVersion="Original" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_idCliente" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="idCliente" SourceColumnNullMapping="true" SourceVersion="Original" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_idCliente" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="idCliente" SourceColumnNullMapping="false" SourceVersion="Original" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_idItem" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="idItem" SourceColumnNullMapping="true" SourceVersion="Original" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_idItem" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="idItem" SourceColumnNullMapping="false" SourceVersion="Original" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_dataEmprestimo" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="dataEmprestimo" SourceColumnNullMapping="true" SourceVersion="Original" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_dataEmprestimo" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="dataEmprestimo" SourceColumnNullMapping="false" SourceVersion="Original" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_dataDevolucao" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="dataDevolucao" SourceColumnNullMapping="true" SourceVersion="Original" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_dataDevolucao" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="dataDevolucao" SourceColumnNullMapping="false" SourceVersion="Original" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_statusEmprestimo" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="statusEmprestimo" SourceColumnNullMapping="true" SourceVersion="Original" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_statusEmprestimo" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="statusEmprestimo" SourceColumnNullMapping="false" SourceVersion="Original" />
</Parameters>
</DbCommand>
</DeleteCommand>
<InsertCommand>
<DbCommand CommandType="Text" ModifiedByUser="false">
<CommandText>INSERT INTO [dbo].[tbEmprestimo] ([idEmprestimo], [idFunc], [idCliente], [idItem], [dataEmprestimo], [dataDevolucao], [statusEmprestimo]) VALUES (@idEmprestimo, @idFunc, @idCliente, @idItem, @dataEmprestimo, @dataDevolucao, @statusEmprestimo);
SELECT idEmprestimo, idFunc, idCliente, idItem, dataEmprestimo, dataDevolucao, statusEmprestimo FROM tbEmprestimo WHERE (idEmprestimo = @idEmprestimo)</CommandText>
<Parameters>
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@idEmprestimo" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="idEmprestimo" SourceColumnNullMapping="false" SourceVersion="Current" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@idFunc" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="idFunc" SourceColumnNullMapping="false" SourceVersion="Current" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@idCliente" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="idCliente" SourceColumnNullMapping="false" SourceVersion="Current" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@idItem" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="idItem" SourceColumnNullMapping="false" SourceVersion="Current" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@dataEmprestimo" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="dataEmprestimo" SourceColumnNullMapping="false" SourceVersion="Current" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@dataDevolucao" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="dataDevolucao" SourceColumnNullMapping="false" SourceVersion="Current" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@statusEmprestimo" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="statusEmprestimo" SourceColumnNullMapping="false" SourceVersion="Current" />
</Parameters>
</DbCommand>
</InsertCommand>
<SelectCommand>
<DbCommand CommandType="Text" ModifiedByUser="false">
<CommandText>SELECT idEmprestimo, idFunc, idCliente, idItem, dataEmprestimo, dataDevolucao, statusEmprestimo FROM dbo.tbEmprestimo</CommandText>
<Parameters />
</DbCommand>
</SelectCommand>
<UpdateCommand>
<DbCommand CommandType="Text" ModifiedByUser="false">
<CommandText>UPDATE [dbo].[tbEmprestimo] SET [idEmprestimo] = @idEmprestimo, [idFunc] = @idFunc, [idCliente] = @idCliente, [idItem] = @idItem, [dataEmprestimo] = @dataEmprestimo, [dataDevolucao] = @dataDevolucao, [statusEmprestimo] = @statusEmprestimo WHERE (([idEmprestimo] = @Original_idEmprestimo) AND ((@IsNull_idFunc = 1 AND [idFunc] IS NULL) OR ([idFunc] = @Original_idFunc)) AND ((@IsNull_idCliente = 1 AND [idCliente] IS NULL) OR ([idCliente] = @Original_idCliente)) AND ((@IsNull_idItem = 1 AND [idItem] IS NULL) OR ([idItem] = @Original_idItem)) AND ((@IsNull_dataEmprestimo = 1 AND [dataEmprestimo] IS NULL) OR ([dataEmprestimo] = @Original_dataEmprestimo)) AND ((@IsNull_dataDevolucao = 1 AND [dataDevolucao] IS NULL) OR ([dataDevolucao] = @Original_dataDevolucao)) AND ((@IsNull_statusEmprestimo = 1 AND [statusEmprestimo] IS NULL) OR ([statusEmprestimo] = @Original_statusEmprestimo)));
SELECT idEmprestimo, idFunc, idCliente, idItem, dataEmprestimo, dataDevolucao, statusEmprestimo FROM tbEmprestimo WHERE (idEmprestimo = @idEmprestimo)</CommandText>
<Parameters>
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@idEmprestimo" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="idEmprestimo" SourceColumnNullMapping="false" SourceVersion="Current" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@idFunc" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="idFunc" SourceColumnNullMapping="false" SourceVersion="Current" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@idCliente" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="idCliente" SourceColumnNullMapping="false" SourceVersion="Current" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@idItem" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="idItem" SourceColumnNullMapping="false" SourceVersion="Current" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@dataEmprestimo" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="dataEmprestimo" SourceColumnNullMapping="false" SourceVersion="Current" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@dataDevolucao" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="dataDevolucao" SourceColumnNullMapping="false" SourceVersion="Current" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@statusEmprestimo" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="statusEmprestimo" SourceColumnNullMapping="false" SourceVersion="Current" />
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_idEmprestimo" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="idEmprestimo" SourceColumnNullMapping="false" SourceVersion="Original" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_idFunc" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="idFunc" SourceColumnNullMapping="true" SourceVersion="Original" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_idFunc" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="idFunc" SourceColumnNullMapping="false" SourceVersion="Original" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_idCliente" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="idCliente" SourceColumnNullMapping="true" SourceVersion="Original" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_idCliente" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="idCliente" SourceColumnNullMapping="false" SourceVersion="Original" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_idItem" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="idItem" SourceColumnNullMapping="true" SourceVersion="Original" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_idItem" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="idItem" SourceColumnNullMapping="false" SourceVersion="Original" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_dataEmprestimo" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="dataEmprestimo" SourceColumnNullMapping="true" SourceVersion="Original" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_dataEmprestimo" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="dataEmprestimo" SourceColumnNullMapping="false" SourceVersion="Original" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_dataDevolucao" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="dataDevolucao" SourceColumnNullMapping="true" SourceVersion="Original" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_dataDevolucao" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="dataDevolucao" SourceColumnNullMapping="false" SourceVersion="Original" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_statusEmprestimo" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="statusEmprestimo" SourceColumnNullMapping="true" SourceVersion="Original" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_statusEmprestimo" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="statusEmprestimo" SourceColumnNullMapping="false" SourceVersion="Original" />
</Parameters>
</DbCommand>
</UpdateCommand>
</DbSource>
</MainSource>
<Mappings>
<Mapping SourceColumn="idEmprestimo" DataSetColumn="idEmprestimo" />
<Mapping SourceColumn="idFunc" DataSetColumn="idFunc" />
<Mapping SourceColumn="idCliente" DataSetColumn="idCliente" />
<Mapping SourceColumn="idItem" DataSetColumn="idItem" />
<Mapping SourceColumn="dataEmprestimo" DataSetColumn="dataEmprestimo" />
<Mapping SourceColumn="dataDevolucao" DataSetColumn="dataDevolucao" />
<Mapping SourceColumn="statusEmprestimo" DataSetColumn="statusEmprestimo" />
</Mappings>
<Sources />
</TableAdapter>
<TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="tbFuncionarioTableAdapter" GeneratorDataComponentClassName="tbFuncionarioTableAdapter" Name="tbFuncionario" UserDataComponentName="tbFuncionarioTableAdapter">
<MainSource>
<DbSource ConnectionRef="tbTrabalhoConnectionString (Settings)" DbObjectName="tbTrabalho.dbo.tbFuncionario" 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].[tbFuncionario] WHERE (([idFunc] = @Original_idFunc) AND ((@IsNull_nomeFunc = 1 AND [nomeFunc] IS NULL) OR ([nomeFunc] = @Original_nomeFunc)) AND ((@IsNull_rgFunc = 1 AND [rgFunc] IS NULL) OR ([rgFunc] = @Original_rgFunc)) AND ((@IsNull_cpfFunc = 1 AND [cpfFunc] IS NULL) OR ([cpfFunc] = @Original_cpfFunc)) AND ((@IsNull_telFunc = 1 AND [telFunc] IS NULL) OR ([telFunc] = @Original_telFunc)) AND ((@IsNull_celFunc = 1 AND [celFunc] IS NULL) OR ([celFunc] = @Original_celFunc)) AND ((@IsNull_ruaFunc = 1 AND [ruaFunc] IS NULL) OR ([ruaFunc] = @Original_ruaFunc)) AND ((@IsNull_numeroFunc = 1 AND [numeroFunc] IS NULL) OR ([numeroFunc] = @Original_numeroFunc)) AND ((@IsNull_cidadeFunc = 1 AND [cidadeFunc] IS NULL) OR ([cidadeFunc] = @Original_cidadeFunc)) AND ((@IsNull_statusFunc = 1 AND [statusFunc] IS NULL) OR ([statusFunc] = @Original_statusFunc)) AND ((@IsNull_usuarioFunc = 1 AND [usuarioFunc] IS NULL) OR ([usuarioFunc] = @Original_usuarioFunc)) AND ((@IsNull_senhaFunc = 1 AND [senhaFunc] IS NULL) OR ([senhaFunc] = @Original_senhaFunc)))</CommandText>
<Parameters>
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_idFunc" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="idFunc" SourceColumnNullMapping="false" SourceVersion="Original" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_nomeFunc" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="nomeFunc" SourceColumnNullMapping="true" SourceVersion="Original" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_nomeFunc" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="nomeFunc" SourceColumnNullMapping="false" SourceVersion="Original" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_rgFunc" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="rgFunc" SourceColumnNullMapping="true" SourceVersion="Original" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_rgFunc" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="rgFunc" SourceColumnNullMapping="false" SourceVersion="Original" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_cpfFunc" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="cpfFunc" SourceColumnNullMapping="true" SourceVersion="Original" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_cpfFunc" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="cpfFunc" SourceColumnNullMapping="false" SourceVersion="Original" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_telFunc" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="telFunc" SourceColumnNullMapping="true" SourceVersion="Original" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_telFunc" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="telFunc" SourceColumnNullMapping="false" SourceVersion="Original" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_celFunc" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="celFunc" SourceColumnNullMapping="true" SourceVersion="Original" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_celFunc" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="celFunc" SourceColumnNullMapping="false" SourceVersion="Original" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_ruaFunc" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ruaFunc" SourceColumnNullMapping="true" SourceVersion="Original" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_ruaFunc" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="ruaFunc" SourceColumnNullMapping="false" SourceVersion="Original" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_numeroFunc" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="numeroFunc" SourceColumnNullMapping="true" SourceVersion="Original" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_numeroFunc" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="numeroFunc" SourceColumnNullMapping="false" SourceVersion="Original" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_cidadeFunc" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="cidadeFunc" SourceColumnNullMapping="true" SourceVersion="Original" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_cidadeFunc" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="cidadeFunc" SourceColumnNullMapping="false" SourceVersion="Original" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_statusFunc" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="statusFunc" SourceColumnNullMapping="true" SourceVersion="Original" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_statusFunc" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="statusFunc" SourceColumnNullMapping="false" SourceVersion="Original" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_usuarioFunc" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="usuarioFunc" SourceColumnNullMapping="true" SourceVersion="Original" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_usuarioFunc" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="usuarioFunc" SourceColumnNullMapping="false" SourceVersion="Original" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_senhaFunc" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="senhaFunc" SourceColumnNullMapping="true" SourceVersion="Original" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_senhaFunc" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="senhaFunc" SourceColumnNullMapping="false" SourceVersion="Original" />
</Parameters>
</DbCommand>
</DeleteCommand>
<InsertCommand>
<DbCommand CommandType="Text" ModifiedByUser="false">
<CommandText>INSERT INTO [dbo].[tbFuncionario] ([idFunc], [nomeFunc], [rgFunc], [cpfFunc], [telFunc], [celFunc], [ruaFunc], [numeroFunc], [cidadeFunc], [statusFunc], [usuarioFunc], [senhaFunc]) VALUES (@idFunc, @nomeFunc, @rgFunc, @cpfFunc, @telFunc, @celFunc, @ruaFunc, @numeroFunc, @cidadeFunc, @statusFunc, @usuarioFunc, @senhaFunc);
SELECT idFunc, nomeFunc, rgFunc, cpfFunc, telFunc, celFunc, ruaFunc, numeroFunc, cidadeFunc, statusFunc, usuarioFunc, senhaFunc FROM tbFuncionario WHERE (idFunc = @idFunc)</CommandText>
<Parameters>
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@idFunc" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="idFunc" SourceColumnNullMapping="false" SourceVersion="Current" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@nomeFunc" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="nomeFunc" SourceColumnNullMapping="false" SourceVersion="Current" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@rgFunc" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="rgFunc" SourceColumnNullMapping="false" SourceVersion="Current" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@cpfFunc" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="cpfFunc" SourceColumnNullMapping="false" SourceVersion="Current" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@telFunc" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="telFunc" SourceColumnNullMapping="false" SourceVersion="Current" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@celFunc" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="celFunc" SourceColumnNullMapping="false" SourceVersion="Current" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@ruaFunc" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="ruaFunc" SourceColumnNullMapping="false" SourceVersion="Current" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@numeroFunc" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="numeroFunc" SourceColumnNullMapping="false" SourceVersion="Current" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@cidadeFunc" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="cidadeFunc" SourceColumnNullMapping="false" SourceVersion="Current" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@statusFunc" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="statusFunc" SourceColumnNullMapping="false" SourceVersion="Current" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@usuarioFunc" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="usuarioFunc" SourceColumnNullMapping="false" SourceVersion="Current" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@senhaFunc" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="senhaFunc" SourceColumnNullMapping="false" SourceVersion="Current" />
</Parameters>
</DbCommand>
</InsertCommand>
<SelectCommand>
<DbCommand CommandType="Text" ModifiedByUser="false">
<CommandText>SELECT idFunc, nomeFunc, rgFunc, cpfFunc, telFunc, celFunc, ruaFunc, numeroFunc, cidadeFunc, statusFunc, usuarioFunc, senhaFunc FROM dbo.tbFuncionario</CommandText>
<Parameters />
</DbCommand>
</SelectCommand>
<UpdateCommand>
<DbCommand CommandType="Text" ModifiedByUser="false">
<CommandText>UPDATE [dbo].[tbFuncionario] SET [idFunc] = @idFunc, [nomeFunc] = @nomeFunc, [rgFunc] = @rgFunc, [cpfFunc] = @cpfFunc, [telFunc] = @telFunc, [celFunc] = @celFunc, [ruaFunc] = @ruaFunc, [numeroFunc] = @numeroFunc, [cidadeFunc] = @cidadeFunc, [statusFunc] = @statusFunc, [usuarioFunc] = @usuarioFunc, [senhaFunc] = @senhaFunc WHERE (([idFunc] = @Original_idFunc) AND ((@IsNull_nomeFunc = 1 AND [nomeFunc] IS NULL) OR ([nomeFunc] = @Original_nomeFunc)) AND ((@IsNull_rgFunc = 1 AND [rgFunc] IS NULL) OR ([rgFunc] = @Original_rgFunc)) AND ((@IsNull_cpfFunc = 1 AND [cpfFunc] IS NULL) OR ([cpfFunc] = @Original_cpfFunc)) AND ((@IsNull_telFunc = 1 AND [telFunc] IS NULL) OR ([telFunc] = @Original_telFunc)) AND ((@IsNull_celFunc = 1 AND [celFunc] IS NULL) OR ([celFunc] = @Original_celFunc)) AND ((@IsNull_ruaFunc = 1 AND [ruaFunc] IS NULL) OR ([ruaFunc] = @Original_ruaFunc)) AND ((@IsNull_numeroFunc = 1 AND [numeroFunc] IS NULL) OR ([numeroFunc] = @Original_numeroFunc)) AND ((@IsNull_cidadeFunc = 1 AND [cidadeFunc] IS NULL) OR ([cidadeFunc] = @Original_cidadeFunc)) AND ((@IsNull_statusFunc = 1 AND [statusFunc] IS NULL) OR ([statusFunc] = @Original_statusFunc)) AND ((@IsNull_usuarioFunc = 1 AND [usuarioFunc] IS NULL) OR ([usuarioFunc] = @Original_usuarioFunc)) AND ((@IsNull_senhaFunc = 1 AND [senhaFunc] IS NULL) OR ([senhaFunc] = @Original_senhaFunc)));
SELECT idFunc, nomeFunc, rgFunc, cpfFunc, telFunc, celFunc, ruaFunc, numeroFunc, cidadeFunc, statusFunc, usuarioFunc, senhaFunc FROM tbFuncionario WHERE (idFunc = @idFunc)</CommandText>
<Parameters>
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@idFunc" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="idFunc" SourceColumnNullMapping="false" SourceVersion="Current" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@nomeFunc" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="nomeFunc" SourceColumnNullMapping="false" SourceVersion="Current" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@rgFunc" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="rgFunc" SourceColumnNullMapping="false" SourceVersion="Current" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@cpfFunc" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="cpfFunc" SourceColumnNullMapping="false" SourceVersion="Current" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@telFunc" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="telFunc" SourceColumnNullMapping="false" SourceVersion="Current" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@celFunc" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="celFunc" SourceColumnNullMapping="false" SourceVersion="Current" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@ruaFunc" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="ruaFunc" SourceColumnNullMapping="false" SourceVersion="Current" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@numeroFunc" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="numeroFunc" SourceColumnNullMapping="false" SourceVersion="Current" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@cidadeFunc" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="cidadeFunc" SourceColumnNullMapping="false" SourceVersion="Current" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@statusFunc" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="statusFunc" SourceColumnNullMapping="false" SourceVersion="Current" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@usuarioFunc" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="usuarioFunc" SourceColumnNullMapping="false" SourceVersion="Current" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@senhaFunc" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="senhaFunc" SourceColumnNullMapping="false" SourceVersion="Current" />
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_idFunc" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="idFunc" SourceColumnNullMapping="false" SourceVersion="Original" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_nomeFunc" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="nomeFunc" SourceColumnNullMapping="true" SourceVersion="Original" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_nomeFunc" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="nomeFunc" SourceColumnNullMapping="false" SourceVersion="Original" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_rgFunc" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="rgFunc" SourceColumnNullMapping="true" SourceVersion="Original" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_rgFunc" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="rgFunc" SourceColumnNullMapping="false" SourceVersion="Original" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_cpfFunc" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="cpfFunc" SourceColumnNullMapping="true" SourceVersion="Original" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_cpfFunc" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="cpfFunc" SourceColumnNullMapping="false" SourceVersion="Original" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_telFunc" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="telFunc" SourceColumnNullMapping="true" SourceVersion="Original" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_telFunc" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="telFunc" SourceColumnNullMapping="false" SourceVersion="Original" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_celFunc" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="celFunc" SourceColumnNullMapping="true" SourceVersion="Original" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_celFunc" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="celFunc" SourceColumnNullMapping="false" SourceVersion="Original" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_ruaFunc" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="ruaFunc" SourceColumnNullMapping="true" SourceVersion="Original" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_ruaFunc" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="ruaFunc" SourceColumnNullMapping="false" SourceVersion="Original" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_numeroFunc" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="numeroFunc" SourceColumnNullMapping="true" SourceVersion="Original" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_numeroFunc" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="numeroFunc" SourceColumnNullMapping="false" SourceVersion="Original" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_cidadeFunc" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="cidadeFunc" SourceColumnNullMapping="true" SourceVersion="Original" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_cidadeFunc" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="cidadeFunc" SourceColumnNullMapping="false" SourceVersion="Original" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_statusFunc" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="statusFunc" SourceColumnNullMapping="true" SourceVersion="Original" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_statusFunc" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="statusFunc" SourceColumnNullMapping="false" SourceVersion="Original" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_usuarioFunc" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="usuarioFunc" SourceColumnNullMapping="true" SourceVersion="Original" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_usuarioFunc" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="usuarioFunc" SourceColumnNullMapping="false" SourceVersion="Original" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_senhaFunc" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="senhaFunc" SourceColumnNullMapping="true" SourceVersion="Original" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_senhaFunc" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="senhaFunc" SourceColumnNullMapping="false" SourceVersion="Original" />
</Parameters>
</DbCommand>
</UpdateCommand>
</DbSource>
</MainSource>
<Mappings>
<Mapping SourceColumn="idFunc" DataSetColumn="idFunc" />
<Mapping SourceColumn="nomeFunc" DataSetColumn="nomeFunc" />
<Mapping SourceColumn="rgFunc" DataSetColumn="rgFunc" />
<Mapping SourceColumn="cpfFunc" DataSetColumn="cpfFunc" />
<Mapping SourceColumn="telFunc" DataSetColumn="telFunc" />
<Mapping SourceColumn="celFunc" DataSetColumn="celFunc" />
<Mapping SourceColumn="ruaFunc" DataSetColumn="ruaFunc" />
<Mapping SourceColumn="numeroFunc" DataSetColumn="numeroFunc" />
<Mapping SourceColumn="cidadeFunc" DataSetColumn="cidadeFunc" />
<Mapping SourceColumn="statusFunc" DataSetColumn="statusFunc" />
<Mapping SourceColumn="usuarioFunc" DataSetColumn="usuarioFunc" />
<Mapping SourceColumn="senhaFunc" DataSetColumn="senhaFunc" />
</Mappings>
<Sources />
</TableAdapter>
<TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="tbGeneroTableAdapter" GeneratorDataComponentClassName="tbGeneroTableAdapter" Name="tbGenero" UserDataComponentName="tbGeneroTableAdapter">
<MainSource>
<DbSource ConnectionRef="tbTrabalhoConnectionString (Settings)" DbObjectName="tbTrabalho.dbo.tbGenero" 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].[tbGenero] WHERE (([idGenero] = @Original_idGenero) AND ((@IsNull_nomeGenero = 1 AND [nomeGenero] IS NULL) OR ([nomeGenero] = @Original_nomeGenero)))</CommandText>
<Parameters>
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_idGenero" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="idGenero" SourceColumnNullMapping="false" SourceVersion="Original" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_nomeGenero" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="nomeGenero" SourceColumnNullMapping="true" SourceVersion="Original" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_nomeGenero" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="nomeGenero" SourceColumnNullMapping="false" SourceVersion="Original" />
</Parameters>
</DbCommand>
</DeleteCommand>
<InsertCommand>
<DbCommand CommandType="Text" ModifiedByUser="false">
<CommandText>INSERT INTO [dbo].[tbGenero] ([idGenero], [nomeGenero]) VALUES (@idGenero, @nomeGenero);
SELECT idGenero, nomeGenero FROM tbGenero WHERE (idGenero = @idGenero)</CommandText>
<Parameters>
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@idGenero" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="idGenero" SourceColumnNullMapping="false" SourceVersion="Current" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@nomeGenero" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="nomeGenero" SourceColumnNullMapping="false" SourceVersion="Current" />
</Parameters>
</DbCommand>
</InsertCommand>
<SelectCommand>
<DbCommand CommandType="Text" ModifiedByUser="false">
<CommandText>SELECT idGenero, nomeGenero FROM dbo.tbGenero</CommandText>
<Parameters />
</DbCommand>
</SelectCommand>
<UpdateCommand>
<DbCommand CommandType="Text" ModifiedByUser="false">
<CommandText>UPDATE [dbo].[tbGenero] SET [idGenero] = @idGenero, [nomeGenero] = @nomeGenero WHERE (([idGenero] = @Original_idGenero) AND ((@IsNull_nomeGenero = 1 AND [nomeGenero] IS NULL) OR ([nomeGenero] = @Original_nomeGenero)));
SELECT idGenero, nomeGenero FROM tbGenero WHERE (idGenero = @idGenero)</CommandText>
<Parameters>
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@idGenero" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="idGenero" SourceColumnNullMapping="false" SourceVersion="Current" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@nomeGenero" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="nomeGenero" SourceColumnNullMapping="false" SourceVersion="Current" />
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_idGenero" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="idGenero" SourceColumnNullMapping="false" SourceVersion="Original" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_nomeGenero" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="nomeGenero" SourceColumnNullMapping="true" SourceVersion="Original" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_nomeGenero" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="nomeGenero" SourceColumnNullMapping="false" SourceVersion="Original" />
</Parameters>
</DbCommand>
</UpdateCommand>
</DbSource>
</MainSource>
<Mappings>
<Mapping SourceColumn="idGenero" DataSetColumn="idGenero" />
<Mapping SourceColumn="nomeGenero" DataSetColumn="nomeGenero" />
</Mappings>
<Sources />
</TableAdapter>
<TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="tbItemTableAdapter" GeneratorDataComponentClassName="tbItemTableAdapter" Name="tbItem" UserDataComponentName="tbItemTableAdapter">
<MainSource>
<DbSource ConnectionRef="tbTrabalhoConnectionString (Settings)" DbObjectName="tbTrabalho.dbo.tbItem" 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].[tbItem] WHERE (([idItem] = @Original_idItem) AND ((@IsNull_nomeItem = 1 AND [nomeItem] IS NULL) OR ([nomeItem] = @Original_nomeItem)) AND ((@IsNull_idAutor = 1 AND [idAutor] IS NULL) OR ([idAutor] = @Original_idAutor)) AND ((@IsNull_generoItem = 1 AND [generoItem] IS NULL) OR ([generoItem] = @Original_generoItem)) AND ((@IsNull_editoraItem = 1 AND [editoraItem] IS NULL) OR ([editoraItem] = @Original_editoraItem)) AND ((@IsNull_tipoItem = 1 AND [tipoItem] IS NULL) OR ([tipoItem] = @Original_tipoItem)) AND ((@IsNull_isbnItem = 1 AND [isbnItem] IS NULL) OR ([isbnItem] = @Original_isbnItem)) AND ((@IsNull_statusItem = 1 AND [statusItem] IS NULL) OR ([statusItem] = @Original_statusItem)))</CommandText>
<Parameters>
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_idItem" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="idItem" SourceColumnNullMapping="false" SourceVersion="Original" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_nomeItem" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="nomeItem" SourceColumnNullMapping="true" SourceVersion="Original" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_nomeItem" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="nomeItem" SourceColumnNullMapping="false" SourceVersion="Original" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_idAutor" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="idAutor" SourceColumnNullMapping="true" SourceVersion="Original" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_idAutor" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="idAutor" SourceColumnNullMapping="false" SourceVersion="Original" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_generoItem" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="generoItem" SourceColumnNullMapping="true" SourceVersion="Original" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_generoItem" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="generoItem" SourceColumnNullMapping="false" SourceVersion="Original" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_editoraItem" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="editoraItem" SourceColumnNullMapping="true" SourceVersion="Original" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_editoraItem" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="editoraItem" SourceColumnNullMapping="false" SourceVersion="Original" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_tipoItem" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="tipoItem" SourceColumnNullMapping="true" SourceVersion="Original" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_tipoItem" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="tipoItem" SourceColumnNullMapping="false" SourceVersion="Original" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_isbnItem" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="isbnItem" SourceColumnNullMapping="true" SourceVersion="Original" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_isbnItem" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="isbnItem" SourceColumnNullMapping="false" SourceVersion="Original" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_statusItem" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="statusItem" SourceColumnNullMapping="true" SourceVersion="Original" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_statusItem" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="statusItem" SourceColumnNullMapping="false" SourceVersion="Original" />
</Parameters>
</DbCommand>
</DeleteCommand>
<InsertCommand>
<DbCommand CommandType="Text" ModifiedByUser="false">
<CommandText>INSERT INTO [dbo].[tbItem] ([idItem], [nomeItem], [idAutor], [generoItem], [editoraItem], [tipoItem], [isbnItem], [statusItem]) VALUES (@idItem, @nomeItem, @idAutor, @generoItem, @editoraItem, @tipoItem, @isbnItem, @statusItem);
SELECT idItem, nomeItem, idAutor, generoItem, editoraItem, tipoItem, isbnItem, statusItem FROM tbItem WHERE (idItem = @idItem)</CommandText>
<Parameters>
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@idItem" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="idItem" SourceColumnNullMapping="false" SourceVersion="Current" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@nomeItem" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="nomeItem" SourceColumnNullMapping="false" SourceVersion="Current" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@idAutor" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="idAutor" SourceColumnNullMapping="false" SourceVersion="Current" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@generoItem" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="generoItem" SourceColumnNullMapping="false" SourceVersion="Current" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@editoraItem" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="editoraItem" SourceColumnNullMapping="false" SourceVersion="Current" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@tipoItem" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="tipoItem" SourceColumnNullMapping="false" SourceVersion="Current" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@isbnItem" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="isbnItem" SourceColumnNullMapping="false" SourceVersion="Current" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@statusItem" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="statusItem" SourceColumnNullMapping="false" SourceVersion="Current" />
</Parameters>
</DbCommand>
</InsertCommand>
<SelectCommand>
<DbCommand CommandType="Text" ModifiedByUser="false">
<CommandText>SELECT idItem, nomeItem, idAutor, generoItem, editoraItem, tipoItem, isbnItem, statusItem FROM dbo.tbItem</CommandText>
<Parameters />
</DbCommand>
</SelectCommand>
<UpdateCommand>
<DbCommand CommandType="Text" ModifiedByUser="false">
<CommandText>UPDATE [dbo].[tbItem] SET [idItem] = @idItem, [nomeItem] = @nomeItem, [idAutor] = @idAutor, [generoItem] = @generoItem, [editoraItem] = @editoraItem, [tipoItem] = @tipoItem, [isbnItem] = @isbnItem, [statusItem] = @statusItem WHERE (([idItem] = @Original_idItem) AND ((@IsNull_nomeItem = 1 AND [nomeItem] IS NULL) OR ([nomeItem] = @Original_nomeItem)) AND ((@IsNull_idAutor = 1 AND [idAutor] IS NULL) OR ([idAutor] = @Original_idAutor)) AND ((@IsNull_generoItem = 1 AND [generoItem] IS NULL) OR ([generoItem] = @Original_generoItem)) AND ((@IsNull_editoraItem = 1 AND [editoraItem] IS NULL) OR ([editoraItem] = @Original_editoraItem)) AND ((@IsNull_tipoItem = 1 AND [tipoItem] IS NULL) OR ([tipoItem] = @Original_tipoItem)) AND ((@IsNull_isbnItem = 1 AND [isbnItem] IS NULL) OR ([isbnItem] = @Original_isbnItem)) AND ((@IsNull_statusItem = 1 AND [statusItem] IS NULL) OR ([statusItem] = @Original_statusItem)));
SELECT idItem, nomeItem, idAutor, generoItem, editoraItem, tipoItem, isbnItem, statusItem FROM tbItem WHERE (idItem = @idItem)</CommandText>
<Parameters>
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@idItem" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="idItem" SourceColumnNullMapping="false" SourceVersion="Current" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@nomeItem" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="nomeItem" SourceColumnNullMapping="false" SourceVersion="Current" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@idAutor" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="idAutor" SourceColumnNullMapping="false" SourceVersion="Current" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@generoItem" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="generoItem" SourceColumnNullMapping="false" SourceVersion="Current" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@editoraItem" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="editoraItem" SourceColumnNullMapping="false" SourceVersion="Current" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@tipoItem" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="tipoItem" SourceColumnNullMapping="false" SourceVersion="Current" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@isbnItem" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="isbnItem" SourceColumnNullMapping="false" SourceVersion="Current" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@statusItem" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="statusItem" SourceColumnNullMapping="false" SourceVersion="Current" />
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_idItem" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="idItem" SourceColumnNullMapping="false" SourceVersion="Original" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_nomeItem" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="nomeItem" SourceColumnNullMapping="true" SourceVersion="Original" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_nomeItem" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="nomeItem" SourceColumnNullMapping="false" SourceVersion="Original" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_idAutor" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="idAutor" SourceColumnNullMapping="true" SourceVersion="Original" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_idAutor" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="idAutor" SourceColumnNullMapping="false" SourceVersion="Original" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_generoItem" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="generoItem" SourceColumnNullMapping="true" SourceVersion="Original" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_generoItem" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="generoItem" SourceColumnNullMapping="false" SourceVersion="Original" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_editoraItem" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="editoraItem" SourceColumnNullMapping="true" SourceVersion="Original" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_editoraItem" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="editoraItem" SourceColumnNullMapping="false" SourceVersion="Original" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_tipoItem" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="tipoItem" SourceColumnNullMapping="true" SourceVersion="Original" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_tipoItem" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="tipoItem" SourceColumnNullMapping="false" SourceVersion="Original" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_isbnItem" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="isbnItem" SourceColumnNullMapping="true" SourceVersion="Original" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_isbnItem" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="isbnItem" SourceColumnNullMapping="false" SourceVersion="Original" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_statusItem" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="statusItem" SourceColumnNullMapping="true" SourceVersion="Original" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_statusItem" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="statusItem" SourceColumnNullMapping="false" SourceVersion="Original" />
</Parameters>
</DbCommand>
</UpdateCommand>
</DbSource>
</MainSource>
<Mappings>
<Mapping SourceColumn="idItem" DataSetColumn="idItem" />
<Mapping SourceColumn="nomeItem" DataSetColumn="nomeItem" />
<Mapping SourceColumn="idAutor" DataSetColumn="idAutor" />
<Mapping SourceColumn="generoItem" DataSetColumn="generoItem" />
<Mapping SourceColumn="editoraItem" DataSetColumn="editoraItem" />
<Mapping SourceColumn="tipoItem" DataSetColumn="tipoItem" />
<Mapping SourceColumn="isbnItem" DataSetColumn="isbnItem" />
<Mapping SourceColumn="statusItem" DataSetColumn="statusItem" />
</Mappings>
<Sources />
</TableAdapter>
<TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="tbTipoTableAdapter" GeneratorDataComponentClassName="tbTipoTableAdapter" Name="tbTipo" UserDataComponentName="tbTipoTableAdapter">
<MainSource>
<DbSource ConnectionRef="tbTrabalhoConnectionString (Settings)" DbObjectName="tbTrabalho.dbo.tbTipo" 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].[tbTipo] WHERE (([idTipo] = @Original_idTipo) AND ((@IsNull_nomeTipo = 1 AND [nomeTipo] IS NULL) OR ([nomeTipo] = @Original_nomeTipo)))</CommandText>
<Parameters>
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_idTipo" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="idTipo" SourceColumnNullMapping="false" SourceVersion="Original" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_nomeTipo" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="nomeTipo" SourceColumnNullMapping="true" SourceVersion="Original" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_nomeTipo" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="nomeTipo" SourceColumnNullMapping="false" SourceVersion="Original" />
</Parameters>
</DbCommand>
</DeleteCommand>
<InsertCommand>
<DbCommand CommandType="Text" ModifiedByUser="false">
<CommandText>INSERT INTO [dbo].[tbTipo] ([idTipo], [nomeTipo]) VALUES (@idTipo, @nomeTipo);
SELECT idTipo, nomeTipo FROM tbTipo WHERE (idTipo = @idTipo)</CommandText>
<Parameters>
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@idTipo" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="idTipo" SourceColumnNullMapping="false" SourceVersion="Current" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@nomeTipo" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="nomeTipo" SourceColumnNullMapping="false" SourceVersion="Current" />
</Parameters>
</DbCommand>
</InsertCommand>
<SelectCommand>
<DbCommand CommandType="Text" ModifiedByUser="false">
<CommandText>SELECT idTipo, nomeTipo FROM dbo.tbTipo</CommandText>
<Parameters />
</DbCommand>
</SelectCommand>
<UpdateCommand>
<DbCommand CommandType="Text" ModifiedByUser="false">
<CommandText>UPDATE [dbo].[tbTipo] SET [idTipo] = @idTipo, [nomeTipo] = @nomeTipo WHERE (([idTipo] = @Original_idTipo) AND ((@IsNull_nomeTipo = 1 AND [nomeTipo] IS NULL) OR ([nomeTipo] = @Original_nomeTipo)));
SELECT idTipo, nomeTipo FROM tbTipo WHERE (idTipo = @idTipo)</CommandText>
<Parameters>
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@idTipo" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="idTipo" SourceColumnNullMapping="false" SourceVersion="Current" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@nomeTipo" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="nomeTipo" SourceColumnNullMapping="false" SourceVersion="Current" />
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_idTipo" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="idTipo" SourceColumnNullMapping="false" SourceVersion="Original" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_nomeTipo" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="nomeTipo" SourceColumnNullMapping="true" SourceVersion="Original" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_nomeTipo" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="nomeTipo" SourceColumnNullMapping="false" SourceVersion="Original" />
</Parameters>
</DbCommand>
</UpdateCommand>
</DbSource>
</MainSource>
<Mappings>
<Mapping SourceColumn="idTipo" DataSetColumn="idTipo" />
<Mapping SourceColumn="nomeTipo" DataSetColumn="nomeTipo" />
</Mappings>
<Sources />
</TableAdapter>
<TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="tbAutorTableAdapter" GeneratorDataComponentClassName="tbAutorTableAdapter" Name="tbAutor" UserDataComponentName="tbAutorTableAdapter">
<MainSource>
<DbSource ConnectionRef="tbTrabalhoConnectionString (Settings)" DbObjectName="tbTrabalho.dbo.tbAutor" 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].[tbAutor] WHERE (([idAutor] = @Original_idAutor) AND ((@IsNull_nomeAutor = 1 AND [nomeAutor] IS NULL) OR ([nomeAutor] = @Original_nomeAutor)))</CommandText>
<Parameters>
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_idAutor" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="idAutor" SourceColumnNullMapping="false" SourceVersion="Original" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_nomeAutor" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="nomeAutor" SourceColumnNullMapping="true" SourceVersion="Original" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_nomeAutor" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="nomeAutor" SourceColumnNullMapping="false" SourceVersion="Original" />
</Parameters>
</DbCommand>
</DeleteCommand>
<InsertCommand>
<DbCommand CommandType="Text" ModifiedByUser="false">
<CommandText>INSERT INTO [dbo].[tbAutor] ([nomeAutor]) VALUES (@nomeAutor);
SELECT idAutor, nomeAutor FROM tbAutor WHERE (idAutor = SCOPE_IDENTITY())</CommandText>
<Parameters>
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@nomeAutor" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="nomeAutor" SourceColumnNullMapping="false" SourceVersion="Current" />
</Parameters>
</DbCommand>
</InsertCommand>
<SelectCommand>
<DbCommand CommandType="Text" ModifiedByUser="false">
<CommandText>SELECT idAutor, nomeAutor FROM dbo.tbAutor</CommandText>
<Parameters />
</DbCommand>
</SelectCommand>
<UpdateCommand>
<DbCommand CommandType="Text" ModifiedByUser="false">
<CommandText>UPDATE [dbo].[tbAutor] SET [nomeAutor] = @nomeAutor WHERE (([idAutor] = @Original_idAutor) AND ((@IsNull_nomeAutor = 1 AND [nomeAutor] IS NULL) OR ([nomeAutor] = @Original_nomeAutor)));
SELECT idAutor, nomeAutor FROM tbAutor WHERE (idAutor = @idAutor)</CommandText>
<Parameters>
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@nomeAutor" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="nomeAutor" SourceColumnNullMapping="false" SourceVersion="Current" />
<Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_idAutor" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="idAutor" SourceColumnNullMapping="false" SourceVersion="Original" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_nomeAutor" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="nomeAutor" SourceColumnNullMapping="true" SourceVersion="Original" />
<Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_nomeAutor" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="nomeAutor" SourceColumnNullMapping="false" SourceVersion="Original" />
<Parameter AllowDbNull="false" AutogeneratedName="idAutor" ColumnName="idAutor" DataSourceName="tbTrabalho.dbo.tbAutor" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@idAutor" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="idAutor" SourceColumnNullMapping="false" SourceVersion="Current" />
</Parameters>
</DbCommand>
</UpdateCommand>
</DbSource>
</MainSource>
<Mappings>
<Mapping SourceColumn="idAutor" DataSetColumn="idAutor" />
<Mapping SourceColumn="nomeAutor" DataSetColumn="nomeAutor" />
</Mappings>
<Sources />
</TableAdapter>
</Tables>
<Sources />
</DataSource>
</xs:appinfo>
</xs:annotation>
<xs:element name="tbTrabalhoDataSet" msdata:IsDataSet="true" msdata:UseCurrentLocale="true" msprop:EnableTableAdapterManager="True" msprop:Generator_DataSetName="tbTrabalhoDataSet" msprop:Generator_UserDSName="tbTrabalhoDataSet">
<xs:complexType>
<xs:choice minOccurs="0" maxOccurs="unbounded">
<xs:element name="tbCliente" msprop:Generator_TableClassName="tbClienteDataTable" msprop:Generator_TableVarName="tabletbCliente" msprop:Generator_TablePropName="tbCliente" msprop:Generator_RowDeletingName="tbClienteRowDeleting" msprop:Generator_RowChangingName="tbClienteRowChanging" msprop:Generator_RowEvHandlerName="tbClienteRowChangeEventHandler" msprop:Generator_RowDeletedName="tbClienteRowDeleted" msprop:Generator_UserTableName="tbCliente" msprop:Generator_RowChangedName="tbClienteRowChanged" msprop:Generator_RowEvArgName="tbClienteRowChangeEvent" msprop:Generator_RowClassName="tbClienteRow">
<xs:complexType>
<xs:sequence>
<xs:element name="idCliente" msprop:Generator_ColumnVarNameInTable="columnidCliente" msprop:Generator_ColumnPropNameInRow="idCliente" msprop:Generator_ColumnPropNameInTable="idClienteColumn" msprop:Generator_UserColumnName="idCliente" type="xs:int" />
<xs:element name="nomeCliente" msprop:Generator_ColumnVarNameInTable="columnnomeCliente" msprop:Generator_ColumnPropNameInRow="nomeCliente" msprop:Generator_ColumnPropNameInTable="nomeClienteColumn" msprop:Generator_UserColumnName="nomeCliente" minOccurs="0">
<xs:simpleType>
<xs:restriction base="xs:string">
<xs:maxLength value="50" />
</xs:restriction>
</xs:simpleType>
</xs:element>
<xs:element name="rgCliente" msprop:Generator_ColumnVarNameInTable="columnrgCliente" msprop:Generator_ColumnPropNameInRow="rgCliente" msprop:Generator_ColumnPropNameInTable="rgClienteColumn" msprop:Generator_UserColumnName="rgCliente" minOccurs="0">
<xs:simpleType>
<xs:restriction base="xs:string">
<xs:maxLength value="12" />
</xs:restriction>
</xs:simpleType>
</xs:element>
<xs:element name="cpfCliente" msprop:Generator_ColumnVarNameInTable="columncpfCliente" msprop:Generator_ColumnPropNameInRow="cpfCliente" msprop:Generator_ColumnPropNameInTable="cpfClienteColumn" msprop:Generator_UserColumnName="cpfCliente" minOccurs="0">
<xs:simpleType>
<xs:restriction base="xs:string">
<xs:maxLength value="11" />
</xs:restriction>
</xs:simpleType>
</xs:element>
<xs:element name="telCliente" msprop:Generator_ColumnVarNameInTable="columntelCliente" msprop:Generator_ColumnPropNameInRow="telCliente" msprop:Generator_ColumnPropNameInTable="telClienteColumn" msprop:Generator_UserColumnName="telCliente" minOccurs="0">
<xs:simpleType>
<xs:restriction base="xs:string">
<xs:maxLength value="10" />
</xs:restriction>
</xs:simpleType>
</xs:element>
<xs:element name="celCliente" msprop:Generator_ColumnVarNameInTable="columncelCliente" msprop:Generator_ColumnPropNameInRow="celCliente" msprop:Generator_ColumnPropNameInTable="celClienteColumn" msprop:Generator_UserColumnName="celCliente" minOccurs="0">
<xs:simpleType>
<xs:restriction base="xs:string">
<xs:maxLength value="11" />
</xs:restriction>
</xs:simpleType>
</xs:element>
<xs:element name="ruaCliente" msprop:Generator_ColumnVarNameInTable="columnruaCliente" msprop:Generator_ColumnPropNameInRow="ruaCliente" msprop:Generator_ColumnPropNameInTable="ruaClienteColumn" msprop:Generator_UserColumnName="ruaCliente" minOccurs="0">
<xs:simpleType>
<xs:restriction base="xs:string">
<xs:maxLength value="100" />
</xs:restriction>
</xs:simpleType>
</xs:element>
<xs:element name="numeroCliente" msprop:Generator_ColumnVarNameInTable="columnnumeroCliente" msprop:Generator_ColumnPropNameInRow="numeroCliente" msprop:Generator_ColumnPropNameInTable="numeroClienteColumn" msprop:Generator_UserColumnName="numeroCliente" minOccurs="0">
<xs:simpleType>
<xs:restriction base="xs:string">
<xs:maxLength value="4" />
</xs:restriction>
</xs:simpleType>
</xs:element>
<xs:element name="cidadeCliente" msprop:Generator_ColumnVarNameInTable="columncidadeCliente" msprop:Generator_ColumnPropNameInRow="cidadeCliente" msprop:Generator_ColumnPropNameInTable="cidadeClienteColumn" msprop:Generator_UserColumnName="cidadeCliente" minOccurs="0">
<xs:simpleType>
<xs:restriction base="xs:string">
<xs:maxLength value="30" />
</xs:restriction>
</xs:simpleType>
</xs:element>
<xs:element name="statusCliente" msprop:Generator_ColumnVarNameInTable="columnstatusCliente" msprop:Generator_ColumnPropNameInRow="statusCliente" msprop:Generator_ColumnPropNameInTable="statusClienteColumn" msprop:Generator_UserColumnName="statusCliente" minOccurs="0">
<xs:simpleType>
<xs:restriction base="xs:string">
<xs:maxLength value="10" />
</xs:restriction>
</xs:simpleType>
</xs:element>
</xs:sequence>
</xs:complexType>
</xs:element>
<xs:element name="tbEditora" msprop:Generator_TableClassName="tbEditoraDataTable" msprop:Generator_TableVarName="tabletbEditora" msprop:Generator_TablePropName="tbEditora" msprop:Generator_RowDeletingName="tbEditoraRowDeleting" msprop:Generator_RowChangingName="tbEditoraRowChanging" msprop:Generator_RowEvHandlerName="tbEditoraRowChangeEventHandler" msprop:Generator_RowDeletedName="tbEditoraRowDeleted" msprop:Generator_UserTableName="tbEditora" msprop:Generator_RowChangedName="tbEditoraRowChanged" msprop:Generator_RowEvArgName="tbEditoraRowChangeEvent" msprop:Generator_RowClassName="tbEditoraRow">
<xs:complexType>
<xs:sequence>
<xs:element name="idEditora" msprop:Generator_ColumnVarNameInTable="columnidEditora" msprop:Generator_ColumnPropNameInRow="idEditora" msprop:Generator_ColumnPropNameInTable="idEditoraColumn" msprop:Generator_UserColumnName="idEditora" type="xs:int" />
<xs:element name="nomeEditora" msprop:Generator_ColumnVarNameInTable="columnnomeEditora" msprop:Generator_ColumnPropNameInRow="nomeEditora" msprop:Generator_ColumnPropNameInTable="nomeEditoraColumn" msprop:Generator_UserColumnName="nomeEditora" minOccurs="0">
<xs:simpleType>
<xs:restriction base="xs:string">
<xs:maxLength value="30" />
</xs:restriction>
</xs:simpleType>
</xs:element>
</xs:sequence>
</xs:complexType>
</xs:element>
<xs:element name="tbEmprestimo" msprop:Generator_TableClassName="tbEmprestimoDataTable" msprop:Generator_TableVarName="tabletbEmprestimo" msprop:Generator_TablePropName="tbEmprestimo" msprop:Generator_RowDeletingName="tbEmprestimoRowDeleting" msprop:Generator_RowChangingName="tbEmprestimoRowChanging" msprop:Generator_RowEvHandlerName="tbEmprestimoRowChangeEventHandler" msprop:Generator_RowDeletedName="tbEmprestimoRowDeleted" msprop:Generator_UserTableName="tbEmprestimo" msprop:Generator_RowChangedName="tbEmprestimoRowChanged" msprop:Generator_RowEvArgName="tbEmprestimoRowChangeEvent" msprop:Generator_RowClassName="tbEmprestimoRow">
<xs:complexType>
<xs:sequence>
<xs:element name="idEmprestimo" msprop:Generator_ColumnVarNameInTable="columnidEmprestimo" msprop:Generator_ColumnPropNameInRow="idEmprestimo" msprop:Generator_ColumnPropNameInTable="idEmprestimoColumn" msprop:Generator_UserColumnName="idEmprestimo" type="xs:int" />
<xs:element name="idFunc" msprop:Generator_ColumnVarNameInTable="columnidFunc" msprop:Generator_ColumnPropNameInRow="idFunc" msprop:Generator_ColumnPropNameInTable="idFuncColumn" msprop:Generator_UserColumnName="idFunc" type="xs:int" minOccurs="0" />
<xs:element name="idCliente" msprop:Generator_ColumnVarNameInTable="columnidCliente" msprop:Generator_ColumnPropNameInRow="idCliente" msprop:Generator_ColumnPropNameInTable="idClienteColumn" msprop:Generator_UserColumnName="idCliente" type="xs:int" minOccurs="0" />
<xs:element name="idItem" msprop:Generator_ColumnVarNameInTable="columnidItem" msprop:Generator_ColumnPropNameInRow="idItem" msprop:Generator_ColumnPropNameInTable="idItemColumn" msprop:Generator_UserColumnName="idItem" type="xs:int" minOccurs="0" />
<xs:element name="dataEmprestimo" msprop:Generator_ColumnVarNameInTable="columndataEmprestimo" msprop:Generator_ColumnPropNameInRow="dataEmprestimo" msprop:Generator_ColumnPropNameInTable="dataEmprestimoColumn" msprop:Generator_UserColumnName="dataEmprestimo" type="xs:dateTime" minOccurs="0" />
<xs:element name="dataDevolucao" msprop:Generator_ColumnVarNameInTable="columndataDevolucao" msprop:Generator_ColumnPropNameInRow="dataDevolucao" msprop:Generator_ColumnPropNameInTable="dataDevolucaoColumn" msprop:Generator_UserColumnName="dataDevolucao" type="xs:dateTime" minOccurs="0" />
<xs:element name="statusEmprestimo" msprop:Generator_ColumnVarNameInTable="columnstatusEmprestimo" msprop:Generator_ColumnPropNameInRow="statusEmprestimo" msprop:Generator_ColumnPropNameInTable="statusEmprestimoColumn" msprop:Generator_UserColumnName="statusEmprestimo" minOccurs="0">
<xs:simpleType>
<xs:restriction base="xs:string">
<xs:maxLength value="10" />
</xs:restriction>
</xs:simpleType>
</xs:element>
</xs:sequence>
</xs:complexType>
</xs:element>
<xs:element name="tbFuncionario" msprop:Generator_TableClassName="tbFuncionarioDataTable" msprop:Generator_TableVarName="tabletbFuncionario" msprop:Generator_TablePropName="tbFuncionario" msprop:Generator_RowDeletingName="tbFuncionarioRowDeleting" msprop:Generator_RowChangingName="tbFuncionarioRowChanging" msprop:Generator_RowEvHandlerName="tbFuncionarioRowChangeEventHandler" msprop:Generator_RowDeletedName="tbFuncionarioRowDeleted" msprop:Generator_UserTableName="tbFuncionario" msprop:Generator_RowChangedName="tbFuncionarioRowChanged" msprop:Generator_RowEvArgName="tbFuncionarioRowChangeEvent" msprop:Generator_RowClassName="tbFuncionarioRow">
<xs:complexType>
<xs:sequence>
<xs:element name="idFunc" msprop:Generator_ColumnVarNameInTable="columnidFunc" msprop:Generator_ColumnPropNameInRow="idFunc" msprop:Generator_ColumnPropNameInTable="idFuncColumn" msprop:Generator_UserColumnName="idFunc" type="xs:int" />
<xs:element name="nomeFunc" msprop:Generator_ColumnVarNameInTable="columnnomeFunc" msprop:Generator_ColumnPropNameInRow="nomeFunc" msprop:Generator_ColumnPropNameInTable="nomeFuncColumn" msprop:Generator_UserColumnName="nomeFunc" minOccurs="0">
<xs:simpleType>
<xs:restriction base="xs:string">
<xs:maxLength value="50" />
</xs:restriction>
</xs:simpleType>
</xs:element>
<xs:element name="rgFunc" msprop:Generator_ColumnVarNameInTable="columnrgFunc" msprop:Generator_ColumnPropNameInRow="rgFunc" msprop:Generator_ColumnPropNameInTable="rgFuncColumn" msprop:Generator_UserColumnName="rgFunc" minOccurs="0">
<xs:simpleType>
<xs:restriction base="xs:string">
<xs:maxLength value="12" />
</xs:restriction>
</xs:simpleType>
</xs:element>
<xs:element name="cpfFunc" msprop:Generator_ColumnVarNameInTable="columncpfFunc" msprop:Generator_ColumnPropNameInRow="cpfFunc" msprop:Generator_ColumnPropNameInTable="cpfFuncColumn" msprop:Generator_UserColumnName="cpfFunc" minOccurs="0">
<xs:simpleType>
<xs:restriction base="xs:string">
<xs:maxLength value="11" />
</xs:restriction>
</xs:simpleType>
</xs:element>
<xs:element name="telFunc" msprop:Generator_ColumnVarNameInTable="columntelFunc" msprop:Generator_ColumnPropNameInRow="telFunc" msprop:Generator_ColumnPropNameInTable="telFuncColumn" msprop:Generator_UserColumnName="telFunc" minOccurs="0">
<xs:simpleType>
<xs:restriction base="xs:string">
<xs:maxLength value="10" />
</xs:restriction>
</xs:simpleType>
</xs:element>
<xs:element name="celFunc" msprop:Generator_ColumnVarNameInTable="columncelFunc" msprop:Generator_ColumnPropNameInRow="celFunc" msprop:Generator_ColumnPropNameInTable="celFuncColumn" msprop:Generator_UserColumnName="celFunc" minOccurs="0">
<xs:simpleType>
<xs:restriction base="xs:string">
<xs:maxLength value="11" />
</xs:restriction>
</xs:simpleType>
</xs:element>
<xs:element name="ruaFunc" msprop:Generator_ColumnVarNameInTable="columnruaFunc" msprop:Generator_ColumnPropNameInRow="ruaFunc" msprop:Generator_ColumnPropNameInTable="ruaFuncColumn" msprop:Generator_UserColumnName="ruaFunc" minOccurs="0">
<xs:simpleType>
<xs:restriction base="xs:string">
<xs:maxLength value="100" />
</xs:restriction>
</xs:simpleType>
</xs:element>
<xs:element name="numeroFunc" msprop:Generator_ColumnVarNameInTable="columnnumeroFunc" msprop:Generator_ColumnPropNameInRow="numeroFunc" msprop:Generator_ColumnPropNameInTable="numeroFuncColumn" msprop:Generator_UserColumnName="numeroFunc" minOccurs="0">
<xs:simpleType>
<xs:restriction base="xs:string">
<xs:maxLength value="4" />
</xs:restriction>
</xs:simpleType>
</xs:element>
<xs:element name="cidadeFunc" msprop:Generator_ColumnVarNameInTable="columncidadeFunc" msprop:Generator_ColumnPropNameInRow="cidadeFunc" msprop:Generator_ColumnPropNameInTable="cidadeFuncColumn" msprop:Generator_UserColumnName="cidadeFunc" minOccurs="0">
<xs:simpleType>
<xs:restriction base="xs:string">
<xs:maxLength value="30" />
</xs:restriction>
</xs:simpleType>
</xs:element>
<xs:element name="statusFunc" msprop:Generator_ColumnVarNameInTable="columnstatusFunc" msprop:Generator_ColumnPropNameInRow="statusFunc" msprop:Generator_ColumnPropNameInTable="statusFuncColumn" msprop:Generator_UserColumnName="statusFunc" minOccurs="0">
<xs:simpleType>
<xs:restriction base="xs:string">
<xs:maxLength value="10" />
</xs:restriction>
</xs:simpleType>
</xs:element>
<xs:element name="usuarioFunc" msprop:Generator_ColumnVarNameInTable="columnusuarioFunc" msprop:Generator_ColumnPropNameInRow="usuarioFunc" msprop:Generator_ColumnPropNameInTable="usuarioFuncColumn" msprop:Generator_UserColumnName="usuarioFunc" minOccurs="0">
<xs:simpleType>
<xs:restriction base="xs:string">
<xs:maxLength value="15" />
</xs:restriction>
</xs:simpleType>
</xs:element>
<xs:element name="senhaFunc" msprop:Generator_ColumnVarNameInTable="columnsenhaFunc" msprop:Generator_ColumnPropNameInRow="senhaFunc" msprop:Generator_ColumnPropNameInTable="senhaFuncColumn" msprop:Generator_UserColumnName="senhaFunc" minOccurs="0">
<xs:simpleType>
<xs:restriction base="xs:string">
<xs:maxLength value="15" />
</xs:restriction>
</xs:simpleType>
</xs:element>
</xs:sequence>
</xs:complexType>
</xs:element>
<xs:element name="tbGenero" msprop:Generator_TableClassName="tbGeneroDataTable" msprop:Generator_TableVarName="tabletbGenero" msprop:Generator_TablePropName="tbGenero" msprop:Generator_RowDeletingName="tbGeneroRowDeleting" msprop:Generator_RowChangingName="tbGeneroRowChanging" msprop:Generator_RowEvHandlerName="tbGeneroRowChangeEventHandler" msprop:Generator_RowDeletedName="tbGeneroRowDeleted" msprop:Generator_UserTableName="tbGenero" msprop:Generator_RowChangedName="tbGeneroRowChanged" msprop:Generator_RowEvArgName="tbGeneroRowChangeEvent" msprop:Generator_RowClassName="tbGeneroRow">
<xs:complexType>
<xs:sequence>
<xs:element name="idGenero" msprop:Generator_ColumnVarNameInTable="columnidGenero" msprop:Generator_ColumnPropNameInRow="idGenero" msprop:Generator_ColumnPropNameInTable="idGeneroColumn" msprop:Generator_UserColumnName="idGenero" type="xs:int" />
<xs:element name="nomeGenero" msprop:Generator_ColumnVarNameInTable="columnnomeGenero" msprop:Generator_ColumnPropNameInRow="nomeGenero" msprop:Generator_ColumnPropNameInTable="nomeGeneroColumn" msprop:Generator_UserColumnName="nomeGenero" minOccurs="0">
<xs:simpleType>
<xs:restriction base="xs:string">
<xs:maxLength value="30" />
</xs:restriction>
</xs:simpleType>
</xs:element>
</xs:sequence>
</xs:complexType>
</xs:element>
<xs:element name="tbItem" msprop:Generator_TableClassName="tbItemDataTable" msprop:Generator_TableVarName="tabletbItem" msprop:Generator_TablePropName="tbItem" msprop:Generator_RowDeletingName="tbItemRowDeleting" msprop:Generator_RowChangingName="tbItemRowChanging" msprop:Generator_RowEvHandlerName="tbItemRowChangeEventHandler" msprop:Generator_RowDeletedName="tbItemRowDeleted" msprop:Generator_UserTableName="tbItem" msprop:Generator_RowChangedName="tbItemRowChanged" msprop:Generator_RowEvArgName="tbItemRowChangeEvent" msprop:Generator_RowClassName="tbItemRow">
<xs:complexType>
<xs:sequence>
<xs:element name="idItem" msprop:Generator_ColumnVarNameInTable="columnidItem" msprop:Generator_ColumnPropNameInRow="idItem" msprop:Generator_ColumnPropNameInTable="idItemColumn" msprop:Generator_UserColumnName="idItem" type="xs:int" />
<xs:element name="nomeItem" msprop:Generator_ColumnVarNameInTable="columnnomeItem" msprop:Generator_ColumnPropNameInRow="nomeItem" msprop:Generator_ColumnPropNameInTable="nomeItemColumn" msprop:Generator_UserColumnName="nomeItem" minOccurs="0">
<xs:simpleType>
<xs:restriction base="xs:string">
<xs:maxLength value="50" />
</xs:restriction>
</xs:simpleType>
</xs:element>
<xs:element name="idAutor" msprop:Generator_ColumnVarNameInTable="columnidAutor" msprop:Generator_ColumnPropNameInRow="idAutor" msprop:Generator_ColumnPropNameInTable="idAutorColumn" msprop:Generator_UserColumnName="idAutor" type="xs:int" minOccurs="0" />
<xs:element name="generoItem" msprop:Generator_ColumnVarNameInTable="columngeneroItem" msprop:Generator_ColumnPropNameInRow="generoItem" msprop:Generator_ColumnPropNameInTable="generoItemColumn" msprop:Generator_UserColumnName="generoItem" type="xs:int" minOccurs="0" />
<xs:element name="editoraItem" msprop:Generator_ColumnVarNameInTable="columneditoraItem" msprop:Generator_ColumnPropNameInRow="editoraItem" msprop:Generator_ColumnPropNameInTable="editoraItemColumn" msprop:Generator_UserColumnName="editoraItem" type="xs:int" minOccurs="0" />
<xs:element name="tipoItem" msprop:Generator_ColumnVarNameInTable="columntipoItem" msprop:Generator_ColumnPropNameInRow="tipoItem" msprop:Generator_ColumnPropNameInTable="tipoItemColumn" msprop:Generator_UserColumnName="tipoItem" type="xs:int" minOccurs="0" />
<xs:element name="isbnItem" msprop:Generator_ColumnVarNameInTable="columnisbnItem" msprop:Generator_ColumnPropNameInRow="isbnItem" msprop:Generator_ColumnPropNameInTable="isbnItemColumn" msprop:Generator_UserColumnName="isbnItem" minOccurs="0">
<xs:simpleType>
<xs:restriction base="xs:string">
<xs:maxLength value="13" />
</xs:restriction>
</xs:simpleType>
</xs:element>
<xs:element name="statusItem" msprop:Generator_ColumnVarNameInTable="columnstatusItem" msprop:Generator_ColumnPropNameInRow="statusItem" msprop:Generator_ColumnPropNameInTable="statusItemColumn" msprop:Generator_UserColumnName="statusItem" minOccurs="0">
<xs:simpleType>
<xs:restriction base="xs:string">
<xs:maxLength value="10" />
</xs:restriction>
</xs:simpleType>
</xs:element>
</xs:sequence>
</xs:complexType>
</xs:element>
<xs:element name="tbTipo" msprop:Generator_TableClassName="tbTipoDataTable" msprop:Generator_TableVarName="tabletbTipo" msprop:Generator_TablePropName="tbTipo" msprop:Generator_RowDeletingName="tbTipoRowDeleting" msprop:Generator_RowChangingName="tbTipoRowChanging" msprop:Generator_RowEvHandlerName="tbTipoRowChangeEventHandler" msprop:Generator_RowDeletedName="tbTipoRowDeleted" msprop:Generator_UserTableName="tbTipo" msprop:Generator_RowChangedName="tbTipoRowChanged" msprop:Generator_RowEvArgName="tbTipoRowChangeEvent" msprop:Generator_RowClassName="tbTipoRow">
<xs:complexType>
<xs:sequence>
<xs:element name="idTipo" msprop:Generator_ColumnVarNameInTable="columnidTipo" msprop:Generator_ColumnPropNameInRow="idTipo" msprop:Generator_ColumnPropNameInTable="idTipoColumn" msprop:Generator_UserColumnName="idTipo" type="xs:int" />
<xs:element name="nomeTipo" msprop:Generator_ColumnVarNameInTable="columnnomeTipo" msprop:Generator_ColumnPropNameInRow="nomeTipo" msprop:Generator_ColumnPropNameInTable="nomeTipoColumn" msprop:Generator_UserColumnName="nomeTipo" minOccurs="0">
<xs:simpleType>
<xs:restriction base="xs:string">
<xs:maxLength value="30" />
</xs:restriction>
</xs:simpleType>
</xs:element>
</xs:sequence>
</xs:complexType>
</xs:element>
<xs:element name="tbAutor" msprop:Generator_TableClassName="tbAutorDataTable" msprop:Generator_TableVarName="tabletbAutor" msprop:Generator_TablePropName="tbAutor" msprop:Generator_RowDeletingName="tbAutorRowDeleting" msprop:Generator_RowChangingName="tbAutorRowChanging" msprop:Generator_RowEvHandlerName="tbAutorRowChangeEventHandler" msprop:Generator_RowDeletedName="tbAutorRowDeleted" msprop:Generator_UserTableName="tbAutor" msprop:Generator_RowChangedName="tbAutorRowChanged" msprop:Generator_RowEvArgName="tbAutorRowChangeEvent" msprop:Generator_RowClassName="tbAutorRow">
<xs:complexType>
<xs:sequence>
<xs:element name="idAutor" msdata:ReadOnly="true" msdata:AutoIncrement="true" msdata:AutoIncrementSeed="-1" msdata:AutoIncrementStep="-1" msprop:Generator_ColumnVarNameInTable="columnidAutor" msprop:Generator_ColumnPropNameInRow="idAutor" msprop:Generator_ColumnPropNameInTable="idAutorColumn" msprop:Generator_UserColumnName="idAutor" type="xs:int" />
<xs:element name="nomeAutor" msprop:Generator_ColumnVarNameInTable="columnnomeAutor" msprop:Generator_ColumnPropNameInRow="nomeAutor" msprop:Generator_ColumnPropNameInTable="nomeAutorColumn" msprop:Generator_UserColumnName="nomeAutor" minOccurs="0">
<xs:simpleType>
<xs:restriction base="xs:string">
<xs:maxLength value="200" />
</xs:restriction>
</xs:simpleType>
</xs:element>
</xs:sequence>
</xs:complexType>
</xs:element>
</xs:choice>
</xs:complexType>
<xs:unique name="Constraint1" msdata:PrimaryKey="true">
<xs:selector xpath=".//mstns:tbCliente" />
<xs:field xpath="mstns:idCliente" />
</xs:unique>
<xs:unique name="tbEditora_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
<xs:selector xpath=".//mstns:tbEditora" />
<xs:field xpath="mstns:idEditora" />
</xs:unique>
<xs:unique name="tbEmprestimo_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
<xs:selector xpath=".//mstns:tbEmprestimo" />
<xs:field xpath="mstns:idEmprestimo" />
</xs:unique>
<xs:unique name="tbFuncionario_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
<xs:selector xpath=".//mstns:tbFuncionario" />
<xs:field xpath="mstns:idFunc" />
</xs:unique>
<xs:unique name="tbGenero_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
<xs:selector xpath=".//mstns:tbGenero" />
<xs:field xpath="mstns:idGenero" />
</xs:unique>
<xs:unique name="tbItem_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
<xs:selector xpath=".//mstns:tbItem" />
<xs:field xpath="mstns:idItem" />
</xs:unique>
<xs:unique name="tbTipo_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
<xs:selector xpath=".//mstns:tbTipo" />
<xs:field xpath="mstns:idTipo" />
</xs:unique>
<xs:unique name="tbAutor_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
<xs:selector xpath=".//mstns:tbAutor" />
<xs:field xpath="mstns:idAutor" />
</xs:unique>
</xs:element>
<xs:annotation>
<xs:appinfo>
<msdata:Relationship name="FK_tbEmprestimo_tbCliente" msdata:parent="tbCliente" msdata:child="tbEmprestimo" msdata:parentkey="idCliente" msdata:childkey="idCliente" msprop:Generator_UserChildTable="tbEmprestimo" msprop:Generator_ChildPropName="GettbEmprestimoRows" msprop:Generator_UserRelationName="FK_tbEmprestimo_tbCliente" msprop:Generator_ParentPropName="tbClienteRow" msprop:Generator_RelationVarName="relationFK_tbEmprestimo_tbCliente" msprop:Generator_UserParentTable="tbCliente" />
<msdata:Relationship name="FK_tbEmprestimo_tbFuncionario" msdata:parent="tbFuncionario" msdata:child="tbEmprestimo" msdata:parentkey="idFunc" msdata:childkey="idFunc" msprop:Generator_UserChildTable="tbEmprestimo" msprop:Generator_ChildPropName="GettbEmprestimoRows" msprop:Generator_UserRelationName="FK_tbEmprestimo_tbFuncionario" msprop:Generator_RelationVarName="relationFK_tbEmprestimo_tbFuncionario" msprop:Generator_UserParentTable="tbFuncionario" msprop:Generator_ParentPropName="tbFuncionarioRow" />
<msdata:Relationship name="FK_tbEmprestimo_tbItem" msdata:parent="tbItem" msdata:child="tbEmprestimo" msdata:parentkey="idItem" msdata:childkey="idItem" msprop:Generator_UserChildTable="tbEmprestimo" msprop:Generator_ChildPropName="GettbEmprestimoRows" msprop:Generator_UserRelationName="FK_tbEmprestimo_tbItem" msprop:Generator_RelationVarName="relationFK_tbEmprestimo_tbItem" msprop:Generator_UserParentTable="tbItem" msprop:Generator_ParentPropName="tbItemRow" />
<msdata:Relationship name="FK_tbItem_tbGenero" msdata:parent="tbGenero" msdata:child="tbItem" msdata:parentkey="idGenero" msdata:childkey="generoItem" msprop:Generator_UserChildTable="tbItem" msprop:Generator_ChildPropName="GettbItemRows" msprop:Generator_UserRelationName="FK_tbItem_tbGenero" msprop:Generator_ParentPropName="tbGeneroRow" msprop:Generator_RelationVarName="relationFK_tbItem_tbGenero" msprop:Generator_UserParentTable="tbGenero" />
<msdata:Relationship name="FK_tbItem_tbTipo" msdata:parent="tbTipo" msdata:child="tbItem" msdata:parentkey="idTipo" msdata:childkey="tipoItem" msprop:Generator_UserChildTable="tbItem" msprop:Generator_ChildPropName="GettbItemRows" msprop:Generator_UserRelationName="FK_tbItem_tbTipo" msprop:Generator_RelationVarName="relationFK_tbItem_tbTipo" msprop:Generator_UserParentTable="tbTipo" msprop:Generator_ParentPropName="tbTipoRow" />
<msdata:Relationship name="FK_tbItem_tbAutor" msdata:parent="tbAutor" msdata:child="tbItem" msdata:parentkey="idAutor" msdata:childkey="idAutor" msprop:Generator_UserChildTable="tbItem" msprop:Generator_ChildPropName="GettbItemRows" msprop:Generator_UserRelationName="FK_tbItem_tbAutor" msprop:Generator_RelationVarName="relationFK_tbItem_tbAutor" msprop:Generator_UserParentTable="tbAutor" msprop:Generator_ParentPropName="tbAutorRow" />
</xs:appinfo>
</xs:annotation>
</xs:schema>
Reference in New Issue Copy Permalink