DataClasses1.dbml 2.0 KB

1234567891011121314151617181920212223
  1. <?xml version="1.0" encoding="utf-8"?><Database Name="Ляхов" Class="DataClasses1DataContext" xmlns="http://schemas.microsoft.com/linqtosql/dbml/2007">
  2. <Connection Mode="AppSettings" ConnectionString="Data Source=TERM-BD;Initial Catalog=Ляхов;Integrated Security=True" SettingsObjectName="Lyakhov_Tovar.Properties.Settings" SettingsPropertyName="ЛяховConnectionString" Provider="System.Data.SqlClient" />
  3. <Table Name="dbo.Сотрудник" Member="Сотрудник">
  4. <Type Name="Сотрудник">
  5. <Column Name="Имя" Type="System.String" DbType="NVarChar(50) NOT NULL" CanBeNull="false" />
  6. <Column Name="Фамилия" Type="System.String" DbType="NVarChar(50) NOT NULL" CanBeNull="false" />
  7. <Column Name="Отчество" Type="System.String" DbType="NVarChar(50) NOT NULL" CanBeNull="false" />
  8. <Column Name="Телефон" Type="System.String" DbType="NVarChar(50) NOT NULL" CanBeNull="false" />
  9. <Column Name="Код_сотрудника" Type="System.Int32" DbType="Int NOT NULL IDENTITY" IsPrimaryKey="true" IsDbGenerated="true" CanBeNull="false" />
  10. <Column Name="Логин" Type="System.String" DbType="NVarChar(50) NOT NULL" CanBeNull="false" />
  11. <Column Name="Пароль" Type="System.String" DbType="NVarChar(50) NOT NULL" CanBeNull="false" />
  12. </Type>
  13. </Table>
  14. <Table Name="dbo.Товары" Member="Товары">
  15. <Type Name="Товары">
  16. <Column Name="Название_товара" Type="System.String" DbType="NVarChar(50) NOT NULL" CanBeNull="false" />
  17. <Column Name="Количество" Type="System.Int32" DbType="Int NOT NULL" CanBeNull="false" />
  18. <Column Name="Цена_за_штуку" Type="System.Decimal" DbType="Money NOT NULL" CanBeNull="false" />
  19. <Column Name="Код_товара" Type="System.Int32" DbType="Int NOT NULL IDENTITY" IsPrimaryKey="true" IsDbGenerated="true" CanBeNull="false" />
  20. <Column Name="Код_заказа" Type="System.Int32" DbType="Int" CanBeNull="true" />
  21. </Type>
  22. </Table>
  23. </Database>