Создание проекта библиотеки классов .NET Core 2.1 с использованием ADO.NET

Вступление

В этой статье я собираюсь показать вам, как создать проект библиотеки классов .NET Core 2.1 с использованием ADO.NET.
Этот проект библиотеки классов содержит функции бизнес-логики для вставки данных в базу данных. Затем я использую этот проект библиотеки классов в приложении ASP.NET Core 2.1 MVC .
Мы будем использовать Visual Studio 2017 (версия 15.9.13 или выше) и SQL Server 2017. Вы также можете использовать SQL Server 2008 или выше.
Что такое библиотека классов?

Библиотека классов содержит типы, классы, интерфейсы и методы, которые легко использовать повторно, разделяемые, распределенные или потребляемое приложение. Кроме того, проект библиотеки классов используется для повторного использования кода.
Предпосылки
Установите Visual studio 2017 Обновленная версия 15.9.13.
Установите .Net Core SDK 2.1 или выше.
SQL Server 2017.
Теперь мы создадим наш проект библиотеки классов .Net Core 2.1.
Прежде всего, мы создадим базу данных и хранимые процедуры.
Вам также может понравиться:
Все вещи ASP.NET Core и MVC: учебные пособия и статьи .
Создание базы данных и хранимых процедур

Шаг 1 — Создать базу данных

Откройте SQL — сервер и использовать следующий скрипт для создания в « CoreMvcDB» баз данных
Create database CoreMvcDB
Шаг 2 — Создать таблицу

Откройте SQL Server и используйте следующий скрипт для создания таблицы « tbl_Employee».
SQL
           </div>
<div class="CodeMirror-vscrollbar">
<div style="min-width: 1px; height: 0px;">
       <br /> 
      </div>
</div>
<div class="CodeMirror-hscrollbar">
<div style="height: 100%; min-height: 1px; width: 0px;">
       <br /> 
      </div>
</div>
<div class="CodeMirror-scrollbar-filler">
      <br /> 
     </div>
<div class="CodeMirror-gutter-filler">
      <br /> 
     </div>
<div class="CodeMirror-scroll" tabindex="-1">
<div class="CodeMirror-sizer" style="margin-left: 31px; margin-bottom: -15px; border-right-width: 15px; min-height: 215px; padding-right: 0px; padding-bottom: 0px;">
<div style="position: relative; top: 0px;">
<div class="CodeMirror-lines">
<div style="position: relative; outline: none;">
<div class="CodeMirror-measure">
           <span>x</span>
          </div>
<div class="CodeMirror-measure">
           <br /> 
          </div>
<div style="position: relative; z-index: 1;">
           <br /> 
          </div>
<div class="CodeMirror-cursors">
<div class="CodeMirror-cursor" style="left: 40.9688px; top: 161px; height: 23px;">
              
           </div>
</div>
<div class="CodeMirror-code">
<div style="position: relative;">
<div class="CodeMirror-gutter-wrapper" style="left: -31px;">
<div class="CodeMirror-linenumber CodeMirror-gutter-elt" style="left: 0px; width: 23px;"><font style="vertical-align: inherit;"><font style="vertical-align: inherit;"><br />
               1<br />
             </font></font></div>
</div>
<pre class="CodeMirror-line"><span style="padding-right: 0.1px;"><span class="cm-keyword">create</span> <span class="cm-keyword">table</span> tbl_Employee</span></pre>
</div>
<div style="position: relative;">
<div class="CodeMirror-gutter-wrapper" style="left: -31px;">
<div class="CodeMirror-linenumber CodeMirror-gutter-elt" style="left: 0px; width: 23px;"><font style="vertical-align: inherit;"><font style="vertical-align: inherit;"><br />
               2<br />
             </font></font></div>
</div>
<pre class="CodeMirror-line"><span style="padding-right: 0.1px;">(</span></pre>
</div>
<div style="position: relative;">
<div class="CodeMirror-gutter-wrapper" style="left: -31px;">
<div class="CodeMirror-linenumber CodeMirror-gutter-elt" style="left: 0px; width: 23px;"><font style="vertical-align: inherit;"><font style="vertical-align: inherit;"><br />
               3<br />
             </font></font></div>
</div>
<pre class="CodeMirror-line"><span style="padding-right: 0.1px;"><span class="cm-tab">    </span>Sr_no <span class="cm-builtin">int</span> <span class="cm-keyword">not</span> <span class="cm-atom">null</span> primary key identity(<span class="cm-number">1</span>,<span class="cm-number">1</span>),</span></pre>
</div>
<div style="position: relative;">
<div class="CodeMirror-gutter-wrapper" style="left: -31px;">
<div class="CodeMirror-linenumber CodeMirror-gutter-elt" style="left: 0px; width: 23px;"><font style="vertical-align: inherit;"><font style="vertical-align: inherit;"><br />
               4<br />
             </font></font></div>
</div>
<pre class="CodeMirror-line"><span style="padding-right: 0.1px;"><span class="cm-tab">    </span>Emp_Name nvarchar(<span class="cm-number">250</span>),</span></pre>
</div>
<div style="position: relative;">
<div class="CodeMirror-gutter-wrapper" style="left: -31px;">
<div class="CodeMirror-linenumber CodeMirror-gutter-elt" style="left: 0px; width: 23px;"><font style="vertical-align: inherit;"><font style="vertical-align: inherit;"><br />
               5<br />
             </font></font></div>
</div>
<pre class="CodeMirror-line"><span style="padding-right: 0.1px;"><span class="cm-tab">    </span>City nvarchar(<span class="cm-number">100</span>),</span></pre>
</div>
<div style="position: relative;">
<div class="CodeMirror-gutter-wrapper" style="left: -31px;">
<div class="CodeMirror-linenumber CodeMirror-gutter-elt" style="left: 0px; width: 23px;"><font style="vertical-align: inherit;"><font style="vertical-align: inherit;"><br />
               6<br />
             </font></font></div>
</div>
<pre class="CodeMirror-line"><span style="padding-right: 0.1px;"><span class="cm-tab">    </span>State nvarchar(<span class="cm-number">100</span>),</span></pre>
</div>
<div style="position: relative;">
<div class="CodeMirror-gutter-wrapper" style="left: -31px;">
<div class="CodeMirror-linenumber CodeMirror-gutter-elt" style="left: 0px; width: 23px;"><font style="vertical-align: inherit;"><font style="vertical-align: inherit;"><br />
               7<br />
             </font></font></div>
</div>
<pre class="CodeMirror-line"><span style="padding-right: 0.1px;"><span class="cm-tab">    </span>Country nvarchar(<span class="cm-number">100</span>),</span></pre>
</div>
<div style="position: relative;">
<div class="CodeMirror-gutter-wrapper" style="left: -31px;">
<div class="CodeMirror-linenumber CodeMirror-gutter-elt" style="left: 0px; width: 23px;"><font style="vertical-align: inherit;"><font style="vertical-align: inherit;"><br />
               8<br />
             </font></font></div>
</div>
<pre class="CodeMirror-line"><span style="padding-right: 0.1px;"><span class="cm-tab">    </span>Department nvarchar(<span class="cm-number">50</span>)</span></pre>
</div>
<div style="position: relative;">
<div class="CodeMirror-gutter-wrapper" style="left: -31px;">
<div class="CodeMirror-linenumber CodeMirror-gutter-elt" style="left: 0px; width: 23px;"><font style="vertical-align: inherit;"><font style="vertical-align: inherit;"><br />
               9<br />
             </font></font></div>
</div>
<pre class="CodeMirror-line"><span style="padding-right: 0.1px;">)</span></pre>
</div>
</div>
</div>
</div>
</div>
</div>
<div style="position: absolute; height: 15px; width: 1px; border-bottom: 0px solid transparent; top: 215px;">
       <br /> 
      </div>
<div class="CodeMirror-gutters" style="height: 230px; left: 0px;">
<div class="CodeMirror-gutter CodeMirror-linenumbers" style="width: 31px;">
        <span> </span>
       </div>
</div>
</div>
</div>
</div>
</div>
</div>
</ol>
<h3><strong><span><font style="vertical-align: inherit;"><font style="vertical-align: inherit;">Шаг 3 — Создайте хранимую процедуру</font></font></span></strong></h3>
<p><font style="vertical-align: inherit;"><font style="vertical-align: inherit;">Теперь мы создадим хранимую процедуру для добавления данных о сотрудниках в базу данных. </font><font style="vertical-align: inherit;">Откройте </font></font><a href="https://translate.google.com/translate?sl=en&tl=ru&hl=ru&u=https://dzone.com/articles/easily-extract-data-from-sql-server-for-fast-amp-v&client=webapp" rel="nofollow"><font style="vertical-align: inherit;"><font style="vertical-align: inherit;">SQL Server</font></font></a><font style="vertical-align: inherit;"><font style="vertical-align: inherit;"> и используйте следующий скрипт для создания процедуры.</font></font></p>
<p><strong><span><font style="vertical-align: inherit;"><font style="vertical-align: inherit;">Чтобы вставить запись сотрудника</font></font></span></strong></p>
<div class="codeMirror-wrapper">
<div contenteditable="false">
<div class="codeHeader">
<div class="nameLanguage"><font style="vertical-align: inherit;"><font style="vertical-align: inherit;"><br />
     SQL<br />
   </font></font></div>
<p>   <i class="icon-cancel-circled-1 cm-remove"> </i>
  </p>
</div>
<div class="codeMirror-code--wrapper" data-code="create procedure sp_Employee_Add
@Emp_Name nvarchar(250),
@City nvarchar(100),
@State nvarchar(100),
@Country nvarchar(100),
@Department nvarchar(50)
AS
BEGIN
Insert into tbl_Employee(Emp_Name,City,State,Country,Department)
values(@Emp_Name,@City,@State,@Country,@Department)
END" data-lang="text/x-sql">
<div class="CodeMirror cm-s-default CodeMirror-wrap">
<div style="overflow: hidden; position: relative; width: 3px; height: 0px; top: 5px; left: 36px;">
     <textarea spellcheck="false" tabindex="0" style="position: absolute; bottom: -1em; padding: 0px; width: 1000px; height: 1em; outline: none;" value=""/>
    </div>
<div class="CodeMirror-vscrollbar">
<div style="min-width: 1px; height: 0px;">
      <br /> 
     </div>
</div>
<div class="CodeMirror-hscrollbar">
<div style="height: 100%; min-height: 1px; width: 0px;">
      <br /> 
     </div>
</div>
<div class="CodeMirror-scrollbar-filler">
     <br /> 
    </div>
<div class="CodeMirror-gutter-filler">
     <br /> 
    </div>
<div class="CodeMirror-scroll" tabindex="-1">
<div class="CodeMirror-sizer" style="margin-left: 31px; margin-bottom: -15px; border-right-width: 15px; min-height: 261px; padding-right: 0px; padding-bottom: 0px;">
<div style="position: relative; top: 0px;">
<div class="CodeMirror-lines">
<div style="position: relative; outline: none;">
<div class="CodeMirror-measure">
<pre><span>xxxxxxxxxx</span></pre>
<div class="CodeMirror-linenumber CodeMirror-gutter-elt">
<div>
             1
           </div>
</div>
<div class="CodeMirror-linenumber CodeMirror-gutter-elt">
<div>
             11
           </div>
</div>
</div>
<div class="CodeMirror-measure">
          <br /> 
         </div>
<div style="position: relative; z-index: 1;">
          <br /> 
         </div>
<div class="CodeMirror-cursors">
<div class="CodeMirror-cursor" style="left: 4px; top: 0px; height: 23px;">
             
          </div>
</div>
<div class="CodeMirror-code">
<div style="position: relative;">
<div class="CodeMirror-gutter-wrapper" style="left: -31px;">
<div class="CodeMirror-linenumber CodeMirror-gutter-elt" style="left: 0px; width: 23px;"><font style="vertical-align: inherit;"><font style="vertical-align: inherit;"><br />
              1<br />
            </font></font></div>
</div>
<pre class="CodeMirror-line"><span style="padding-right: 0.1px;"><span class="cm-keyword">create</span> procedure sp_Employee_Add</span></pre>
</div>
<div style="position: relative;">
<div class="CodeMirror-gutter-wrapper" style="left: -31px;">
<div class="CodeMirror-linenumber CodeMirror-gutter-elt" style="left: 0px; width: 23px;"><font style="vertical-align: inherit;"><font style="vertical-align: inherit;"><br />
              2<br />
            </font></font></div>
</div>
<pre class="CodeMirror-line"><span style="padding-right: 0.1px;">@Emp_Name nvarchar(<span class="cm-number">250</span>),</span></pre>
</div>
<div style="position: relative;">
<div class="CodeMirror-gutter-wrapper" style="left: -31px;">
<div class="CodeMirror-linenumber CodeMirror-gutter-elt" style="left: 0px; width: 23px;"><font style="vertical-align: inherit;"><font style="vertical-align: inherit;"><br />
              3<br />
            </font></font></div>
</div>
<pre class="CodeMirror-line"><span style="padding-right: 0.1px;">@City nvarchar(<span class="cm-number">100</span>),</span></pre>
</div>
<div style="position: relative;">
<div class="CodeMirror-gutter-wrapper" style="left: -31px;">
<div class="CodeMirror-linenumber CodeMirror-gutter-elt" style="left: 0px; width: 23px;"><font style="vertical-align: inherit;"><font style="vertical-align: inherit;"><br />
              4<br />
            </font></font></div>
</div>
<pre class="CodeMirror-line"><span style="padding-right: 0.1px;">@State nvarchar(<span class="cm-number">100</span>),</span></pre>
</div>
<div style="position: relative;">
<div class="CodeMirror-gutter-wrapper" style="left: -31px;">
<div class="CodeMirror-linenumber CodeMirror-gutter-elt" style="left: 0px; width: 23px;"><font style="vertical-align: inherit;"><font style="vertical-align: inherit;"><br />
              5<br />
            </font></font></div>
</div>
<pre class="CodeMirror-line"><span style="padding-right: 0.1px;">@Country nvarchar(<span class="cm-number">100</span>),</span></pre>
</div>
<div style="position: relative;">
<div class="CodeMirror-gutter-wrapper" style="left: -31px;">
<div class="CodeMirror-linenumber CodeMirror-gutter-elt" style="left: 0px; width: 23px;"><font style="vertical-align: inherit;"><font style="vertical-align: inherit;"><br />
              6<br />
            </font></font></div>
</div>
<pre class="CodeMirror-line"><span style="padding-right: 0.1px;">@Department nvarchar(<span class="cm-number">50</span>)</span></pre>
</div>
<div style="position: relative;">
<div class="CodeMirror-gutter-wrapper" style="left: -31px;">
<div class="CodeMirror-linenumber CodeMirror-gutter-elt" style="left: 0px; width: 23px;"><font style="vertical-align: inherit;"><font style="vertical-align: inherit;"><br />
              7<br />
            </font></font></div>
</div>
<pre class="CodeMirror-line"><span style="padding-right: 0.1px;"><span class="cm-keyword">AS</span></span></pre>
</div>
<div style="position: relative;">
<div class="CodeMirror-gutter-wrapper" style="left: -31px;">
<div class="CodeMirror-linenumber CodeMirror-gutter-elt" style="left: 0px; width: 23px;"><font style="vertical-align: inherit;"><font style="vertical-align: inherit;"><br />
              8<br />
            </font></font></div>
</div>
<pre class="CodeMirror-line"><span style="padding-right: 0.1px;"><span class="cm-keyword">BEGIN</span></span></pre>
</div>
<div style="position: relative;">
<div class="CodeMirror-gutter-wrapper" style="left: -31px;">
<div class="CodeMirror-linenumber CodeMirror-gutter-elt" style="left: 0px; width: 23px;"><font style="vertical-align: inherit;"><font style="vertical-align: inherit;"><br />
              9<br />
            </font></font></div>
</div>
<pre class="CodeMirror-line"><span style="padding-right: 0.1px;"><span class="cm-keyword">Insert</span> <span class="cm-keyword">into</span> tbl_Employee(Emp_Name,City,State,Country,Department)</span></pre>
</div>
<div style="position: relative;">
<div class="CodeMirror-gutter-wrapper" style="left: -31px;">
<div class="CodeMirror-linenumber CodeMirror-gutter-elt" style="left: 0px; width: 23px;"><font style="vertical-align: inherit;"><font style="vertical-align: inherit;"><br />
              10<br />
            </font></font></div>
</div>
<pre class="CodeMirror-line"><span style="padding-right: 0.1px;"><span class="cm-keyword">values</span>(@Emp_Name,@City,@State,@Country,@Department)</span></pre>
</div>
<div style="position: relative;">
<div class="CodeMirror-gutter-wrapper" style="left: -31px;">
<div class="CodeMirror-linenumber CodeMirror-gutter-elt" style="left: 0px; width: 23px;"><font style="vertical-align: inherit;"><font style="vertical-align: inherit;"><br />
              11<br />
            </font></font></div>
</div>
<pre class="CodeMirror-line"><span style="padding-right: 0.1px;">END</span></pre>
</div>
</div>
</div>
</div>
</div>
</div>
<div style="position: absolute; height: 15px; width: 1px; border-bottom: 0px solid transparent; top: 261px;">
      <br /> 
     </div>
<div class="CodeMirror-gutters" style="height: 276px; left: 0px;">
<div class="CodeMirror-gutter CodeMirror-linenumbers" style="width: 31px;">
      </div>
</div>
</div>
</div>
</div>
</div>
</div>
<p><font style="vertical-align: inherit;"><font style="vertical-align: inherit;">Теперь мы создадим проект библиотеки классов .NET Core 2.1.</font></font></p>
<h2><font style="vertical-align: inherit;"><font style="vertical-align: inherit;">Создание проекта библиотеки классов .NET Core 2.1</font></font></h2>
<h3><strong><span><font style="vertical-align: inherit;"><font style="vertical-align: inherit;">Шаг 1 — Создание библиотеки классов Пустое решение</font></font></span></strong></h3>
<p><font style="vertical-align: inherit;"><font style="vertical-align: inherit;">Сначала создаем пустое решение для нашего проекта библиотеки классов, оно содержит наш проект библиотеки классов и связанные с ним проекты. </font><font style="vertical-align: inherit;">Решение Visual Studio просто служит контейнером для одного или нескольких проектов.</font></font></p>
<ol start="1">
<li><font style="vertical-align: inherit;"><font style="vertical-align: inherit;">Откройте панель меню Visual Studio, выберите </font></font><strong><font style="vertical-align: inherit;"><font style="vertical-align: inherit;">Файл -> Создать -> Проект</font></font></strong><font style="vertical-align: inherit;"><font style="vertical-align: inherit;"> .</font></font></li>
</ol>
<ol start="2">
<li><font style="vertical-align: inherit;"><font style="vertical-align: inherit;">После выбора проекта откроется диалоговое окно «Новый проект». </font><font style="vertical-align: inherit;">Разверните </font><font style="vertical-align: inherit;">узел </font><font style="vertical-align: inherit;">« </font></font><em><span><font style="vertical-align: inherit;"><font style="vertical-align: inherit;">Другие типы проектов</font></font></span></em><font style="vertical-align: inherit;"><font style="vertical-align: inherit;"> » и выберите « </font></font><em><span><font style="vertical-align: inherit;"><font style="vertical-align: inherit;">Решения Visual Studio. </font></font></span></em><font style="vertical-align: inherit;"><font style="vertical-align: inherit;">Назовите решение «Читтаранджан» и нажмите </font><font style="vertical-align: inherit;">кнопку « </font></font><strong><font style="vertical-align: inherit;"><font style="vertical-align: inherit;">ОК»</font></font></strong><font style="vertical-align: inherit;"><font style="vertical-align: inherit;"> .</font></font></li>
</ol>
<h3><strong><span><font style="vertical-align: inherit;"><font style="vertical-align: inherit;">Шаг 2. Создание проекта библиотеки базовых классов .NET</font></font></span></strong></h3>
<ol start="1">
<li><font style="vertical-align: inherit;"><font style="vertical-align: inherit;">В обозревателе решений щелкните правой кнопкой мыши файл решения Chittaranjan и в контекстном меню выберите пункт меню « </font></font><strong><font style="vertical-align: inherit;"><font style="vertical-align: inherit;">Добавить -> Новый проект»</font></font></strong><font style="vertical-align: inherit;"><font style="vertical-align: inherit;"> .</font></font></li>
</ol>
<ol start="2">
<li><font style="vertical-align: inherit;"><font style="vertical-align: inherit;">В </font><font style="vertical-align: inherit;">диалоговом окне </font><font style="vertical-align: inherit;">« </font></font><strong><font style="vertical-align: inherit;"><font style="vertical-align: inherit;">Добавить новый проект</font></font></strong><font style="vertical-align: inherit;"><font style="vertical-align: inherit;"> » разверните узел Visual C #; </font><font style="vertical-align: inherit;">затем выберите узел .NET Core с левой стороны и выберите  </font><font style="vertical-align: inherit;">шаблон проекта </font></font><strong><font style="vertical-align: inherit;"><font style="vertical-align: inherit;">библиотеки классов (.NET Core)</font></font></strong><font style="vertical-align: inherit;"><font style="vertical-align: inherit;"> .</font></font></li>
</ol>
<p><font style="vertical-align: inherit;"><font style="vertical-align: inherit;">Теперь вы можете дать вашему проекту имя и выбрать </font></font><strong><font style="vertical-align: inherit;"><font style="vertical-align: inherit;">OK,</font></font></strong><font style="vertical-align: inherit;"><font style="vertical-align: inherit;"> чтобы создать проект библиотеки классов .NET Core. </font><font style="vertical-align: inherit;">Здесь мой проект называется «ChittaDB».</font></font></p>
<p><font style="vertical-align: inherit;"><font style="vertical-align: inherit;">Теперь наш проект библиотеки классов создан. </font><font style="vertical-align: inherit;">Решение «Chittaranjan» содержит один проект, который называется «ChittaDB».</font></font></p>
<h3><strong><span><font style="vertical-align: inherit;"><font style="vertical-align: inherit;">Шаг 3 — Добавить функциональность проекта библиотеки классов</font></font></span></strong></h3>
<p><font style="vertical-align: inherit;"><font style="vertical-align: inherit;">В проекте библиотеки классов «ChittaDB» я добавил два файла классов для вставки данных и сохранения данных в базе данных. </font><font style="vertical-align: inherit;">Сделать это:</font></font></p>
<ul>
<li><font style="vertical-align: inherit;"><font style="vertical-align: inherit;">Добавьте класс в проект библиотеки классов.</font></font></li>
<li><font style="vertical-align: inherit;"><font style="vertical-align: inherit;">Щелкните правой кнопкой мыши по проекту «ChittaDB» и выберите пункт меню « </font></font><strong><font style="vertical-align: inherit;"><font style="vertical-align: inherit;">A </font></font></strong><strong><font style="vertical-align: inherit;"><font style="vertical-align: inherit;">dd a New Item»</font></font></strong><font style="vertical-align: inherit;"><font style="vertical-align: inherit;"> . </font><font style="vertical-align: inherit;">В диалоговом окне параметров меню выберите </font></font><strong><font style="vertical-align: inherit;"><font style="vertical-align: inherit;">VisualC # Items</font></font></strong><font style="vertical-align: inherit;"><font style="vertical-align: inherit;"> с левой стороны и выберите </font></font><strong><font style="vertical-align: inherit;"><font style="vertical-align: inherit;">Class</font></font></strong><font style="vertical-align: inherit;"><font style="vertical-align: inherit;"> с правой стороны. </font><font style="vertical-align: inherit;">Затем вы можете добавить свое имя класса. </font><font style="vertical-align: inherit;">Здесь имя нашего класса — </font></font><strong><font style="vertical-align: inherit;"><font style="vertical-align: inherit;">EmployeeEntities.cs</font></font></strong><font style="vertical-align: inherit;"><font style="vertical-align: inherit;"> . </font><font style="vertical-align: inherit;">Теперь нажмите </font><font style="vertical-align: inherit;">кнопку </font></font><strong><font style="vertical-align: inherit;"><font style="vertical-align: inherit;">Добавить</font></font></strong><font style="vertical-align: inherit;"><font style="vertical-align: inherit;"> . </font><font style="vertical-align: inherit;">Этот класс будет содержать наши свойства Employee.</font></font></li>
<li><font style="vertical-align: inherit;"><font style="vertical-align: inherit;">Теперь откройте </font><font style="vertical-align: inherit;">класс </font></font><strong><font style="vertical-align: inherit;"><font style="vertical-align: inherit;">EmployeeEntities.cs</font></font></strong><font style="vertical-align: inherit;"><font style="vertical-align: inherit;"> и поместите в него следующий код. </font><font style="vertical-align: inherit;">Мы также добавляем необходимые валидаторы в поля класса EmployeeEntities, поэтому нам нужно использовать </font></font><strong><font style="vertical-align: inherit;"><font style="vertical-align: inherit;">System.ComponentModel.DataAnnotations</font></font></strong><font style="vertical-align: inherit;"><font style="vertical-align: inherit;"> вверху.</font></font></li>
</ul>
<ol start="1">
<div class="codeMirror-wrapper">
<div contenteditable="false">
<div class="codeHeader">
<div class="nameLanguage"><font style="vertical-align: inherit;"><font style="vertical-align: inherit;"><br />
      C #<br />
    </font></font></div>
<p>    <i class="icon-cancel-circled-1 cm-remove"> </i>
   </p>
</div>
<div class="codeMirror-code--wrapper" data-code="using System.ComponentModel.DataAnnotations;
namespace ChittaDB
{
	public class EmployeeEntities
	{
		[Required]
		public string Emp_Name { get; set; }
		[Required]
		public string City { get; set; }
		[Required]
		public string State { get; set; }
		[Required]
		public string Country { get; set; }
		[Required]
		public string Department { get; set; }
	}
}" data-lang="text/x-csharp">
<div class="CodeMirror cm-s-default CodeMirror-wrap">
<div style="overflow: hidden; position: relative; width: 3px; height: 0px; top: 249px; left: 72.9688px;">
      <textarea spellcheck="false" tabindex="0" style="position: absolute; bottom: -1em; padding: 0px; width: 1000px; height: 1em; outline: none;" value=""/>
     </div>
<div class="CodeMirror-vscrollbar" style="display: block; bottom: 0px;">
<div style="min-width: 1px; height: 399px;">
       <br /> 
      </div>
</div>
<div class="CodeMirror-hscrollbar">
<div style="height: 100%; min-height: 1px; width: 0px;">
       <br /> 
      </div>
</div>
<div class="CodeMirror-scrollbar-filler">
      <br /> 
     </div>
<div class="CodeMirror-gutter-filler">
      <br /> 
     </div>
<div class="CodeMirror-scroll" tabindex="-1">
<div class="CodeMirror-sizer" style="margin-left: 31px; margin-bottom: -15px; border-right-width: 15px; min-height: 399px; padding-right: 15px; padding-bottom: 0px;">
<div style="position: relative; top: 0px;">
<div class="CodeMirror-lines">
<div style="position: relative; outline: none;">
<div class="CodeMirror-measure">
<pre><span>xxxxxxxxxx</span></pre>
<div class="CodeMirror-linenumber CodeMirror-gutter-elt">
<div>
              1
            </div>
</div>
<div class="CodeMirror-linenumber CodeMirror-gutter-elt">
<div>
              17
            </div>
</div>
</div>
<div class="CodeMirror-measure">
           <br /> 
          </div>
<div style="position: relative; z-index: 1;">
           <br /> 
          </div>
<div class="CodeMirror-cursors">
<div class="CodeMirror-cursor" style="left: 40.9688px; top: 345px; height: 23px;">
              
           </div>
</div>
<div class="CodeMirror-code">
<div style="position: relative;">
<div class="CodeMirror-gutter-wrapper" style="left: -31px;">
<div class="CodeMirror-linenumber CodeMirror-gutter-elt" style="left: 0px; width: 23px;"><font style="vertical-align: inherit;"><font style="vertical-align: inherit;"><br />
               1<br />
             </font></font></div>
</div>
<pre class="CodeMirror-line"><span style="padding-right: 0.1px;"><span class="cm-keyword">using</span> <span class="cm-variable">System</span>.<span class="cm-variable">ComponentModel</span>.<span class="cm-variable">DataAnnotations</span>;</span></pre>
</div>
<div style="position: relative;">
<div class="CodeMirror-gutter-wrapper" style="left: -31px;">
<div class="CodeMirror-linenumber CodeMirror-gutter-elt" style="left: 0px; width: 23px;"><font style="vertical-align: inherit;"><font style="vertical-align: inherit;"><br />
               2<br />
             </font></font></div>
</div>
<pre class="CodeMirror-line"><span style="padding-right: 0.1px;"><span class="cm-keyword">namespace</span> <span class="cm-def">ChittaDB</span></span></pre>
</div>
<div style="position: relative;">
<div class="CodeMirror-gutter-wrapper" style="left: -31px;">
<div class="CodeMirror-linenumber CodeMirror-gutter-elt" style="left: 0px; width: 23px;"><font style="vertical-align: inherit;"><font style="vertical-align: inherit;"><br />
               3<br />
             </font></font></div>
</div>
<pre class="CodeMirror-line"><span style="padding-right: 0.1px;">{</span></pre>
</div>
<div style="position: relative;">
<div class="CodeMirror-gutter-wrapper" style="left: -31px;">
<div class="CodeMirror-linenumber CodeMirror-gutter-elt" style="left: 0px; width: 23px;"><font style="vertical-align: inherit;"><font style="vertical-align: inherit;"><br />
               4<br />
             </font></font></div>
</div>
<pre class="CodeMirror-line"><span style="padding-right: 0.1px;"><span class="cm-tab">    </span><span class="cm-keyword">public</span> <span class="cm-keyword">class</span> <span class="cm-def">EmployeeEntities</span></span></pre>
</div>
<div style="position: relative;">
<div class="CodeMirror-gutter-wrapper" style="left: -31px;">
<div class="CodeMirror-linenumber CodeMirror-gutter-elt" style="left: 0px; width: 23px;"><font style="vertical-align: inherit;"><font style="vertical-align: inherit;"><br />
               5<br />
             </font></font></div>
</div>
<pre class="CodeMirror-line"><span style="padding-right: 0.1px;"><span class="cm-tab">    </span>{</span></pre>
</div>
<div style="position: relative;">
<div class="CodeMirror-gutter-wrapper" style="left: -31px;">
<div class="CodeMirror-linenumber CodeMirror-gutter-elt" style="left: 0px; width: 23px;"><font style="vertical-align: inherit;"><font style="vertical-align: inherit;"><br />
               6<br />
             </font></font></div>
</div>
<pre class="CodeMirror-line"><span style="padding-right: 0.1px;"><span class="cm-tab">    </span><span class="cm-tab">    </span>[<span class="cm-variable">Required</span>]</span></pre>
</div>
<div style="position: relative;">
<div class="CodeMirror-gutter-wrapper" style="left: -31px;">
<div class="CodeMirror-linenumber CodeMirror-gutter-elt" style="left: 0px; width: 23px;"><font style="vertical-align: inherit;"><font style="vertical-align: inherit;"><br />
               7<br />
             </font></font></div>
</div>
<pre class="CodeMirror-line"><span style="padding-right: 0.1px;"><span class="cm-tab">    </span><span class="cm-tab">    </span><span class="cm-keyword">public</span> <span class="cm-type">string</span> <span class="cm-variable">Emp_Name</span> { <span class="cm-keyword">get</span>; <span class="cm-keyword">set</span>; }</span></pre>
</div>
<div style="position: relative;">
<div class="CodeMirror-gutter-wrapper" style="left: -31px;">
<div class="CodeMirror-linenumber CodeMirror-gutter-elt" style="left: 0px; width: 23px;"><font style="vertical-align: inherit;"><font style="vertical-align: inherit;"><br />
               8<br />
             </font></font></div>
</div>
<pre class="CodeMirror-line"><span style="padding-right: 0.1px;"><span class="cm-tab">    </span><span class="cm-tab">    </span>[<span class="cm-variable">Required</span>]</span></pre>
</div>
<div style="position: relative;">
<div class="CodeMirror-gutter-wrapper" style="left: -31px;">
<div class="CodeMirror-linenumber CodeMirror-gutter-elt" style="left: 0px; width: 23px;"><font style="vertical-align: inherit;"><font style="vertical-align: inherit;"><br />
               9<br />
             </font></font></div>
</div>
<pre class="CodeMirror-line"><span style="padding-right: 0.1px;"><span class="cm-tab">    </span><span class="cm-tab">    </span><span class="cm-keyword">public</span> <span class="cm-type">string</span> <span class="cm-variable">City</span> { <span class="cm-keyword">get</span>; <span class="cm-keyword">set</span>; }</span></pre>
</div>
<div style="position: relative;">
<div class="CodeMirror-gutter-wrapper" style="left: -31px;">
<div class="CodeMirror-linenumber CodeMirror-gutter-elt" style="left: 0px; width: 23px;"><font style="vertical-align: inherit;"><font style="vertical-align: inherit;"><br />
               10<br />
             </font></font></div>
</div>
<pre class="CodeMirror-line"><span style="padding-right: 0.1px;"><span class="cm-tab">    </span><span class="cm-tab">    </span>[<span class="cm-variable">Required</span>]</span></pre>
</div>
<div style="position: relative;">
<div class="CodeMirror-gutter-wrapper" style="left: -31px;">
<div class="CodeMirror-linenumber CodeMirror-gutter-elt" style="left: 0px; width: 23px;"><font style="vertical-align: inherit;"><font style="vertical-align: inherit;"><br />
               11<br />
             </font></font></div>
</div>
<pre class="CodeMirror-line"><span style="padding-right: 0.1px;"><span class="cm-tab">    </span><span class="cm-tab">    </span><span class="cm-keyword">public</span> <span class="cm-type">string</span> <span class="cm-variable">State</span> { <span class="cm-keyword">get</span>; <span class="cm-keyword">set</span>; }</span></pre>
</div>
<div style="position: relative;">
<div class="CodeMirror-gutter-wrapper" style="left: -31px;">
<div class="CodeMirror-linenumber CodeMirror-gutter-elt" style="left: 0px; width: 23px;"><font style="vertical-align: inherit;"><font style="vertical-align: inherit;"><br />
               12<br />
             </font></font></div>
</div>
<pre class="CodeMirror-line"><span style="padding-right: 0.1px;"><span class="cm-tab">    </span><span class="cm-tab">    </span>[<span class="cm-variable">Required</span>]</span></pre>
</div>
<div style="position: relative;">
<div class="CodeMirror-gutter-wrapper" style="left: -31px;">
<div class="CodeMirror-linenumber CodeMirror-gutter-elt" style="left: 0px; width: 23px;"><font style="vertical-align: inherit;"><font style="vertical-align: inherit;"><br />
               13<br />
             </font></font></div>
</div>
<pre class="CodeMirror-line"><span style="padding-right: 0.1px;"><span class="cm-tab">    </span><span class="cm-tab">    </span><span class="cm-keyword">public</span> <span class="cm-type">string</span> <span class="cm-variable">Country</span> { <span class="cm-keyword">get</span>; <span class="cm-keyword">set</span>; }</span></pre>
</div>
<div style="position: relative;">
<div class="CodeMirror-gutter-wrapper" style="left: -31px;">
<div class="CodeMirror-linenumber CodeMirror-gutter-elt" style="left: 0px; width: 23px;"><font style="vertical-align: inherit;"><font style="vertical-align: inherit;"><br />
               14<br />
             </font></font></div>
</div>
<pre class="CodeMirror-line"><span style="padding-right: 0.1px;"><span class="cm-tab">    </span><span class="cm-tab">    </span>[<span class="cm-variable">Required</span>]</span></pre>
</div>
<div style="position: relative;">
<div class="CodeMirror-gutter-wrapper" style="left: -31px;">
<div class="CodeMirror-linenumber CodeMirror-gutter-elt" style="left: 0px; width: 23px;"><font style="vertical-align: inherit;"><font style="vertical-align: inherit;"><br />
               15<br />
             </font></font></div>
</div>
<pre class="CodeMirror-line"><span style="padding-right: 0.1px;"><span class="cm-tab">    </span><span class="cm-tab">    </span><span class="cm-keyword">public</span> <span class="cm-type">string</span> <span class="cm-variable">Department</span> { <span class="cm-keyword">get</span>; <span class="cm-keyword">set</span>; }</span></pre>
</div>
<div style="position: relative;">
<div class="CodeMirror-gutter-wrapper" style="left: -31px;">
<div class="CodeMirror-linenumber CodeMirror-gutter-elt" style="left: 0px; width: 23px;"><font style="vertical-align: inherit;"><font style="vertical-align: inherit;"><br />
               16<br />
             </font></font></div>
</div>
<pre class="CodeMirror-line"><span style="padding-right: 0.1px;"><span class="cm-tab">    </span>}</span></pre>
</div>
<div style="position: relative;">
<div class="CodeMirror-gutter-wrapper" style="left: -31px;">
<div class="CodeMirror-linenumber CodeMirror-gutter-elt" style="left: 0px; width: 23px;"><font style="vertical-align: inherit;"><font style="vertical-align: inherit;"><br />
               17<br />
             </font></font></div>
</div>
<pre class="CodeMirror-line"><span style="padding-right: 0.1px;">}</span></pre>
</div>
</div>
</div>
</div>
</div>
</div>
<div style="position: absolute; height: 15px; width: 1px; border-bottom: 0px solid transparent; top: 399px;">
       <br /> 
      </div>
<div class="CodeMirror-gutters" style="height: 414px; left: 0px;">
<div class="CodeMirror-gutter CodeMirror-linenumbers" style="width: 31px;">
       </div>
</div>
</div>
</div>
</div>
</div>
</div>
</ol>
<ul>
<li><font style="vertical-align: inherit;"><font style="vertical-align: inherit;">Добавьте еще один класс в проект библиотеки классов для методов вставки. </font></font></li>
<li><font style="vertical-align: inherit;"><font style="vertical-align: inherit;">Щелкните правой кнопкой мыши по проекту «ChittaDB» и выберите пункт «Добавить новый пункт меню». </font><font style="vertical-align: inherit;">В диалоговом окне параметров меню выберите VisualC # Items с левой стороны и выберите Class с правой стороны. </font><font style="vertical-align: inherit;">Затем вы можете поставить название своего класса. </font><font style="vertical-align: inherit;">Здесь Имя нашего класса — EmployeeDBAccessLayer, нажмите кнопку Добавить. </font><font style="vertical-align: inherit;">Этот класс будет содержать операции, связанные с нашей базой данных.</font></font></li>
</ul>
<p><font style="vertical-align: inherit;"><font style="vertical-align: inherit;">Теперь структура проекта библиотеки классов приведена ниже.</font></font></p>
<p><font style="vertical-align: inherit;"><font style="vertical-align: inherit;">Откройте EmployeeDBAccessLayer.cs и поместите следующий код для обработки операций базы данных. </font><font style="vertical-align: inherit;">Обязательно укажите строку подключения.</font></font></p>
<p><strong><u><span><font style="vertical-align: inherit;"><font style="vertical-align: inherit;">Примечание.</font></font></span></u></strong><strong><u><br /> </u></strong><font style="vertical-align: inherit;"><font style="vertical-align: inherit;"> Для Ado.Net я добавляю «Microsoft.EntityFrameworkCore.SqlServer» в свой проект библиотеки классов. </font><font style="vertical-align: inherit;">Это доступно в пакетах управления NuGet.</font></font></p>
<ol start="1">
<li>
<div class="codeMirror-wrapper">
<div contenteditable="false">
<div class="codeHeader">
<div class="nameLanguage"><font style="vertical-align: inherit;"><font style="vertical-align: inherit;"><br />
       C #<br />
     </font></font></div>
<p>     <i class="icon-cancel-circled-1 cm-remove"> </i>
    </p>
</div>
<div class="codeMirror-code--wrapper" data-code="using System.Data;
using System.Data.SqlClient;
namespace ChittaDB
{
  	public class EmployeeDBAccessLayer
	{
		SqlConnection con = new SqlConnection("put your connection string here");
		public string AddEmployeeRecord(EmployeeEntities employeeEntities)
		{
			try
			{
				SqlCommand cmd = new SqlCommand("sp_Employee_Add", con);
				cmd.CommandType = CommandType.StoredProcedure;
				cmd.Parameters.AddWithValue("@Emp_Name",
                                            employeeEntities.Emp_Name);
				cmd.Parameters.AddWithValue("@City", employeeEntities.City);
				cmd.Parameters.AddWithValue("@State", employeeEntities.State);
				cmd.Parameters.AddWithValue("@Country",
                                            employeeEntities.Country);
				cmd.Parameters.AddWithValue("@Department",
                                            employeeEntities.Department);

              	con.Open();
				cmd.ExecuteNonQuery();
				con.Close();

              	return ("Data save Successfully");
			}
			catch (Exception ex)
			{
				if (con.State == ConnectionState.Open)
				{
					con.Close();
				}

              	return (ex.Message.ToString());
			}
		}
	}
}" data-lang="text/x-csharp">
<div class="CodeMirror cm-s-default CodeMirror-wrap">
<div style="overflow: hidden; position: relative; width: 3px; height: 0px; top: 249px; left: 45.25px;">
       <textarea spellcheck="false" tabindex="0" style="position: absolute; bottom: -1em; padding: 0px; width: 1000px; height: 1em; outline: none;" value=""/>
      </div>
<div class="CodeMirror-vscrollbar" style="display: block; bottom: 0px;">
<div style="min-width: 1px; height: 951px;">
        <br /> 
       </div>
</div>
<div class="CodeMirror-hscrollbar">
<div style="height: 100%; min-height: 1px; width: 0px;">
        <br /> 
       </div>
</div>
<div class="CodeMirror-scrollbar-filler">
       <br /> 
      </div>
<div class="CodeMirror-gutter-filler">
       <br /> 
      </div>
<div class="CodeMirror-scroll" tabindex="-1">
<div class="CodeMirror-sizer" style="margin-left: 31px; margin-bottom: -15px; border-right-width: 15px; min-height: 951px; padding-right: 15px; padding-bottom: 0px;">
<div style="position: relative; top: 0px;">
<div class="CodeMirror-lines">
<div style="position: relative; outline: none;">
<div class="CodeMirror-measure">
<pre><span>xxxxxxxxxx</span></pre>
<div class="CodeMirror-linenumber CodeMirror-gutter-elt">
<div>
               1
             </div>
</div>
<div class="CodeMirror-linenumber CodeMirror-gutter-elt">
<div>
               35
             </div>
</div>
</div>
<div class="CodeMirror-measure">
            <br /> 
           </div>
<div style="position: relative; z-index: 1;">
            <br /> 
           </div>
<div class="CodeMirror-cursors" style="visibility: hidden;">
<div class="CodeMirror-cursor" style="left: 13.25px; top: 920px; height: 23px;">
               
            </div>
</div>
<div class="CodeMirror-code">
<div style="position: relative;">
<div class="CodeMirror-gutter-wrapper" style="left: -31px;">
<div class="CodeMirror-linenumber CodeMirror-gutter-elt" style="left: 0px; width: 23px;"><font style="vertical-align: inherit;"><font style="vertical-align: inherit;"><br />
                1<br />
              </font></font></div>
</div>
<pre class="CodeMirror-line"><span style="padding-right: 0.1px;"><span class="cm-keyword">using</span> <span class="cm-variable">System</span>.<span class="cm-variable">Data</span>;</span></pre>
</div>
<div style="position: relative;">
<div class="CodeMirror-gutter-wrapper" style="left: -31px;">
<div class="CodeMirror-linenumber CodeMirror-gutter-elt" style="left: 0px; width: 23px;"><font style="vertical-align: inherit;"><font style="vertical-align: inherit;"><br />
                2<br />
              </font></font></div>
</div>
<pre class="CodeMirror-line"><span style="padding-right: 0.1px;"><span class="cm-keyword">using</span> <span class="cm-variable">System</span>.<span class="cm-variable">Data</span>.<span class="cm-variable">SqlClient</span>;</span></pre>
</div>
<div style="position: relative;">
<div class="CodeMirror-gutter-wrapper" style="left: -31px;">
<div class="CodeMirror-linenumber CodeMirror-gutter-elt" style="left: 0px; width: 23px;"><font style="vertical-align: inherit;"><font style="vertical-align: inherit;"><br />
                3<br />
              </font></font></div>
</div>
<pre class="CodeMirror-line"><span style="padding-right: 0.1px;"><span class="cm-keyword">namespace</span> <span class="cm-def">ChittaDB</span></span></pre>
</div>
<div style="position: relative;">
<div class="CodeMirror-gutter-wrapper" style="left: -31px;">
<div class="CodeMirror-linenumber CodeMirror-gutter-elt" style="left: 0px; width: 23px;"><font style="vertical-align: inherit;"><font style="vertical-align: inherit;"><br />
                4<br />
              </font></font></div>
</div>
<pre class="CodeMirror-line"><span style="padding-right: 0.1px;">{</span></pre>
</div>
<div style="position: relative;">
<div class="CodeMirror-gutter-wrapper" style="left: -31px;">
<div class="CodeMirror-linenumber CodeMirror-gutter-elt" style="left: 0px; width: 23px;"><font style="vertical-align: inherit;"><font style="vertical-align: inherit;"><br />
                5<br />
              </font></font></div>
</div>
<pre class="CodeMirror-line"><span style="padding-right: 0.1px;">  <span class="cm-tab">  </span><span class="cm-keyword">public</span> <span class="cm-keyword">class</span> <span class="cm-def">EmployeeDBAccessLayer</span></span></pre>
</div>
<div style="position: relative;">
<div class="CodeMirror-gutter-wrapper" style="left: -31px;">
<div class="CodeMirror-linenumber CodeMirror-gutter-elt" style="left: 0px; width: 23px;"><font style="vertical-align: inherit;"><font style="vertical-align: inherit;"><br />
                6<br />
              </font></font></div>
</div>
<pre class="CodeMirror-line"><span style="padding-right: 0.1px;"><span class="cm-tab">    </span>{</span></pre>
</div>
<div style="position: relative;">
<div class="CodeMirror-gutter-wrapper" style="left: -31px;">
<div class="CodeMirror-linenumber CodeMirror-gutter-elt" style="left: 0px; width: 23px;"><font style="vertical-align: inherit;"><font style="vertical-align: inherit;"><br />
                7<br />
              </font></font></div>
</div>
<pre class="CodeMirror-line"><span style="padding-right: 0.1px;"><span class="cm-tab">    </span><span class="cm-tab">    </span><span class="cm-variable">SqlConnection</span> <span class="cm-variable">con</span> <span class="cm-operator">=</span> <span class="cm-keyword">new</span> <span class="cm-variable">SqlConnection</span>(<span class="cm-string">"put your connection string here"</span>);</span></pre>
</div>
<div style="position: relative;">
<div class="CodeMirror-gutter-wrapper" style="left: -31px;">
<div class="CodeMirror-linenumber CodeMirror-gutter-elt" style="left: 0px; width: 23px;"><font style="vertical-align: inherit;"><font style="vertical-align: inherit;"><br />
                8<br />
              </font></font></div>
</div>
<pre class="CodeMirror-line"><span style="padding-right: 0.1px;"><span class="cm-tab">    </span><span class="cm-tab">    </span><span class="cm-keyword">public</span> <span class="cm-type">string</span> <span class="cm-variable">AddEmployeeRecord</span>(<span class="cm-variable">EmployeeEntities</span> <span class="cm-variable">employeeEntities</span>)</span></pre>
</div>
<div style="position: relative;">
<div class="CodeMirror-gutter-wrapper" style="left: -31px;">
<div class="CodeMirror-linenumber CodeMirror-gutter-elt" style="left: 0px; width: 23px;"><font style="vertical-align: inherit;"><font style="vertical-align: inherit;"><br />
                9<br />
              </font></font></div>
</div>
<pre class="CodeMirror-line"><span style="padding-right: 0.1px;"><span class="cm-tab">    </span><span class="cm-tab">    </span>{</span></pre>
</div>
<div style="position: relative;">
<div class="CodeMirror-gutter-wrapper" style="left: -31px;">
<div class="CodeMirror-linenumber CodeMirror-gutter-elt" style="left: 0px; width: 23px;"><font style="vertical-align: inherit;"><font style="vertical-align: inherit;"><br />
                10<br />
              </font></font></div>
</div>
<pre class="CodeMirror-line"><span style="padding-right: 0.1px;"><span class="cm-tab">    </span><span class="cm-tab">    </span><span class="cm-tab">    </span><span class="cm-keyword">try</span></span></pre>
</div>
<div style="position: relative;">
<div class="CodeMirror-gutter-wrapper" style="left: -31px;">
<div class="CodeMirror-linenumber CodeMirror-gutter-elt" style="left: 0px; width: 23px;"><font style="vertical-align: inherit;"><font style="vertical-align: inherit;"><br />
                11<br />
              </font></font></div>
</div>
<pre class="CodeMirror-line"><span style="padding-right: 0.1px;"><span class="cm-tab">    </span><span class="cm-tab">    </span><span class="cm-tab">    </span>{</span></pre>
</div>
<div style="position: relative;">
<div class="CodeMirror-gutter-wrapper" style="left: -31px;">
<div class="CodeMirror-linenumber CodeMirror-gutter-elt" style="left: 0px; width: 23px;"><font style="vertical-align: inherit;"><font style="vertical-align: inherit;"><br />
                12<br />
              </font></font></div>
</div>
<pre class="CodeMirror-line"><span style="padding-right: 0.1px;"><span class="cm-tab">    </span><span class="cm-tab">    </span><span class="cm-tab">    </span><span class="cm-tab">    </span><span class="cm-variable">SqlCommand</span> <span class="cm-variable">cmd</span> <span class="cm-operator">=</span> <span class="cm-keyword">new</span> <span class="cm-variable">SqlCommand</span>(<span class="cm-string">"sp_Employee_Add"</span>, <span class="cm-variable">con</span>);</span></pre>
</div>
<div style="position: relative;">
<div class="CodeMirror-gutter-wrapper" style="left: -31px;">
<div class="CodeMirror-linenumber CodeMirror-gutter-elt" style="left: 0px; width: 23px;"><font style="vertical-align: inherit;"><font style="vertical-align: inherit;"><br />
                13<br />
              </font></font></div>
</div>
<pre class="CodeMirror-line"><span style="padding-right: 0.1px;"><span class="cm-tab">    </span><span class="cm-tab">    </span><span class="cm-tab">    </span><span class="cm-tab">    </span><span class="cm-variable">cmd</span>.<span class="cm-variable">CommandType</span> <span class="cm-operator">=</span> <span class="cm-variable">CommandType</span>.<span class="cm-variable">StoredProcedure</span>;</span></pre>
</div>
<div style="position: relative;">
<div class="CodeMirror-gutter-wrapper" style="left: -31px;">
<div class="CodeMirror-linenumber CodeMirror-gutter-elt" style="left: 0px; width: 23px;"><font style="vertical-align: inherit;"><font style="vertical-align: inherit;"><br />
                14<br />
              </font></font></div>
</div>
<pre class="CodeMirror-line"><span style="padding-right: 0.1px;"><span class="cm-tab">    </span><span class="cm-tab">    </span><span class="cm-tab">    </span><span class="cm-tab">    </span><span class="cm-variable">cmd</span>.<span class="cm-variable">Parameters</span>.<span class="cm-variable">AddWithValue</span>(<span class="cm-string">"@Emp_Name"</span>,</span></pre>
</div>
<div style="position: relative;">
<div class="CodeMirror-gutter-wrapper" style="left: -31px;">
<div class="CodeMirror-linenumber CodeMirror-gutter-elt" style="left: 0px; width: 23px;"><font style="vertical-align: inherit;"><font style="vertical-align: inherit;"><br />
                15<br />
              </font></font></div>
</div>
<pre class="CodeMirror-line"><span style="padding-right: 0.1px;">                                            <span class="cm-variable">employeeEntities</span>.<span class="cm-variable">Emp_Name</span>);</span></pre>
</div>
<div style="position: relative;">
<div class="CodeMirror-gutter-wrapper" style="left: -31px;">
<div class="CodeMirror-linenumber CodeMirror-gutter-elt" style="left: 0px; width: 23px;"><font style="vertical-align: inherit;"><font style="vertical-align: inherit;"><br />
                16<br />
              </font></font></div>
</div>
<pre class="CodeMirror-line"><span style="padding-right: 0.1px;"><span class="cm-tab">    </span><span class="cm-tab">    </span><span class="cm-tab">    </span><span class="cm-tab">    </span><span class="cm-variable">cmd</span>.<span class="cm-variable">Parameters</span>.<span class="cm-variable">AddWithValue</span>(<span class="cm-string">"@City"</span>, <span class="cm-variable">employeeEntities</span>.<span class="cm-variable">City</span>);</span></pre>
</div>
<div style="position: relative;">
<div class="CodeMirror-gutter-wrapper" style="left: -31px;">
<div class="CodeMirror-linenumber CodeMirror-gutter-elt" style="left: 0px; width: 23px;"><font style="vertical-align: inherit;"><font style="vertical-align: inherit;"><br />
                17<br />
              </font></font></div>
</div>
<pre class="CodeMirror-line"><span style="padding-right: 0.1px;"><span class="cm-tab">    </span><span class="cm-tab">    </span><span class="cm-tab">    </span><span class="cm-tab">    </span><span class="cm-variable">cmd</span>.<span class="cm-variable">Parameters</span>.<span class="cm-variable">AddWithValue</span>(<span class="cm-string">"@State"</span>, <span class="cm-variable">employeeEntities</span>.<span class="cm-variable">State</span>);</span></pre>
</div>
<div style="position: relative;">
<div class="CodeMirror-gutter-wrapper" style="left: -31px;">
<div class="CodeMirror-linenumber CodeMirror-gutter-elt" style="left: 0px; width: 23px;"><font style="vertical-align: inherit;"><font style="vertical-align: inherit;"><br />
                18<br />
              </font></font></div>
</div>
<pre class="CodeMirror-line"><span style="padding-right: 0.1px;"><span class="cm-tab">    </span><span class="cm-tab">    </span><span class="cm-tab">    </span><span class="cm-tab">    </span><span class="cm-variable">cmd</span>.<span class="cm-variable">Parameters</span>.<span class="cm-variable">AddWithValue</span>(<span class="cm-string">"@Country"</span>,</span></pre>
</div>
<div style="position: relative;">
<div class="CodeMirror-gutter-wrapper" style="left: -31px;">
<div class="CodeMirror-linenumber CodeMirror-gutter-elt" style="left: 0px; width: 23px;"><font style="vertical-align: inherit;"><font style="vertical-align: inherit;"><br />
                19<br />
              </font></font></div>
</div>
<pre class="CodeMirror-line"><span style="padding-right: 0.1px;">                                            <span class="cm-variable">employeeEntities</span>.<span class="cm-variable">Country</span>);</span></pre>
</div>
<div style="position: relative;">
<div class="CodeMirror-gutter-wrapper" style="left: -31px;">
<div class="CodeMirror-linenumber CodeMirror-gutter-elt" style="left: 0px; width: 23px;"><font style="vertical-align: inherit;"><font style="vertical-align: inherit;"><br />
                20<br />
              </font></font></div>
</div>
<pre class="CodeMirror-line"><span style="padding-right: 0.1px;"><span class="cm-tab">    </span><span class="cm-tab">    </span><span class="cm-tab">    </span><span class="cm-tab">    </span><span class="cm-variable">cmd</span>.<span class="cm-variable">Parameters</span>.<span class="cm-variable">AddWithValue</span>(<span class="cm-string">"@Department"</span>,</span></pre>
</div>
<div style="position: relative;">
<div class="CodeMirror-gutter-wrapper" style="left: -31px;">
<div class="CodeMirror-linenumber CodeMirror-gutter-elt" style="left: 0px; width: 23px;"><font style="vertical-align: inherit;"><font style="vertical-align: inherit;"><br />
                21<br />
              </font></font></div>
</div>
<pre class="CodeMirror-line"><span style="padding-right: 0.1px;">                                            <span class="cm-variable">employeeEntities</span>.<span class="cm-variable">Department</span>);</span></pre>
</div>
<div style="position: relative;">
<div class="CodeMirror-gutter-wrapper" style="left: -31px;">
<div class="CodeMirror-linenumber CodeMirror-gutter-elt" style="left: 0px; width: 23px;"><font style="vertical-align: inherit;"><font style="vertical-align: inherit;"><br />
                22<br />
              </font></font></div>
</div>
<pre class="CodeMirror-line"/></div> 
            <div style="position: relative;"> 
             <div class="CodeMirror-gutter-wrapper" style="left: -31px;"> 
              <div class="CodeMirror-linenumber CodeMirror-gutter-elt" style="left: 0px; width: 23px;"><font style="vertical-align: inherit;"><font style="vertical-align: inherit;">
                23 
              </font></font></div> 
             </div> 
             <pre class="CodeMirror-line"><span style="padding-right: 0.1px;">              <span class="cm-tab">  </span><span class="cm-variable">con</span>.<span class="cm-variable">Open</span>();</span></pre>
</div>
<div style="position: relative;">
<div class="CodeMirror-gutter-wrapper" style="left: -31px;">
<div class="CodeMirror-linenumber CodeMirror-gutter-elt" style="left: 0px; width: 23px;"><font style="vertical-align: inherit;"><font style="vertical-align: inherit;"><br />
                24<br />
              </font></font></div>
</div>
<pre class="CodeMirror-line"><span style="padding-right: 0.1px;"><span class="cm-tab">    </span><span class="cm-tab">    </span><span class="cm-tab">    </span><span class="cm-tab">    </span><span class="cm-variable">cmd</span>.<span class="cm-variable">ExecuteNonQuery</span>();</span></pre>
</div>
<div style="position: relative;">
<div class="CodeMirror-gutter-wrapper" style="left: -31px;">
<div class="CodeMirror-linenumber CodeMirror-gutter-elt" style="left: 0px; width: 23px;"><font style="vertical-align: inherit;"><font style="vertical-align: inherit;"><br />
                25<br />
              </font></font></div>
</div>
<pre class="CodeMirror-line"><span style="padding-right: 0.1px;"><span class="cm-tab">    </span><span class="cm-tab">    </span><span class="cm-tab">    </span><span class="cm-tab">    </span><span class="cm-variable">con</span>.<span class="cm-variable">Close</span>();</span></pre>
</div>
<div style="position: relative;">
<div class="CodeMirror-gutter-wrapper" style="left: -31px;">
<div class="CodeMirror-linenumber CodeMirror-gutter-elt" style="left: 0px; width: 23px;"><font style="vertical-align: inherit;"><font style="vertical-align: inherit;"><br />
                26<br />
              </font></font></div>
</div>
<pre class="CodeMirror-line"/></div> 
            <div style="position: relative;"> 
             <div class="CodeMirror-gutter-wrapper" style="left: -31px;"> 
              <div class="CodeMirror-linenumber CodeMirror-gutter-elt" style="left: 0px; width: 23px;"><font style="vertical-align: inherit;"><font style="vertical-align: inherit;">
                27 
              </font></font></div> 
             </div> 
             <pre class="CodeMirror-line"><span style="padding-right: 0.1px;">              <span class="cm-tab">  </span><span class="cm-keyword">return</span> (<span class="cm-string">"Data save Successfully"</span>);</span></pre>
</div>
<div style="position: relative;">
<div class="CodeMirror-gutter-wrapper" style="left: -31px;">
<div class="CodeMirror-linenumber CodeMirror-gutter-elt" style="left: 0px; width: 23px;"><font style="vertical-align: inherit;"><font style="vertical-align: inherit;"><br />
                28<br />
              </font></font></div>
</div>
<pre class="CodeMirror-line"><span style="padding-right: 0.1px;"><span class="cm-tab">    </span><span class="cm-tab">    </span><span class="cm-tab">    </span>}</span></pre>
</div>
<div style="position: relative;">
<div class="CodeMirror-gutter-wrapper" style="left: -31px;">
<div class="CodeMirror-linenumber CodeMirror-gutter-elt" style="left: 0px; width: 23px;"><font style="vertical-align: inherit;"><font style="vertical-align: inherit;"><br />
                29<br />
              </font></font></div>
</div>
<pre class="CodeMirror-line"><span style="padding-right: 0.1px;"><span class="cm-tab">    </span><span class="cm-tab">    </span><span class="cm-tab">    </span><span class="cm-keyword">catch</span> (<span class="cm-variable">Exception</span> <span class="cm-variable">ex</span>)</span></pre>
</div>
<div style="position: relative;">
<div class="CodeMirror-gutter-wrapper" style="left: -31px;">
<div class="CodeMirror-linenumber CodeMirror-gutter-elt" style="left: 0px; width: 23px;"><font style="vertical-align: inherit;"><font style="vertical-align: inherit;"><br />
                30<br />
              </font></font></div>
</div>
<pre class="CodeMirror-line"><span style="padding-right: 0.1px;"><span class="cm-tab">    </span><span class="cm-tab">    </span><span class="cm-tab">    </span>{</span></pre>
</div>
<div style="position: relative;">
<div class="CodeMirror-gutter-wrapper" style="left: -31px;">
<div class="CodeMirror-linenumber CodeMirror-gutter-elt" style="left: 0px; width: 23px;"><font style="vertical-align: inherit;"><font style="vertical-align: inherit;"><br />
                31<br />
              </font></font></div>
</div>
<pre class="CodeMirror-line"><span style="padding-right: 0.1px;"><span class="cm-tab">    </span><span class="cm-tab">    </span><span class="cm-tab">    </span><span class="cm-tab">    </span><span class="cm-keyword">if</span> (<span class="cm-variable">con</span>.<span class="cm-variable">State</span> <span class="cm-operator">==</span> <span class="cm-variable">ConnectionState</span>.<span class="cm-variable">Open</span>)</span></pre>
</div>
<div style="position: relative;">
<div class="CodeMirror-gutter-wrapper" style="left: -31px;">
<div class="CodeMirror-linenumber CodeMirror-gutter-elt" style="left: 0px; width: 23px;"><font style="vertical-align: inherit;"><font style="vertical-align: inherit;"><br />
                32<br />
              </font></font></div>
</div>
<pre class="CodeMirror-line"><span style="padding-right: 0.1px;"><span class="cm-tab">    </span><span class="cm-tab">    </span><span class="cm-tab">    </span><span class="cm-tab">    </span>{</span></pre>
</div>
<div style="position: relative;">
<div class="CodeMirror-gutter-wrapper" style="left: -31px;">
<div class="CodeMirror-linenumber CodeMirror-gutter-elt" style="left: 0px; width: 23px;"><font style="vertical-align: inherit;"><font style="vertical-align: inherit;"><br />
                33<br />
              </font></font></div>
</div>
<pre class="CodeMirror-line"><span style="padding-right: 0.1px;"><span class="cm-tab">    </span><span class="cm-tab">    </span><span class="cm-tab">    </span><span class="cm-tab">    </span><span class="cm-tab">    </span><span class="cm-variable">con</span>.<span class="cm-variable">Close</span>();</span></pre>
</div>
<div style="position: relative;">
<div class="CodeMirror-gutter-wrapper" style="left: -31px;">
<div class="CodeMirror-linenumber CodeMirror-gutter-elt" style="left: 0px; width: 23px;"><font style="vertical-align: inherit;"><font style="vertical-align: inherit;"><br />
                34<br />
              </font></font></div>
</div>
<pre class="CodeMirror-line"><span style="padding-right: 0.1px;"><span class="cm-tab">    </span><span class="cm-tab">    </span><span class="cm-tab">    </span><span class="cm-tab">    </span>}</span></pre>
</div>
<div style="position: relative;">
<div class="CodeMirror-gutter-wrapper" style="left: -31px;">
<div class="CodeMirror-linenumber CodeMirror-gutter-elt" style="left: 0px; width: 23px;"><font style="vertical-align: inherit;"><font style="vertical-align: inherit;"><br />
                35<br />
              </font></font></div>
</div>
<pre class="CodeMirror-line"/></div> 
            <div style="position: relative;"> 
             <div class="CodeMirror-gutter-wrapper" style="left: -31px;"> 
              <div class="CodeMirror-linenumber CodeMirror-gutter-elt" style="left: 0px; width: 23px;"><font style="vertical-align: inherit;"><font style="vertical-align: inherit;">
                36 
              </font></font></div> 
             </div> 
             <pre class="CodeMirror-line"><span style="padding-right: 0.1px;">              <span class="cm-tab">  </span><span class="cm-keyword">return</span> (<span class="cm-variable">ex</span>.<span class="cm-variable">Message</span>.<span class="cm-variable">ToString</span>());</span></pre>
</div>
<div style="position: relative;">
<div class="CodeMirror-gutter-wrapper" style="left: -31px;">
<div class="CodeMirror-linenumber CodeMirror-gutter-elt" style="left: 0px; width: 23px;"><font style="vertical-align: inherit;"><font style="vertical-align: inherit;"><br />
                37<br />
              </font></font></div>
</div>
<pre class="CodeMirror-line"><span style="padding-right: 0.1px;"><span class="cm-tab">    </span><span class="cm-tab">    </span><span class="cm-tab">    </span>}</span></pre>
</div>
<div style="position: relative;">
<div class="CodeMirror-gutter-wrapper" style="left: -31px;">
<div class="CodeMirror-linenumber CodeMirror-gutter-elt" style="left: 0px; width: 23px;"><font style="vertical-align: inherit;"><font style="vertical-align: inherit;"><br />
                38<br />
              </font></font></div>
</div>
<pre class="CodeMirror-line"><span style="padding-right: 0.1px;"><span class="cm-tab">    </span><span class="cm-tab">    </span>}</span></pre>
</div>
<div style="position: relative;">
<div class="CodeMirror-gutter-wrapper" style="left: -31px;">
<div class="CodeMirror-linenumber CodeMirror-gutter-elt" style="left: 0px; width: 23px;"><font style="vertical-align: inherit;"><font style="vertical-align: inherit;"><br />
                39<br />
              </font></font></div>
</div>
<pre class="CodeMirror-line"><span style="padding-right: 0.1px;"><span class="cm-tab">    </span>}</span></pre>
</div>
<div style="position: relative;">
<div class="CodeMirror-gutter-wrapper" style="left: -31px;">
<div class="CodeMirror-linenumber CodeMirror-gutter-elt" style="left: 0px; width: 23px;"><font style="vertical-align: inherit;"><font style="vertical-align: inherit;"><br />
                40<br />
              </font></font></div>
</div>
<pre class="CodeMirror-line"><span style="padding-right: 0.1px;">}</span></pre>
</div>
</div>
</div>
</div>
</div>
</div>
<div style="position: absolute; height: 15px; width: 1px; border-bottom: 0px solid transparent; top: 951px;">
        <br /> 
       </div>
<div class="CodeMirror-gutters" style="height: 966px; left: 0px;">
<div class="CodeMirror-gutter CodeMirror-linenumbers" style="width: 31px;">
         <br /> 
        </div>
</div>
</div>
</div>
</div>
</div>
</div>
</li>
</ol>
<h3><strong><span><font style="vertical-align: inherit;"><font style="vertical-align: inherit;">Шаг 5 - Сборка</font></font></span></strong></h3>
<p><font style="vertical-align: inherit;"><font style="vertical-align: inherit;">Создайте свой проект, нажав F5 или выбрав пункт меню Build в Visual Studio. </font></font></p>
<h3><strong><span><font style="vertical-align: inherit;"><font style="vertical-align: inherit;">Шаг 6 - Использование проекта библиотеки классов</font></font></span></strong></h3>
<p><font style="vertical-align: inherit;"><font style="vertical-align: inherit;">Здесь я использую проект библиотеки классов в приложении ASP.NET Core 2.1 MVC. </font><font style="vertical-align: inherit;">Сначала мы создадим приложение ASP.NET Core 2.1 MVC.</font></font></p>
<p><font style="vertical-align: inherit;"><font style="vertical-align: inherit;">Откройте Visual Studio и выберите </font></font><strong><font style="vertical-align: inherit;"><font style="vertical-align: inherit;">Файл -> Создать -> Проект</font></font></strong><font style="vertical-align: inherit;"><font style="vertical-align: inherit;"> .</font></font></p>
<p><font style="vertical-align: inherit;"><font style="vertical-align: inherit;">После выбора проекта </font><font style="vertical-align: inherit;">откроется диалоговое окно « </font></font><strong><font style="vertical-align: inherit;"><font style="vertical-align: inherit;">Новый проект</font></font></strong><font style="vertical-align: inherit;"><font style="vertical-align: inherit;"> ». </font><font style="vertical-align: inherit;">Выберите </font></font><strong><font style="vertical-align: inherit;"><font style="vertical-align: inherit;">.NET Core</font></font></strong><font style="vertical-align: inherit;"><font style="vertical-align: inherit;"> в меню Visual C # на левой боковой панели.</font></font></p>
<p><font style="vertical-align: inherit;"><font style="vertical-align: inherit;">Затем выберите </font></font><strong><font style="vertical-align: inherit;"><font style="vertical-align: inherit;">веб-приложение ASP.NET Core</font></font></strong><font style="vertical-align: inherit;"><font style="vertical-align: inherit;"> из доступных шаблонов проектов. </font><font style="vertical-align: inherit;">Дайте название проекту « </font></font><em><span><font style="vertical-align: inherit;"><font style="vertical-align: inherit;">ChittaWeb</font></font></span></em><font style="vertical-align: inherit;"><font style="vertical-align: inherit;"> » и нажмите </font></font><strong><font style="vertical-align: inherit;"><font style="vertical-align: inherit;">ОК</font></font></strong><font style="vertical-align: inherit;"><font style="vertical-align: inherit;"> .</font></font></p>
<p><font style="vertical-align: inherit;"><font style="vertical-align: inherit;">После нажатия на </font><font style="vertical-align: inherit;">кнопку </font></font><strong><font style="vertical-align: inherit;"><font style="vertical-align: inherit;">ОК</font></font></strong><font style="vertical-align: inherit;"><font style="vertical-align: inherit;"> откроется новое диалоговое окно для выбора шаблона проекта. </font><font style="vertical-align: inherit;">Вы можете увидеть два раскрывающихся меню в левом верхнем углу окна шаблона. </font><font style="vertical-align: inherit;">Затем выберите </font></font><strong><font style="vertical-align: inherit;"><font style="vertical-align: inherit;">.NET Core</font></font></strong><font style="vertical-align: inherit;"><font style="vertical-align: inherit;"> и </font></font><strong><font style="vertical-align: inherit;"><font style="vertical-align: inherit;">ASP.NET Core 2.1</font></font></strong><font style="vertical-align: inherit;"><font style="vertical-align: inherit;"> из этих выпадающих списков. </font><font style="vertical-align: inherit;">Выберите </font><font style="vertical-align: inherit;">шаблон </font></font><strong><font style="vertical-align: inherit;"><font style="vertical-align: inherit;">веб-приложения (Model-View-Controller)</font></font></strong><font style="vertical-align: inherit;"><font style="vertical-align: inherit;"> и нажмите </font></font><strong><font style="vertical-align: inherit;"><font style="vertical-align: inherit;">OK,</font></font></strong><font style="vertical-align: inherit;"><font style="vertical-align: inherit;"> чтобы создать проект ASP.NET Core MVC. </font><font style="vertical-align: inherit;">Затем выберите галочку для настройки HTTPS.</font></font></p>
<p><font style="vertical-align: inherit;"><font style="vertical-align: inherit;">В Solution «Chittaranjan» содержит два проекта; </font><font style="vertical-align: inherit;">Первый проект - «ЧиттаБ». </font><font style="vertical-align: inherit;">Это проект библиотеки классов. </font><font style="vertical-align: inherit;">Второе название проекта - «ChittaWeb». </font><font style="vertical-align: inherit;">Это приложение ASP.NET Core 2.1 MVC. </font><font style="vertical-align: inherit;">Теперь наше приложение ASP.NET Core MVC создано.</font></font></p>
<p><font style="vertical-align: inherit;"><font style="vertical-align: inherit;">Теперь мы можем использовать функциональность библиотеки классов .NET Core 2.1 в приложении ASP.NET Core 2.1 MVC.</font></font></p>
<h3><strong><span><font style="vertical-align: inherit;"><font style="vertical-align: inherit;">Шаг 1 - Добавить ссылку на проект библиотеки классов</font></font></span></strong> </h3>
<p><font style="vertical-align: inherit;"><font style="vertical-align: inherit;">Чтобы использовать проект библиотеки классов в своем приложении, сначала необходимо добавить ссылку на проект библиотеки классов, чтобы получить доступ к его функциям. </font><font style="vertical-align: inherit;">Щелкните правой кнопкой мыши на зависимостях приложения ASP.NET Core MVC «ChittaWeb» в обозревателе решений и выберите опцию «  </font></font><strong><font style="vertical-align: inherit;"><font style="vertical-align: inherit;">Добавить -> Ссылка»</font></font></strong><font style="vertical-align: inherit;"><font style="vertical-align: inherit;"> .</font></font></p>
<p><font style="vertical-align: inherit;"><font style="vertical-align: inherit;">На следующем экране вы увидите, что ChittaDB уже доступен. </font><font style="vertical-align: inherit;">Выберите ChittaDB и затем нажмите  </font><font style="vertical-align: inherit;">кнопку </font></font><strong><font style="vertical-align: inherit;"><font style="vertical-align: inherit;">ОК</font></font></strong><font style="vertical-align: inherit;"><font style="vertical-align: inherit;"> .</font></font></p>
<h3> <strong><span><font style="vertical-align: inherit;"><font style="vertical-align: inherit;">Шаг 2 - Импорт пространства имен и функций вызова</font></font></span></strong></h3>
<p><font style="vertical-align: inherit;"><font style="vertical-align: inherit;">Сначала добавьте контроллер в основное приложение MVC Asp.Net, затем используйте пространство имен Import и вызовите функции.</font></font></p>
<p><font style="vertical-align: inherit;"><font style="vertical-align: inherit;">Щелкните правой кнопкой мыши </font><font style="vertical-align: inherit;">папку « </font></font><strong><font style="vertical-align: inherit;"><font style="vertical-align: inherit;">Контроллеры</font></font></strong><font style="vertical-align: inherit;"><font style="vertical-align: inherit;"> » и выберите « </font></font><strong><font style="vertical-align: inherit;"><font style="vertical-align: inherit;">Добавить новый элемент»</font></font></strong><font style="vertical-align: inherit;"><font style="vertical-align: inherit;"> .</font></font></p>
<p><font style="vertical-align: inherit;"/><strong><font style="vertical-align: inherit;"><font style="vertical-align: inherit;">New Item Добавить</font></font></strong><font style="vertical-align: inherit;"><font style="vertical-align: inherit;"> откроется диалоговое окно. </font><font style="vertical-align: inherit;">Выберите </font></font><strong><font style="vertical-align: inherit;"><font style="vertical-align: inherit;">ASP.NET Core</font></font></strong><font style="vertical-align: inherit;"><font style="vertical-align: inherit;"> на левой панели; </font><font style="vertical-align: inherit;">затем выберите </font></font><strong><font style="vertical-align: inherit;"><font style="vertical-align: inherit;">Controller Class</font></font></strong><font style="vertical-align: inherit;"><font style="vertical-align: inherit;"> на панели шаблонов и введите make </font></font><strong><font style="vertical-align: inherit;"><font style="vertical-align: inherit;">EmployeeController.cs</font></font></strong><font style="vertical-align: inherit;"><font style="vertical-align: inherit;"> . </font><font style="vertical-align: inherit;">Затем нажмите </font></font><strong><font style="vertical-align: inherit;"><font style="vertical-align: inherit;">Добавить</font></font></strong><font style="vertical-align: inherit;"><font style="vertical-align: inherit;"> .</font></font></p>
<p><font style="vertical-align: inherit;"><font style="vertical-align: inherit;">В </font></font><strong><font style="vertical-align: inherit;"><font style="vertical-align: inherit;">Employeecontroller</font></font></strong><font style="vertical-align: inherit;"><font style="vertical-align: inherit;"> я импортирую пространство имен ChittaDB.</font></font></p>
<h4><strong><span><font style="vertical-align: inherit;"><font style="vertical-align: inherit;">Импортировать пространство имен</font></font></span></strong></h4>
<p><font style="vertical-align: inherit;"><font style="vertical-align: inherit;">Прежде чем вы сможете использовать проект библиотеки классов и его классы, вы должны импортировать пространство имен, используя следующий код.</font></font></p>
<p><code>using ChittaDB;</code><span id="_tmp_pre_1"> </span></p>
<p><font style="vertical-align: inherit;"><font style="vertical-align: inherit;">Если ваша ссылка на проект библиотеки классов добавлена ​​правильно, как только вы начнете печатать «используя Chitt ..», вы увидите, что Visual Studio Intellisense загрузит пространство имен в списке.</font></font></p>
<h4> <strong><span><font style="vertical-align: inherit;"><font style="vertical-align: inherit;">Функции вызова</font></font></span></strong></h4>
<p><font style="vertical-align: inherit;"><font style="vertical-align: inherit;">После добавления ссылки все классы, методы и открытые члены проекта библиотеки классов должны быть доступны в приложении ASP.NET Core MVC. </font><font style="vertical-align: inherit;">Теперь мы можем вызвать все методы в </font></font><strong><font style="vertical-align: inherit;"><font style="vertical-align: inherit;">контроллере</font></font></strong><font style="vertical-align: inherit;"><font style="vertical-align: inherit;"> .</font></font></p>
<p><font style="vertical-align: inherit;"><font style="vertical-align: inherit;">Здесь я назову все классы и функции из проекта библиотеки классов. </font><font style="vertical-align: inherit;">Мы поместим нашу бизнес-логику в этот контроллер.</font></font></p>
<p><font style="vertical-align: inherit;"><font style="vertical-align: inherit;">Для обработки операций с базой данных мы создадим объект </font><font style="vertical-align: inherit;">класса </font></font><strong><font style="vertical-align: inherit;"><font style="vertical-align: inherit;">EmployeeDBAccessLayer</font></font></strong><font style="vertical-align: inherit;"><font style="vertical-align: inherit;"> внутри </font><font style="vertical-align: inherit;">класса </font></font><strong><font style="vertical-align: inherit;"><font style="vertical-align: inherit;">EmployeeController</font></font></strong><font style="vertical-align: inherit;"><font style="vertical-align: inherit;"> .</font></font></p>
<ol start="1">
<div class="codeMirror-wrapper">
<div contenteditable="false">
<div class="codeHeader">
<div class="nameLanguage"><font style="vertical-align: inherit;"><font style="vertical-align: inherit;"><br />
      C #<br />
    </font></font></div>
<p>    <i class="icon-cancel-circled-1 cm-remove"> </i>
   </p>
</div>
<div class="codeMirror-code--wrapper" data-code="using Microsoft.AspNetCore.Mvc;
using ChittaDB;
namespace ChittaWeb.Controllers
	{
		public class EmployeeController : Controller
		{
			EmployeeDBAccessLayer empdb = new EmployeeDBAccessLayer();" data-lang="text/x-csharp">
<div class="CodeMirror cm-s-default CodeMirror-wrap">
<div style="overflow: hidden; position: relative; width: 3px; height: 0px; top: 143px; left: 146.906px;">
      <textarea spellcheck="false" tabindex="0" style="position: absolute; bottom: -1em; padding: 0px; width: 1000px; height: 1em; outline: none;" value=""/>
     </div>
<div class="CodeMirror-vscrollbar">
<div style="min-width: 1px; height: 0px;">
       <br /> 
      </div>
</div>
<div class="CodeMirror-hscrollbar">
<div style="height: 100%; min-height: 1px; width: 0px;">
       <br /> 
      </div>
</div>
<div class="CodeMirror-scrollbar-filler">
      <br /> 
     </div>
<div class="CodeMirror-gutter-filler">
      <br /> 
     </div>
<div class="CodeMirror-scroll" tabindex="-1">
<div class="CodeMirror-sizer" style="margin-left: 31px; margin-bottom: -15px; border-right-width: 15px; min-height: 169px; padding-right: 0px; padding-bottom: 0px;">
<div style="position: relative; top: 0px;">
<div class="CodeMirror-lines">
<div style="position: relative; outline: none;">
<div class="CodeMirror-measure">
<pre>x</pre>
</div>
<div class="CodeMirror-measure">
           <br /> 
          </div>
<div style="position: relative; z-index: 1;">
           <br /> 
          </div>
<div class="CodeMirror-cursors">
<div class="CodeMirror-cursor" style="left: 114.906px; top: 138px; height: 23px;">
              
           </div>
</div>
<div class="CodeMirror-code">
<div style="position: relative;">
<div class="CodeMirror-gutter-wrapper" style="left: -31px;">
<div class="CodeMirror-linenumber CodeMirror-gutter-elt" style="left: 0px; width: 23px;"><font style="vertical-align: inherit;"><font style="vertical-align: inherit;"><br />
               1<br />
             </font></font></div>
</div>
<pre class="CodeMirror-line"><span style="padding-right: 0.1px;"><span class="cm-keyword">using</span> <span class="cm-variable">Microsoft</span>.<span class="cm-variable">AspNetCore</span>.<span class="cm-variable">Mvc</span>;</span></pre>
</div>
<div style="position: relative;">
<div class="CodeMirror-gutter-wrapper" style="left: -31px;">
<div class="CodeMirror-linenumber CodeMirror-gutter-elt" style="left: 0px; width: 23px;"><font style="vertical-align: inherit;"><font style="vertical-align: inherit;"><br />
               2<br />
             </font></font></div>
</div>
<pre class="CodeMirror-line"><span style="padding-right: 0.1px;"><span class="cm-keyword">using</span> <span class="cm-variable">ChittaDB</span>;</span></pre>
</div>
<div style="position: relative;">
<div class="CodeMirror-gutter-wrapper" style="left: -31px;">
<div class="CodeMirror-linenumber CodeMirror-gutter-elt" style="left: 0px; width: 23px;"><font style="vertical-align: inherit;"><font style="vertical-align: inherit;"><br />
               3<br />
             </font></font></div>
</div>
<pre class="CodeMirror-line"><span style="padding-right: 0.1px;"><span class="cm-keyword">namespace</span> <span class="cm-def">ChittaWeb</span>.<span class="cm-variable">Controllers</span></span></pre>
</div>
<div style="position: relative;">
<div class="CodeMirror-gutter-wrapper" style="left: -31px;">
<div class="CodeMirror-linenumber CodeMirror-gutter-elt" style="left: 0px; width: 23px;"><font style="vertical-align: inherit;"><font style="vertical-align: inherit;"><br />
               4<br />
             </font></font></div>
</div>
<pre class="CodeMirror-line"><span style="padding-right: 0.1px;"><span class="cm-tab">    </span>{</span></pre>
</div>
<div style="position: relative;">
<div class="CodeMirror-gutter-wrapper" style="left: -31px;">
<div class="CodeMirror-linenumber CodeMirror-gutter-elt" style="left: 0px; width: 23px;"><font style="vertical-align: inherit;"><font style="vertical-align: inherit;"><br />
               5<br />
             </font></font></div>
</div>
<pre class="CodeMirror-line"><span style="padding-right: 0.1px;"><span class="cm-tab">    </span><span class="cm-tab">    </span><span class="cm-keyword">public</span> <span class="cm-keyword">class</span> <span class="cm-def">EmployeeController</span> : <span class="cm-variable">Controller</span></span></pre>
</div>
<div style="position: relative;">
<div class="CodeMirror-gutter-wrapper" style="left: -31px;">
<div class="CodeMirror-linenumber CodeMirror-gutter-elt" style="left: 0px; width: 23px;"><font style="vertical-align: inherit;"><font style="vertical-align: inherit;"><br />
               6<br />
             </font></font></div>
</div>
<pre class="CodeMirror-line"><span style="padding-right: 0.1px;"><span class="cm-tab">    </span><span class="cm-tab">    </span>{</span></pre>
</div>
<div style="position: relative;">
<div class="CodeMirror-gutter-wrapper" style="left: -31px;">
<div class="CodeMirror-linenumber CodeMirror-gutter-elt" style="left: 0px; width: 23px;"><font style="vertical-align: inherit;"><font style="vertical-align: inherit;"><br />
               7<br />
             </font></font></div>
</div>
<pre class="CodeMirror-line"><span style="padding-right: 0.1px;"><span class="cm-tab">    </span><span class="cm-tab">    </span><span class="cm-tab">    </span><span class="cm-variable">EmployeeDBAccessLayer</span> <span class="cm-variable">empdb</span> <span class="cm-operator">=</span> <span class="cm-keyword">new</span> <span class="cm-variable">EmployeeDBAccessLayer</span>();</span></pre>
</div>
</div>
</div>
</div>
</div>
</div>
<div style="position: absolute; height: 15px; width: 1px; border-bottom: 0px solid transparent; top: 169px;">
       <br /> 
      </div>
<div class="CodeMirror-gutters" style="height: 184px; left: 0px;">
<div class="CodeMirror-gutter CodeMirror-linenumbers" style="width: 31px;">
       </div>
</div>
</div>
</div>
</div>
</div>
</div>
</ol>
<p><font style="vertical-align: inherit;"><font style="vertical-align: inherit;">Чтобы обработать бизнес-логику  </font></font><code>create</code><font style="vertical-align: inherit;"><font style="vertical-align: inherit;">операции, откройте </font></font><strong><font style="vertical-align: inherit;"><font style="vertical-align: inherit;">EmployeeController </font></font></strong><em><span><strong><font style="vertical-align: inherit;"><font style="vertical-align: inherit;">.cs</font></font></strong> </span></em><font style="vertical-align: inherit;"><font style="vertical-align: inherit;"> и добавьте в него следующий код:</font></font></p>
<ol start="1">
<div class="codeMirror-wrapper">
<div contenteditable="false">
<div class="codeHeader">
<div class="nameLanguage"><font style="vertical-align: inherit;"><font style="vertical-align: inherit;"><br />
      C #<br />
    </font></font></div>
<p>    <i class="icon-cancel-circled-1 cm-remove"> </i>
   </p>
</div>
<div class="codeMirror-code--wrapper" data-code="using Microsoft.AspNetCore.Mvc;
using ChittaDB;
namespace ChittaWeb.Controllers
{
	public class EmployeeController : Controller
	{
		EmployeeDBAccessLayer empdb = new EmployeeDBAccessLayer();
        
		[HttpGet]
		public IActionResult Create()
		{
			return View();
		}

		[HttpPost]
		public IActionResult Create([Bind] EmployeeEntities employeeEntities)
		{
			try
			{
				if (ModelState.IsValid)
				{
					string resp = empdb.AddEmployeeRecord(employeeEntities);
					TempData["msg"] = resp;
				}
			}
			catch (Exception ex)
			{
				TempData["msg"] = ex.Message;
			}
			
            return View();
		}
	}
}" data-lang="text/x-csharp">
<div class="CodeMirror cm-s-default CodeMirror-wrap">
<div style="overflow: hidden; position: relative; width: 3px; height: 0px; top: 260px; left: 72.9688px;">
      <textarea spellcheck="false" tabindex="0" style="position: absolute; bottom: -1em; padding: 0px; width: 1000px; height: 1em; outline: none;" value=""/>
     </div>
<div class="CodeMirror-vscrollbar" style="display: block; bottom: 0px;">
<div style="min-width: 1px; height: 790px;">
       <br /> 
      </div>
</div>
<div class="CodeMirror-hscrollbar">
<div style="height: 100%; min-height: 1px; width: 0px;">
       <br /> 
      </div>
</div>
<div class="CodeMirror-scrollbar-filler">
      <br /> 
     </div>
<div class="CodeMirror-gutter-filler">
      <br /> 
     </div>
<div class="CodeMirror-scroll" tabindex="-1">
<div class="CodeMirror-sizer" style="margin-left: 31px; margin-bottom: -15px; border-right-width: 15px; min-height: 790px; padding-right: 15px; padding-bottom: 0px;">
<div style="position: relative; top: 0px;">
<div class="CodeMirror-lines">
<div style="position: relative; outline: none;">
<div class="CodeMirror-measure">
<pre><span>xxxxxxxxxx</span></pre>
<div class="CodeMirror-linenumber CodeMirror-gutter-elt">
<div>
              1
            </div>
</div>
<div class="CodeMirror-linenumber CodeMirror-gutter-elt">
<div>
              31
            </div>
</div>
</div>
<div class="CodeMirror-measure">
           <br /> 
          </div>
<div style="position: relative; z-index: 1;">
           <br /> 
          </div>
<div class="CodeMirror-cursors" style="visibility: hidden;">
<div class="CodeMirror-cursor" style="left: 40.9688px; top: 736px; height: 23px;">
              
           </div>
</div>
<div class="CodeMirror-code">
<div style="position: relative;">
<div class="CodeMirror-gutter-wrapper" style="left: -31px;">
<div class="CodeMirror-linenumber CodeMirror-gutter-elt" style="left: 0px; width: 23px;"><font style="vertical-align: inherit;"><font style="vertical-align: inherit;"><br />
               1<br />
             </font></font></div>
</div>
<pre class="CodeMirror-line"><span style="padding-right: 0.1px;"><span class="cm-keyword">using</span> <span class="cm-variable">Microsoft</span>.<span class="cm-variable">AspNetCore</span>.<span class="cm-variable">Mvc</span>;</span></pre>
</div>
<div style="position: relative;">
<div class="CodeMirror-gutter-wrapper" style="left: -31px;">
<div class="CodeMirror-linenumber CodeMirror-gutter-elt" style="left: 0px; width: 23px;"><font style="vertical-align: inherit;"><font style="vertical-align: inherit;"><br />
               2<br />
             </font></font></div>
</div>
<pre class="CodeMirror-line"><span style="padding-right: 0.1px;"><span class="cm-keyword">using</span> <span class="cm-variable">ChittaDB</span>;</span></pre>
</div>
<div style="position: relative;">
<div class="CodeMirror-gutter-wrapper" style="left: -31px;">
<div class="CodeMirror-linenumber CodeMirror-gutter-elt" style="left: 0px; width: 23px;"><font style="vertical-align: inherit;"><font style="vertical-align: inherit;"><br />
               3<br />
             </font></font></div>
</div>
<pre class="CodeMirror-line"><span style="padding-right: 0.1px;"><span class="cm-keyword">namespace</span> <span class="cm-def">ChittaWeb</span>.<span class="cm-variable">Controllers</span></span></pre>
</div>
<div style="position: relative;">
<div class="CodeMirror-gutter-wrapper" style="left: -31px;">
<div class="CodeMirror-linenumber CodeMirror-gutter-elt" style="left: 0px; width: 23px;"><font style="vertical-align: inherit;"><font style="vertical-align: inherit;"><br />
               4<br />
             </font></font></div>
</div>
<pre class="CodeMirror-line"><span style="padding-right: 0.1px;">{</span></pre>
</div>
<div style="position: relative;">
<div class="CodeMirror-gutter-wrapper" style="left: -31px;">
<div class="CodeMirror-linenumber CodeMirror-gutter-elt" style="left: 0px; width: 23px;"><font style="vertical-align: inherit;"><font style="vertical-align: inherit;"><br />
               5<br />
             </font></font></div>
</div>
<pre class="CodeMirror-line"><span style="padding-right: 0.1px;"><span class="cm-tab">    </span><span class="cm-keyword">public</span> <span class="cm-keyword">class</span> <span class="cm-def">EmployeeController</span> : <span class="cm-variable">Controller</span></span></pre>
</div>
<div style="position: relative;">
<div class="CodeMirror-gutter-wrapper" style="left: -31px;">
<div class="CodeMirror-linenumber CodeMirror-gutter-elt" style="left: 0px; width: 23px;"><font style="vertical-align: inherit;"><font style="vertical-align: inherit;"><br />
               6<br />
             </font></font></div>
</div>
<pre class="CodeMirror-line"><span style="padding-right: 0.1px;"><span class="cm-tab">    </span>{</span></pre>
</div>
<div style="position: relative;">
<div class="CodeMirror-gutter-wrapper" style="left: -31px;">
<div class="CodeMirror-linenumber CodeMirror-gutter-elt" style="left: 0px; width: 23px;"><font style="vertical-align: inherit;"><font style="vertical-align: inherit;"><br />
               7<br />
             </font></font></div>
</div>
<pre class="CodeMirror-line"><span style="padding-right: 0.1px;"><span class="cm-tab">    </span><span class="cm-tab">    </span><span class="cm-variable">EmployeeDBAccessLayer</span> <span class="cm-variable">empdb</span> <span class="cm-operator">=</span> <span class="cm-keyword">new</span> <span class="cm-variable">EmployeeDBAccessLayer</span>();</span></pre>
</div>
<div style="position: relative;">
<div class="CodeMirror-gutter-wrapper" style="left: -31px;">
<div class="CodeMirror-linenumber CodeMirror-gutter-elt" style="left: 0px; width: 23px;"><font style="vertical-align: inherit;"><font style="vertical-align: inherit;"><br />
               8<br />
             </font></font></div>
</div>
<pre class="CodeMirror-line"><span style="padding-right: 0.1px;">        </span></pre>
</div>
<div style="position: relative;">
<div class="CodeMirror-gutter-wrapper" style="left: -31px;">
<div class="CodeMirror-linenumber CodeMirror-gutter-elt" style="left: 0px; width: 23px;"><font style="vertical-align: inherit;"><font style="vertical-align: inherit;"><br />
               9<br />
             </font></font></div>
</div>
<pre class="CodeMirror-line"><span style="padding-right: 0.1px;"><span class="cm-tab">    </span><span class="cm-tab">    </span>[<span class="cm-variable">HttpGet</span>]</span></pre>
</div>
<div style="position: relative;">
<div class="CodeMirror-gutter-wrapper" style="left: -31px;">
<div class="CodeMirror-linenumber CodeMirror-gutter-elt" style="left: 0px; width: 23px;"><font style="vertical-align: inherit;"><font style="vertical-align: inherit;"><br />
               10<br />
             </font></font></div>
</div>
<pre class="CodeMirror-line"><span style="padding-right: 0.1px;"><span class="cm-tab">    </span><span class="cm-tab">    </span><span class="cm-keyword">public</span> <span class="cm-variable">IActionResult</span> <span class="cm-variable">Create</span>()</span></pre>
</div>
<div style="position: relative;">
<div class="CodeMirror-gutter-wrapper" style="left: -31px;">
<div class="CodeMirror-linenumber CodeMirror-gutter-elt" style="left: 0px; width: 23px;"><font style="vertical-align: inherit;"><font style="vertical-align: inherit;"><br />
               11<br />
             </font></font></div>
</div>
<pre class="CodeMirror-line"><span style="padding-right: 0.1px;"><span class="cm-tab">    </span><span class="cm-tab">    </span>{</span></pre>
</div>
<div style="position: relative;">
<div class="CodeMirror-gutter-wrapper" style="left: -31px;">
<div class="CodeMirror-linenumber CodeMirror-gutter-elt" style="left: 0px; width: 23px;"><font style="vertical-align: inherit;"><font style="vertical-align: inherit;"><br />
               12<br />
             </font></font></div>
</div>
<pre class="CodeMirror-line"><span style="padding-right: 0.1px;"><span class="cm-tab">    </span><span class="cm-tab">    </span><span class="cm-tab">    </span><span class="cm-keyword">return</span> <span class="cm-variable">View</span>();</span></pre>
</div>
<div style="position: relative;">
<div class="CodeMirror-gutter-wrapper" style="left: -31px;">
<div class="CodeMirror-linenumber CodeMirror-gutter-elt" style="left: 0px; width: 23px;"><font style="vertical-align: inherit;"><font style="vertical-align: inherit;"><br />
               13<br />
             </font></font></div>
</div>
<pre class="CodeMirror-line"><span style="padding-right: 0.1px;"><span class="cm-tab">    </span><span class="cm-tab">    </span>}</span></pre>
</div>
<div style="position: relative;">
<div class="CodeMirror-gutter-wrapper" style="left: -31px;">
<div class="CodeMirror-linenumber CodeMirror-gutter-elt" style="left: 0px; width: 23px;"><font style="vertical-align: inherit;"><font style="vertical-align: inherit;"><br />
               14<br />
             </font></font></div>
</div>
<pre class="CodeMirror-line"/></div> 
           <div style="position: relative;"> 
            <div class="CodeMirror-gutter-wrapper" style="left: -31px;"> 
             <div class="CodeMirror-linenumber CodeMirror-gutter-elt" style="left: 0px; width: 23px;"><font style="vertical-align: inherit;"><font style="vertical-align: inherit;">
               15 
             </font></font></div> 
            </div> 
            <pre class="CodeMirror-line"><span style="padding-right: 0.1px;"><span class="cm-tab">    </span><span class="cm-tab">    </span>[<span class="cm-variable">HttpPost</span>]</span></pre>
</div>
<div style="position: relative;">
<div class="CodeMirror-gutter-wrapper" style="left: -31px;">
<div class="CodeMirror-linenumber CodeMirror-gutter-elt" style="left: 0px; width: 23px;"><font style="vertical-align: inherit;"><font style="vertical-align: inherit;"><br />
               16<br />
             </font></font></div>
</div>
<pre class="CodeMirror-line"><span style="padding-right: 0.1px;"><span class="cm-tab">    </span><span class="cm-tab">    </span><span class="cm-keyword">public</span> <span class="cm-variable">IActionResult</span> <span class="cm-variable">Create</span>([<span class="cm-variable">Bind</span>] <span class="cm-variable">EmployeeEntities</span> <span class="cm-variable">employeeEntities</span>)</span></pre>
</div>
<div style="position: relative;">
<div class="CodeMirror-gutter-wrapper" style="left: -31px;">
<div class="CodeMirror-linenumber CodeMirror-gutter-elt" style="left: 0px; width: 23px;"><font style="vertical-align: inherit;"><font style="vertical-align: inherit;"><br />
               17<br />
             </font></font></div>
</div>
<pre class="CodeMirror-line"><span style="padding-right: 0.1px;"><span class="cm-tab">    </span><span class="cm-tab">    </span>{</span></pre>
</div>
<div style="position: relative;">
<div class="CodeMirror-gutter-wrapper" style="left: -31px;">
<div class="CodeMirror-linenumber CodeMirror-gutter-elt" style="left: 0px; width: 23px;"><font style="vertical-align: inherit;"><font style="vertical-align: inherit;"><br />
               18<br />
             </font></font></div>
</div>
<pre class="CodeMirror-line"><span style="padding-right: 0.1px;"><span class="cm-tab">    </span><span class="cm-tab">    </span><span class="cm-tab">    </span><span class="cm-keyword">try</span></span></pre>
</div>
<div style="position: relative;">
<div class="CodeMirror-gutter-wrapper" style="left: -31px;">
<div class="CodeMirror-linenumber CodeMirror-gutter-elt" style="left: 0px; width: 23px;"><font style="vertical-align: inherit;"><font style="vertical-align: inherit;"><br />
               19<br />
             </font></font></div>
</div>
<pre class="CodeMirror-line"><span style="padding-right: 0.1px;"><span class="cm-tab">    </span><span class="cm-tab">    </span><span class="cm-tab">    </span>{</span></pre>
</div>
<div style="position: relative;">
<div class="CodeMirror-gutter-wrapper" style="left: -31px;">
<div class="CodeMirror-linenumber CodeMirror-gutter-elt" style="left: 0px; width: 23px;"><font style="vertical-align: inherit;"><font style="vertical-align: inherit;"><br />
               20<br />
             </font></font></div>
</div>
<pre class="CodeMirror-line"><span style="padding-right: 0.1px;"><span class="cm-tab">    </span><span class="cm-tab">    </span><span class="cm-tab">    </span><span class="cm-tab">    </span><span class="cm-keyword">if</span> (<span class="cm-variable">ModelState</span>.<span class="cm-variable">IsValid</span>)</span></pre>
</div>
<div style="position: relative;">
<div class="CodeMirror-gutter-wrapper" style="left: -31px;">
<div class="CodeMirror-linenumber CodeMirror-gutter-elt" style="left: 0px; width: 23px;"><font style="vertical-align: inherit;"><font style="vertical-align: inherit;"><br />
               21<br />
             </font></font></div>
</div>
<pre class="CodeMirror-line"><span style="padding-right: 0.1px;"><span class="cm-tab">    </span><span class="cm-tab">    </span><span class="cm-tab">    </span><span class="cm-tab">    </span>{</span></pre>
</div>
<div style="position: relative;">
<div class="CodeMirror-gutter-wrapper" style="left: -31px;">
<div class="CodeMirror-linenumber CodeMirror-gutter-elt" style="left: 0px; width: 23px;"><font style="vertical-align: inherit;"><font style="vertical-align: inherit;"><br />
               22<br />
             </font></font></div>
</div>
<pre class="CodeMirror-line"><span style="padding-right: 0.1px;"><span class="cm-tab">    </span><span class="cm-tab">    </span><span class="cm-tab">    </span><span class="cm-tab">    </span><span class="cm-tab">    </span><span class="cm-type">string</span> <span class="cm-variable">resp</span> <span class="cm-operator">=</span> <span class="cm-variable">empdb</span>.<span class="cm-variable">AddEmployeeRecord</span>(<span class="cm-variable">employeeEntities</span>);</span></pre>
</div>
<div style="position: relative;">
<div class="CodeMirror-gutter-wrapper" style="left: -31px;">
<div class="CodeMirror-linenumber CodeMirror-gutter-elt" style="left: 0px; width: 23px;"><font style="vertical-align: inherit;"><font style="vertical-align: inherit;"><br />
               23<br />
             </font></font></div>
</div>
<pre class="CodeMirror-line"><span style="padding-right: 0.1px;"><span class="cm-tab">    </span><span class="cm-tab">    </span><span class="cm-tab">    </span><span class="cm-tab">    </span><span class="cm-tab">    </span><span class="cm-variable">TempData</span>[<span class="cm-string">"msg"</span>] <span class="cm-operator">=</span> <span class="cm-variable">resp</span>;</span></pre>
</div>
<div style="position: relative;">
<div class="CodeMirror-gutter-wrapper" style="left: -31px;">
<div class="CodeMirror-linenumber CodeMirror-gutter-elt" style="left: 0px; width: 23px;"><font style="vertical-align: inherit;"><font style="vertical-align: inherit;"><br />
               24<br />
             </font></font></div>
</div>
<pre class="CodeMirror-line"><span style="padding-right: 0.1px;"><span class="cm-tab">    </span><span class="cm-tab">    </span><span class="cm-tab">    </span><span class="cm-tab">    </span>}</span></pre>
</div>
<div style="position: relative;">
<div class="CodeMirror-gutter-wrapper" style="left: -31px;">
<div class="CodeMirror-linenumber CodeMirror-gutter-elt" style="left: 0px; width: 23px;"><font style="vertical-align: inherit;"><font style="vertical-align: inherit;"><br />
               25<br />
             </font></font></div>
</div>
<pre class="CodeMirror-line"><span style="padding-right: 0.1px;"><span class="cm-tab">    </span><span class="cm-tab">    </span><span class="cm-tab">    </span>}</span></pre>
</div>
<div style="position: relative;">
<div class="CodeMirror-gutter-wrapper" style="left: -31px;">
<div class="CodeMirror-linenumber CodeMirror-gutter-elt" style="left: 0px; width: 23px;"><font style="vertical-align: inherit;"><font style="vertical-align: inherit;"><br />
               26<br />
             </font></font></div>
</div>
<pre class="CodeMirror-line"><span style="padding-right: 0.1px;"><span class="cm-tab">    </span><span class="cm-tab">    </span><span class="cm-tab">    </span><span class="cm-keyword">catch</span> (<span class="cm-variable">Exception</span> <span class="cm-variable">ex</span>)</span></pre>
</div>
<div style="position: relative;">
<div class="CodeMirror-gutter-wrapper" style="left: -31px;">
<div class="CodeMirror-linenumber CodeMirror-gutter-elt" style="left: 0px; width: 23px;"><font style="vertical-align: inherit;"><font style="vertical-align: inherit;"><br />
               27<br />
             </font></font></div>
</div>
<pre class="CodeMirror-line"><span style="padding-right: 0.1px;"><span class="cm-tab">    </span><span class="cm-tab">    </span><span class="cm-tab">    </span>{</span></pre>
</div>
<div style="position: relative;">
<div class="CodeMirror-gutter-wrapper" style="left: -31px;">
<div class="CodeMirror-linenumber CodeMirror-gutter-elt" style="left: 0px; width: 23px;"><font style="vertical-align: inherit;"><font style="vertical-align: inherit;"><br />
               28<br />
             </font></font></div>
</div>
<pre class="CodeMirror-line"><span style="padding-right: 0.1px;"><span class="cm-tab">    </span><span class="cm-tab">    </span><span class="cm-tab">    </span><span class="cm-tab">    </span><span class="cm-variable">TempData</span>[<span class="cm-string">"msg"</span>] <span class="cm-operator">=</span> <span class="cm-variable">ex</span>.<span class="cm-variable">Message</span>;</span></pre>
</div>
<div style="position: relative;">
<div class="CodeMirror-gutter-wrapper" style="left: -31px;">
<div class="CodeMirror-linenumber CodeMirror-gutter-elt" style="left: 0px; width: 23px;"><font style="vertical-align: inherit;"><font style="vertical-align: inherit;"><br />
               29<br />
             </font></font></div>
</div>
<pre class="CodeMirror-line"><span style="padding-right: 0.1px;"><span class="cm-tab">    </span><span class="cm-tab">    </span><span class="cm-tab">    </span>}</span></pre>
</div>
<div style="position: relative;">
<div class="CodeMirror-gutter-wrapper" style="left: -31px;">
<div class="CodeMirror-linenumber CodeMirror-gutter-elt" style="left: 0px; width: 23px;"><font style="vertical-align: inherit;"><font style="vertical-align: inherit;"><br />
               30<br />
             </font></font></div>
</div>
<pre class="CodeMirror-line"><span class="cm-tab-wrap-hack" style="padding-right: 0.1px;"><span class="cm-tab">    </span><span class="cm-tab">    </span><span class="cm-tab">    </span></span></pre>
</div>
<div style="position: relative;">
<div class="CodeMirror-gutter-wrapper" style="left: -31px;">
<div class="CodeMirror-linenumber CodeMirror-gutter-elt" style="left: 0px; width: 23px;"><font style="vertical-align: inherit;"><font style="vertical-align: inherit;"><br />
               31<br />
             </font></font></div>
</div>
<pre class="CodeMirror-line"><span style="padding-right: 0.1px;">            <span class="cm-keyword">return</span> <span class="cm-variable">View</span>();</span></pre>
</div>
<div style="position: relative;">
<div class="CodeMirror-gutter-wrapper" style="left: -31px;">
<div class="CodeMirror-linenumber CodeMirror-gutter-elt" style="left: 0px; width: 23px;"><font style="vertical-align: inherit;"><font style="vertical-align: inherit;"><br />
               32<br />
             </font></font></div>
</div>
<pre class="CodeMirror-line"><span style="padding-right: 0.1px;"><span class="cm-tab">    </span><span class="cm-tab">    </span>}</span></pre>
</div>
<div style="position: relative;">
<div class="CodeMirror-gutter-wrapper" style="left: -31px;">
<div class="CodeMirror-linenumber CodeMirror-gutter-elt" style="left: 0px; width: 23px;"><font style="vertical-align: inherit;"><font style="vertical-align: inherit;"><br />
               33<br />
             </font></font></div>
</div>
<pre class="CodeMirror-line"><span style="padding-right: 0.1px;"><span class="cm-tab">    </span>}</span></pre>
</div>
<div style="position: relative;">
<div class="CodeMirror-gutter-wrapper" style="left: -31px;">
<div class="CodeMirror-linenumber CodeMirror-gutter-elt" style="left: 0px; width: 23px;"><font style="vertical-align: inherit;"><font style="vertical-align: inherit;"><br />
               34<br />
             </font></font></div>
</div>
<pre class="CodeMirror-line"><span style="padding-right: 0.1px;">}</span></pre>
</div>
</div>
</div>
</div>
</div>
</div>
<div style="position: absolute; height: 15px; width: 1px; border-bottom: 0px solid transparent; top: 790px;">
       <br /> 
      </div>
<div class="CodeMirror-gutters" style="height: 805px; left: 0px;">
<div class="CodeMirror-gutter CodeMirror-linenumbers" style="width: 31px;">
       </div>
</div>
</div>
</div>
</div>
</div>
</div>
</ol>
<h2><font style="vertical-align: inherit;"><font style="vertical-align: inherit;">Добавление вида в приложение</font></font></h2>
<p><font style="vertical-align: inherit;"><font style="vertical-align: inherit;">Чтобы добавить представления для нашего класса контроллера, нам нужно создать папку внутри папки </font></font><em><span><strong><font style="vertical-align: inherit;"><font style="vertical-align: inherit;">Views</font></font></strong> </span></em><font style="vertical-align: inherit;"><font style="vertical-align: inherit;"> с тем же именем, что и у нашего контроллера, а затем добавить наши представления в эту папку.</font></font></p>
<p><font style="vertical-align: inherit;"><font style="vertical-align: inherit;">Щелкните правой кнопкой мыши </font><font style="vertical-align: inherit;">папку </font></font><em><span><strong><font style="vertical-align: inherit;"><font style="vertical-align: inherit;">Views</font></font></strong> </span></em><font style="vertical-align: inherit;"><font style="vertical-align: inherit;"> , затем </font><font style="vertical-align: inherit;">выберите </font></font><strong><font style="vertical-align: inherit;"><font style="vertical-align: inherit;">Add >> New Folder</font></font></strong><font style="vertical-align: inherit;"><font style="vertical-align: inherit;"> и назовите папку </font></font><em><span><strong><font style="vertical-align: inherit;"><font style="vertical-align: inherit;">Employee</font></font></strong></span></em><font style="vertical-align: inherit;"><font style="vertical-align: inherit;"> .</font></font></p>
<p><font style="vertical-align: inherit;"><font style="vertical-align: inherit;">Теперь щелкните правой кнопкой мыши на </font><font style="vertical-align: inherit;">папке </font></font><em><span><strong><font style="vertical-align: inherit;"><font style="vertical-align: inherit;">Views / Employee</font></font></strong></span></em><font style="vertical-align: inherit;"><font style="vertical-align: inherit;"> и выберите </font></font><strong><font style="vertical-align: inherit;"><font style="vertical-align: inherit;">Add >> New Item</font></font></strong><font style="vertical-align: inherit;"><font style="vertical-align: inherit;"> .</font></font></p>
<p><font style="vertical-align: inherit;"/><strong><font style="vertical-align: inherit;"><font style="vertical-align: inherit;">New Item Добавить</font></font></strong><font style="vertical-align: inherit;"><font style="vertical-align: inherit;"> откроется диалоговое окно. </font><font style="vertical-align: inherit;">Выберите ASP.NET Core на левой панели, выберите </font></font><strong><font style="vertical-align: inherit;"><font style="vertical-align: inherit;">Razor View на</font></font></strong><font style="vertical-align: inherit;"><font style="vertical-align: inherit;"> панели шаблонов и </font></font><strong><font style="vertical-align: inherit;"><font style="vertical-align: inherit;">введите</font></font></strong><font style="vertical-align: inherit;"><font style="vertical-align: inherit;"> имя </font><strong><font style="vertical-align: inherit;">Create.cshtml</font></strong><font style="vertical-align: inherit;"> . </font><font style="vertical-align: inherit;">Затем нажмите </font></font><strong><font style="vertical-align: inherit;"><font style="vertical-align: inherit;">ОК</font></font></strong><font style="vertical-align: inherit;"><font style="vertical-align: inherit;"> .</font></font></p>
<h3> <strong><span><font style="vertical-align: inherit;"><font style="vertical-align: inherit;">Создать вид</font></font></span></strong></h3>
<p><font style="vertical-align: inherit;"><font style="vertical-align: inherit;">Это представление будет использоваться для добавления новых данных о сотрудниках в базу данных.</font></font></p>
<p><font style="vertical-align: inherit;"><font style="vertical-align: inherit;">Откройте </font></font><em><span><strong><font style="vertical-align: inherit;"><font style="vertical-align: inherit;">Create.cshtml</font></font></strong> </span></em><font style="vertical-align: inherit;"><font style="vertical-align: inherit;"> и вставьте в него следующий код.</font></font></p>
<ol start="1">
<div class="codeMirror-wrapper">
<div contenteditable="false">
<div class="codeHeader">
<div class="nameLanguage"><font style="vertical-align: inherit;"><font style="vertical-align: inherit;"><br />
      HTML<br />
    </font></font></div>
<p>    <i class="icon-cancel-circled-1 cm-remove"> </i>
   </p>
</div>
<div class="codeMirror-code--wrapper" data-code="@model ChittaDB.EmployeeEntities
@{
ViewData["Title"] = "Create Employee";
}
<h2>Create Employee</h2>
<hr />
<form asp-action="Create" class="form-horizontal">
<div asp-validation-summary="ModelOnly" class="text-danger"></div>
<div class="form-group">
<label class="control-label">Name</label>
<input asp-for="Emp_Name" class="form-control" />
<span asp-validation-for="Emp_Name" class="text-danger"></span>
</div>
<div class="form-group">
<label class="control-label">City</label>
<input asp-for="City" class="form-control" />
<span asp-validation-for="City" class="text-danger"></span>
</div>
<div class="form-group">
<label class="control-label">State</label>
<input asp-for="State" class="form-control" />
<span asp-validation-for="State" class="text-danger"></span>
</div>
<div class="form-group">
<label class="control-label">Country</label>
<input asp-for="Country" class="form-control" />
<span asp-validation-for="Country" class="text-danger"></span>
</div>
<div class="form-group">
<label class="control-label">Department</label>
<input asp-for="Department" class="form-control" />
<span asp-validation-for="Department" class="text-danger"></span>
</div>
<div class="form-group">
<input type="submit" value="Submit" class="btn bg-primary" />
</div>
</form>
@{
if (@TempData["Msg"] != null)
{

}
}
" data-lang="text/html">
<div class="CodeMirror cm-s-default CodeMirror-wrap">
<div style="overflow: hidden; position: relative; width: 3px; height: 0px; top: 5px; left: 36px;">
      <textarea spellcheck="false" tabindex="0" style="position: absolute; bottom: -1em; padding: 0px; width: 1000px; height: 1em; outline: none;" value=""/>
     </div>
<div class="CodeMirror-vscrollbar" style="display: block; bottom: 0px;">
<div style="min-width: 1px; height: 1066px;">
       <br /> 
      </div>
</div>
<div class="CodeMirror-hscrollbar">
<div style="height: 100%; min-height: 1px; width: 0px;">
       <br /> 
      </div>
</div>
<div class="CodeMirror-scrollbar-filler">
      <br /> 
     </div>
<div class="CodeMirror-gutter-filler">
      <br /> 
     </div>
<div class="CodeMirror-scroll" tabindex="-1">
<div class="CodeMirror-sizer" style="margin-left: 31px; margin-bottom: -15px; border-right-width: 15px; min-height: 1066px; padding-right: 15px; padding-bottom: 0px;">
<div style="position: relative; top: 0px;">
<div class="CodeMirror-lines">
<div style="position: relative; outline: none;">
<div class="CodeMirror-measure">
<pre><span>xxxxxxxxxx</span></pre>
<div class="CodeMirror-linenumber CodeMirror-gutter-elt">
<div>
              1
            </div>
</div>
<div class="CodeMirror-linenumber CodeMirror-gutter-elt">
<div>
              46
            </div>
</div>
</div>
<div class="CodeMirror-measure">
           <br /> 
          </div>
<div style="position: relative; z-index: 1;">
           <br /> 
          </div>
<div class="CodeMirror-cursors">
<div class="CodeMirror-cursor" style="left: 4px; top: 0px; height: 23px;">
              
           </div>
</div>
<div class="CodeMirror-code">
<div style="position: relative;">
<div class="CodeMirror-gutter-wrapper" style="left: -31px;">
<div class="CodeMirror-linenumber CodeMirror-gutter-elt" style="left: 0px; width: 23px;"><font style="vertical-align: inherit;"><font style="vertical-align: inherit;"><br />
               1<br />
             </font></font></div>
</div>
<pre class="CodeMirror-line"><span style="padding-right: 0.1px;">@model ChittaDB.EmployeeEntities</span></pre>
</div>
<div style="position: relative;">
<div class="CodeMirror-gutter-wrapper" style="left: -31px;">
<div class="CodeMirror-linenumber CodeMirror-gutter-elt" style="left: 0px; width: 23px;"><font style="vertical-align: inherit;"><font style="vertical-align: inherit;"><br />
               2<br />
             </font></font></div>
</div>
<pre class="CodeMirror-line"><span style="padding-right: 0.1px;">@{</span></pre>
</div>
<div style="position: relative;">
<div class="CodeMirror-gutter-wrapper" style="left: -31px;">
<div class="CodeMirror-linenumber CodeMirror-gutter-elt" style="left: 0px; width: 23px;"><font style="vertical-align: inherit;"><font style="vertical-align: inherit;"><br />
               3<br />
             </font></font></div>
</div>
<pre class="CodeMirror-line"><span style="padding-right: 0.1px;">ViewData["Title"] = "Create Employee";</span></pre>
</div>
<div style="position: relative;">
<div class="CodeMirror-gutter-wrapper" style="left: -31px;">
<div class="CodeMirror-linenumber CodeMirror-gutter-elt" style="left: 0px; width: 23px;"><font style="vertical-align: inherit;"><font style="vertical-align: inherit;"><br />
               4<br />
             </font></font></div>
</div>
<pre class="CodeMirror-line"><span style="padding-right: 0.1px;">}</span></pre>
</div>
<div style="position: relative;">
<div class="CodeMirror-gutter-wrapper" style="left: -31px;">
<div class="CodeMirror-linenumber CodeMirror-gutter-elt" style="left: 0px; width: 23px;"><font style="vertical-align: inherit;"><font style="vertical-align: inherit;"><br />
               5<br />
             </font></font></div>
</div>
<pre class="CodeMirror-line"><span style="padding-right: 0.1px;"><span class="cm-tag cm-bracket"><</span><span class="cm-tag">h2</span><span class="cm-tag cm-bracket">></span>Create Employee<span class="cm-tag cm-bracket"></</span><span class="cm-tag">h2</span><span class="cm-tag cm-bracket">></span></span></pre>
</div>
<div style="position: relative;">
<div class="CodeMirror-gutter-wrapper" style="left: -31px;">
<div class="CodeMirror-linenumber CodeMirror-gutter-elt" style="left: 0px; width: 23px;"><font style="vertical-align: inherit;"><font style="vertical-align: inherit;"><br />
               6<br />
             </font></font></div>
</div>
<pre class="CodeMirror-line"><span style="padding-right: 0.1px;"><span class="cm-tag cm-bracket"><</span><span class="cm-tag">hr</span> <span class="cm-tag cm-bracket">/></span></span></pre>
</div>
<div style="position: relative;">
<div class="CodeMirror-gutter-wrapper" style="left: -31px;">
<div class="CodeMirror-linenumber CodeMirror-gutter-elt" style="left: 0px; width: 23px;"><font style="vertical-align: inherit;"><font style="vertical-align: inherit;"><br />
               7<br />
             </font></font></div>
</div>
<pre class="CodeMirror-line"><span style="padding-right: 0.1px;"><span class="cm-tag cm-bracket"><</span><span class="cm-tag">form</span> <span class="cm-attribute">asp-action</span>=<span class="cm-string">"Create"</span> <span class="cm-attribute">class</span>=<span class="cm-string">"form-horizontal"</span><span class="cm-tag cm-bracket">></span></span></pre>
</div>
<div style="position: relative;">
<div class="CodeMirror-gutter-wrapper" style="left: -31px;">
<div class="CodeMirror-linenumber CodeMirror-gutter-elt" style="left: 0px; width: 23px;"><font style="vertical-align: inherit;"><font style="vertical-align: inherit;"><br />
               8<br />
             </font></font></div>
</div>
<pre class="CodeMirror-line"><span style="padding-right: 0.1px;"><span class="cm-tag cm-bracket"><</span><span class="cm-tag">div</span> <span class="cm-attribute">asp-validation-summary</span>=<span class="cm-string">"ModelOnly"</span> <span class="cm-attribute">class</span>=<span class="cm-string">"text-danger"</span><span class="cm-tag cm-bracket">></</span><span class="cm-tag">div</span><span class="cm-tag cm-bracket">></span></span></pre>
</div>
<div style="position: relative;">
<div class="CodeMirror-gutter-wrapper" style="left: -31px;">
<div class="CodeMirror-linenumber CodeMirror-gutter-elt" style="left: 0px; width: 23px;"><font style="vertical-align: inherit;"><font style="vertical-align: inherit;"><br />
               9<br />
             </font></font></div>
</div>
<pre class="CodeMirror-line"><span style="padding-right: 0.1px;"><span class="cm-tag cm-bracket"><</span><span class="cm-tag">div</span> <span class="cm-attribute">class</span>=<span class="cm-string">"form-group"</span><span class="cm-tag cm-bracket">></span></span></pre>
</div>
<div style="position: relative;">
<div class="CodeMirror-gutter-wrapper" style="left: -31px;">
<div class="CodeMirror-linenumber CodeMirror-gutter-elt" style="left: 0px; width: 23px;"><font style="vertical-align: inherit;"><font style="vertical-align: inherit;"><br />
               10<br />
             </font></font></div>
</div>
<pre class="CodeMirror-line"><span style="padding-right: 0.1px;"><span class="cm-tag cm-bracket"><</span><span class="cm-tag">label</span> <span class="cm-attribute">class</span>=<span class="cm-string">"control-label"</span><span class="cm-tag cm-bracket">></span>Name<span class="cm-tag cm-bracket"></</span><span class="cm-tag">label</span><span class="cm-tag cm-bracket">></span></span></pre>
</div>
<div style="position: relative;">
<div class="CodeMirror-gutter-wrapper" style="left: -31px;">
<div class="CodeMirror-linenumber CodeMirror-gutter-elt" style="left: 0px; width: 23px;"><font style="vertical-align: inherit;"><font style="vertical-align: inherit;"><br />
               11<br />
             </font></font></div>
</div>
<pre class="CodeMirror-line"><span style="padding-right: 0.1px;"><span class="cm-tag cm-bracket"><</span><span class="cm-tag">input</span> <span class="cm-attribute">asp-for</span>=<span class="cm-string">"Emp_Name"</span> <span class="cm-attribute">class</span>=<span class="cm-string">"form-control"</span> <span class="cm-tag cm-bracket">/></span></span></pre>
</div>
<div style="position: relative;">
<div class="CodeMirror-gutter-wrapper" style="left: -31px;">
<div class="CodeMirror-linenumber CodeMirror-gutter-elt" style="left: 0px; width: 23px;"><font style="vertical-align: inherit;"><font style="vertical-align: inherit;"><br />
               12<br />
             </font></font></div>
</div>
<pre class="CodeMirror-line"><span style="padding-right: 0.1px;"><span class="cm-tag cm-bracket"><</span><span class="cm-tag">span</span> <span class="cm-attribute">asp-validation-for</span>=<span class="cm-string">"Emp_Name"</span> <span class="cm-attribute">class</span>=<span class="cm-string">"text-danger"</span><span class="cm-tag cm-bracket">></</span><span class="cm-tag">span</span><span class="cm-tag cm-bracket">></span></span></pre>
</div>
<div style="position: relative;">
<div class="CodeMirror-gutter-wrapper" style="left: -31px;">
<div class="CodeMirror-linenumber CodeMirror-gutter-elt" style="left: 0px; width: 23px;"><font style="vertical-align: inherit;"><font style="vertical-align: inherit;"><br />
               13<br />
             </font></font></div>
</div>
<pre class="CodeMirror-line"><span style="padding-right: 0.1px;"><span class="cm-tag cm-bracket"></</span><span class="cm-tag">div</span><span class="cm-tag cm-bracket">></span></span></pre>
</div>
<div style="position: relative;">
<div class="CodeMirror-gutter-wrapper" style="left: -31px;">
<div class="CodeMirror-linenumber CodeMirror-gutter-elt" style="left: 0px; width: 23px;"><font style="vertical-align: inherit;"><font style="vertical-align: inherit;"><br />
               14<br />
             </font></font></div>
</div>
<pre class="CodeMirror-line"><span style="padding-right: 0.1px;"><span class="cm-tag cm-bracket"><</span><span class="cm-tag">div</span> <span class="cm-attribute">class</span>=<span class="cm-string">"form-group"</span><span class="cm-tag cm-bracket">></span></span></pre>
</div>
<div style="position: relative;">
<div class="CodeMirror-gutter-wrapper" style="left: -31px;">
<div class="CodeMirror-linenumber CodeMirror-gutter-elt" style="left: 0px; width: 23px;"><font style="vertical-align: inherit;"><font style="vertical-align: inherit;"><br />
               15<br />
             </font></font></div>
</div>
<pre class="CodeMirror-line"><span style="padding-right: 0.1px;"><span class="cm-tag cm-bracket"><</span><span class="cm-tag">label</span> <span class="cm-attribute">class</span>=<span class="cm-string">"control-label"</span><span class="cm-tag cm-bracket">></span>City<span class="cm-tag cm-bracket"></</span><span class="cm-tag">label</span><span class="cm-tag cm-bracket">></span></span></pre>
</div>
<div style="position: relative;">
<div class="CodeMirror-gutter-wrapper" style="left: -31px;">
<div class="CodeMirror-linenumber CodeMirror-gutter-elt" style="left: 0px; width: 23px;"><font style="vertical-align: inherit;"><font style="vertical-align: inherit;"><br />
               16<br />
             </font></font></div>
</div>
<pre class="CodeMirror-line"><span style="padding-right: 0.1px;"><span class="cm-tag cm-bracket"><</span><span class="cm-tag">input</span> <span class="cm-attribute">asp-for</span>=<span class="cm-string">"City"</span> <span class="cm-attribute">class</span>=<span class="cm-string">"form-control"</span> <span class="cm-tag cm-bracket">/></span></span></pre>
</div>
<div style="position: relative;">
<div class="CodeMirror-gutter-wrapper" style="left: -31px;">
<div class="CodeMirror-linenumber CodeMirror-gutter-elt" style="left: 0px; width: 23px;"><font style="vertical-align: inherit;"><font style="vertical-align: inherit;"><br />
               17<br />
             </font></font></div>
</div>
<pre class="CodeMirror-line"><span style="padding-right: 0.1px;"><span class="cm-tag cm-bracket"><</span><span class="cm-tag">span</span> <span class="cm-attribute">asp-validation-for</span>=<span class="cm-string">"City"</span> <span class="cm-attribute">class</span>=<span class="cm-string">"text-danger"</span><span class="cm-tag cm-bracket">></</span><span class="cm-tag">span</span><span class="cm-tag cm-bracket">></span></span></pre>
</div>
<div style="position: relative;">
<div class="CodeMirror-gutter-wrapper" style="left: -31px;">
<div class="CodeMirror-linenumber CodeMirror-gutter-elt" style="left: 0px; width: 23px;"><font style="vertical-align: inherit;"><font style="vertical-align: inherit;"><br />
               18<br />
             </font></font></div>
</div>
<pre class="CodeMirror-line"><span style="padding-right: 0.1px;"><span class="cm-tag cm-bracket"></</span><span class="cm-tag">div</span><span class="cm-tag cm-bracket">></span></span></pre>
</div>
<div style="position: relative;">
<div class="CodeMirror-gutter-wrapper" style="left: -31px;">
<div class="CodeMirror-linenumber CodeMirror-gutter-elt" style="left: 0px; width: 23px;"><font style="vertical-align: inherit;"><font style="vertical-align: inherit;"><br />
               19<br />
             </font></font></div>
</div>
<pre class="CodeMirror-line"><span style="padding-right: 0.1px;"><span class="cm-tag cm-bracket"><</span><span class="cm-tag">div</span> <span class="cm-attribute">class</span>=<span class="cm-string">"form-group"</span><span class="cm-tag cm-bracket">></span></span></pre>
</div>
<div style="position: relative;">
<div class="CodeMirror-gutter-wrapper" style="left: -31px;">
<div class="CodeMirror-linenumber CodeMirror-gutter-elt" style="left: 0px; width: 23px;"><font style="vertical-align: inherit;"><font style="vertical-align: inherit;"><br />
               20<br />
             </font></font></div>
</div>
<pre class="CodeMirror-line"><span style="padding-right: 0.1px;"><span class="cm-tag cm-bracket"><</span><span class="cm-tag">label</span> <span class="cm-attribute">class</span>=<span class="cm-string">"control-label"</span><span class="cm-tag cm-bracket">></span>State<span class="cm-tag cm-bracket"></</span><span class="cm-tag">label</span><span class="cm-tag cm-bracket">></span></span></pre>
</div>
<div style="position: relative;">
<div class="CodeMirror-gutter-wrapper" style="left: -31px;">
<div class="CodeMirror-linenumber CodeMirror-gutter-elt" style="left: 0px; width: 23px;"><font style="vertical-align: inherit;"><font style="vertical-align: inherit;"><br />
               21<br />
             </font></font></div>
</div>
<pre class="CodeMirror-line"><span style="padding-right: 0.1px;"><span class="cm-tag cm-bracket"><</span><span class="cm-tag">input</span> <span class="cm-attribute">asp-for</span>=<span class="cm-string">"State"</span> <span class="cm-attribute">class</span>=<span class="cm-string">"form-control"</span> <span class="cm-tag cm-bracket">/></span></span></pre>
</div>
<div style="position: relative;">
<div class="CodeMirror-gutter-wrapper" style="left: -31px;">
<div class="CodeMirror-linenumber CodeMirror-gutter-elt" style="left: 0px; width: 23px;"><font style="vertical-align: inherit;"><font style="vertical-align: inherit;"><br />
               22<br />
             </font></font></div>
</div>
<pre class="CodeMirror-line"><span style="padding-right: 0.1px;"><span class="cm-tag cm-bracket"><</span><span class="cm-tag">span</span> <span class="cm-attribute">asp-validation-for</span>=<span class="cm-string">"State"</span> <span class="cm-attribute">class</span>=<span class="cm-string">"text-danger"</span><span class="cm-tag cm-bracket">></</span><span class="cm-tag">span</span><span class="cm-tag cm-bracket">></span></span></pre>
</div>
<div style="position: relative;">
<div class="CodeMirror-gutter-wrapper" style="left: -31px;">
<div class="CodeMirror-linenumber CodeMirror-gutter-elt" style="left: 0px; width: 23px;"><font style="vertical-align: inherit;"><font style="vertical-align: inherit;"><br />
               23<br />
             </font></font></div>
</div>
<pre class="CodeMirror-line"><span style="padding-right: 0.1px;"><span class="cm-tag cm-bracket"></</span><span class="cm-tag">div</span><span class="cm-tag cm-bracket">></span></span></pre>
</div>
<div style="position: relative;">
<div class="CodeMirror-gutter-wrapper" style="left: -31px;">
<div class="CodeMirror-linenumber CodeMirror-gutter-elt" style="left: 0px; width: 23px;"><font style="vertical-align: inherit;"><font style="vertical-align: inherit;"><br />
               24<br />
             </font></font></div>
</div>
<pre class="CodeMirror-line"><span style="padding-right: 0.1px;"><span class="cm-tag cm-bracket"><</span><span class="cm-tag">div</span> <span class="cm-attribute">class</span>=<span class="cm-string">"form-group"</span><span class="cm-tag cm-bracket">></span></span></pre>
</div>
<div style="position: relative;">
<div class="CodeMirror-gutter-wrapper" style="left: -31px;">
<div class="CodeMirror-linenumber CodeMirror-gutter-elt" style="left: 0px; width: 23px;"><font style="vertical-align: inherit;"><font style="vertical-align: inherit;"><br />
               25<br />
             </font></font></div>
</div>
<pre class="CodeMirror-line"><span style="padding-right: 0.1px;"><span class="cm-tag cm-bracket"><</span><span class="cm-tag">label</span> <span class="cm-attribute">class</span>=<span class="cm-string">"control-label"</span><span class="cm-tag cm-bracket">></span>Country<span class="cm-tag cm-bracket"></</span><span class="cm-tag">label</span><span class="cm-tag cm-bracket">></span></span></pre>
</div>
<div style="position: relative;">
<div class="CodeMirror-gutter-wrapper" style="left: -31px;">
<div class="CodeMirror-linenumber CodeMirror-gutter-elt" style="left: 0px; width: 23px;"><font style="vertical-align: inherit;"><font style="vertical-align: inherit;"><br />
               26<br />
             </font></font></div>
</div>
<pre class="CodeMirror-line"><span style="padding-right: 0.1px;"><span class="cm-tag cm-bracket"><</span><span class="cm-tag">input</span> <span class="cm-attribute">asp-for</span>=<span class="cm-string">"Country"</span> <span class="cm-attribute">class</span>=<span class="cm-string">"form-control"</span> <span class="cm-tag cm-bracket">/></span></span></pre>
</div>
<div style="position: relative;">
<div class="CodeMirror-gutter-wrapper" style="left: -31px;">
<div class="CodeMirror-linenumber CodeMirror-gutter-elt" style="left: 0px; width: 23px;"><font style="vertical-align: inherit;"><font style="vertical-align: inherit;"><br />
               27<br />
             </font></font></div>
</div>
<pre class="CodeMirror-line"><span style="padding-right: 0.1px;"><span class="cm-tag cm-bracket"><</span><span class="cm-tag">span</span> <span class="cm-attribute">asp-validation-for</span>=<span class="cm-string">"Country"</span> <span class="cm-attribute">class</span>=<span class="cm-string">"text-danger"</span><span class="cm-tag cm-bracket">></</span><span class="cm-tag">span</span><span class="cm-tag cm-bracket">></span></span></pre>
</div>
<div style="position: relative;">
<div class="CodeMirror-gutter-wrapper" style="left: -31px;">
<div class="CodeMirror-linenumber CodeMirror-gutter-elt" style="left: 0px; width: 23px;"><font style="vertical-align: inherit;"><font style="vertical-align: inherit;"><br />
               28<br />
             </font></font></div>
</div>
<pre class="CodeMirror-line"><span style="padding-right: 0.1px;"><span class="cm-tag cm-bracket"></</span><span class="cm-tag">div</span><span class="cm-tag cm-bracket">></span></span></pre>
</div>
<div style="position: relative;">
<div class="CodeMirror-gutter-wrapper" style="left: -31px;">
<div class="CodeMirror-linenumber CodeMirror-gutter-elt" style="left: 0px; width: 23px;"><font style="vertical-align: inherit;"><font style="vertical-align: inherit;"><br />
               29<br />
             </font></font></div>
</div>
<pre class="CodeMirror-line"><span style="padding-right: 0.1px;"><span class="cm-tag cm-bracket"><</span><span class="cm-tag">div</span> <span class="cm-attribute">class</span>=<span class="cm-string">"form-group"</span><span class="cm-tag cm-bracket">></span></span></pre>
</div>
<div style="position: relative;">
<div class="CodeMirror-gutter-wrapper" style="left: -31px;">
<div class="CodeMirror-linenumber CodeMirror-gutter-elt" style="left: 0px; width: 23px;"><font style="vertical-align: inherit;"><font style="vertical-align: inherit;"><br />
               30<br />
             </font></font></div>
</div>
<pre class="CodeMirror-line"><span style="padding-right: 0.1px;"><span class="cm-tag cm-bracket"><</span><span class="cm-tag">label</span> <span class="cm-attribute">class</span>=<span class="cm-string">"control-label"</span><span class="cm-tag cm-bracket">></span>Department<span class="cm-tag cm-bracket"></</span><span class="cm-tag">label</span><span class="cm-tag cm-bracket">></span></span></pre>
</div>
<div style="position: relative;">
<div class="CodeMirror-gutter-wrapper" style="left: -31px;">
<div class="CodeMirror-linenumber CodeMirror-gutter-elt" style="left: 0px; width: 23px;"><font style="vertical-align: inherit;"><font style="vertical-align: inherit;"><br />
               31<br />
             </font></font></div>
</div>
<pre class="CodeMirror-line"><span style="padding-right: 0.1px;"><span class="cm-tag cm-bracket"><</span><span class="cm-tag">input</span> <span class="cm-attribute">asp-for</span>=<span class="cm-string">"Department"</span> <span class="cm-attribute">class</span>=<span class="cm-string">"form-control"</span> <span class="cm-tag cm-bracket">/></span></span></pre>
</div>
<div style="position: relative;">
<div class="CodeMirror-gutter-wrapper" style="left: -31px;">
<div class="CodeMirror-linenumber CodeMirror-gutter-elt" style="left: 0px; width: 23px;"><font style="vertical-align: inherit;"><font style="vertical-align: inherit;"><br />
               32<br />
             </font></font></div>
</div>
<pre class="CodeMirror-line"><span style="padding-right: 0.1px;"><span class="cm-tag cm-bracket"><</span><span class="cm-tag">span</span> <span class="cm-attribute">asp-validation-for</span>=<span class="cm-string">"Department"</span> <span class="cm-attribute">class</span>=<span class="cm-string">"text-danger"</span><span class="cm-tag cm-bracket">></</span><span class="cm-tag">span</span><span class="cm-tag cm-bracket">></span></span></pre>
</div>
<div style="position: relative;">
<div class="CodeMirror-gutter-wrapper" style="left: -31px;">
<div class="CodeMirror-linenumber CodeMirror-gutter-elt" style="left: 0px; width: 23px;"><font style="vertical-align: inherit;"><font style="vertical-align: inherit;"><br />
               33<br />
             </font></font></div>
</div>
<pre class="CodeMirror-line"><span style="padding-right: 0.1px;"><span class="cm-tag cm-bracket"></</span><span class="cm-tag">div</span><span class="cm-tag cm-bracket">></span></span></pre>
</div>
<div style="position: relative;">
<div class="CodeMirror-gutter-wrapper" style="left: -31px;">
<div class="CodeMirror-linenumber CodeMirror-gutter-elt" style="left: 0px; width: 23px;"><font style="vertical-align: inherit;"><font style="vertical-align: inherit;"><br />
               34<br />
             </font></font></div>
</div>
<pre class="CodeMirror-line"><span style="padding-right: 0.1px;"><span class="cm-tag cm-bracket"><</span><span class="cm-tag">div</span> <span class="cm-attribute">class</span>=<span class="cm-string">"form-group"</span><span class="cm-tag cm-bracket">></span></span></pre>
</div>
<div style="position: relative;">
<div class="CodeMirror-gutter-wrapper" style="left: -31px;">
<div class="CodeMirror-linenumber CodeMirror-gutter-elt" style="left: 0px; width: 23px;"><font style="vertical-align: inherit;"><font style="vertical-align: inherit;"><br />
               35<br />
             </font></font></div>
</div>
<pre class="CodeMirror-line"><span style="padding-right: 0.1px;"><span class="cm-tag cm-bracket"><</span><span class="cm-tag">input</span> <span class="cm-attribute">type</span>=<span class="cm-string">"submit"</span> <span class="cm-attribute">value</span>=<span class="cm-string">"Submit"</span> <span class="cm-attribute">class</span>=<span class="cm-string">"btn bg-primary"</span> <span class="cm-tag cm-bracket">/></span></span></pre>
</div>
<div style="position: relative;">
<div class="CodeMirror-gutter-wrapper" style="left: -31px;">
<div class="CodeMirror-linenumber CodeMirror-gutter-elt" style="left: 0px; width: 23px;"><font style="vertical-align: inherit;"><font style="vertical-align: inherit;"><br />
               36<br />
             </font></font></div>
</div>
<pre class="CodeMirror-line"><span style="padding-right: 0.1px;"><span class="cm-tag cm-bracket"></</span><span class="cm-tag">div</span><span class="cm-tag cm-bracket">></span></span></pre>
</div>
<div style="position: relative;">
<div class="CodeMirror-gutter-wrapper" style="left: -31px;">
<div class="CodeMirror-linenumber CodeMirror-gutter-elt" style="left: 0px; width: 23px;"><font style="vertical-align: inherit;"><font style="vertical-align: inherit;"><br />
               37<br />
             </font></font></div>
</div>
<pre class="CodeMirror-line"><span style="padding-right: 0.1px;"><span class="cm-tag cm-bracket"></</span><span class="cm-tag">form</span><span class="cm-tag cm-bracket">></span></span></pre>
</div>
<div style="position: relative;">
<div class="CodeMirror-gutter-wrapper" style="left: -31px;">
<div class="CodeMirror-linenumber CodeMirror-gutter-elt" style="left: 0px; width: 23px;"><font style="vertical-align: inherit;"><font style="vertical-align: inherit;"><br />
               38<br />
             </font></font></div>
</div>
<pre class="CodeMirror-line"><span style="padding-right: 0.1px;">@{</span></pre>
</div>
<div style="position: relative;">
<div class="CodeMirror-gutter-wrapper" style="left: -31px;">
<div class="CodeMirror-linenumber CodeMirror-gutter-elt" style="left: 0px; width: 23px;"><font style="vertical-align: inherit;"><font style="vertical-align: inherit;"><br />
               39<br />
             </font></font></div>
</div>
<pre class="CodeMirror-line"><span style="padding-right: 0.1px;">if (@TempData["Msg"] != null)</span></pre>
</div>
<div style="position: relative;">
<div class="CodeMirror-gutter-wrapper" style="left: -31px;">
<div class="CodeMirror-linenumber CodeMirror-gutter-elt" style="left: 0px; width: 23px;"><font style="vertical-align: inherit;"><font style="vertical-align: inherit;"><br />
               40<br />
             </font></font></div>
</div>
<pre class="CodeMirror-line"><span style="padding-right: 0.1px;">{</span></pre>
</div>
<div style="position: relative;">
<div class="CodeMirror-gutter-wrapper" style="left: -31px;">
<div class="CodeMirror-linenumber CodeMirror-gutter-elt" style="left: 0px; width: 23px;"><font style="vertical-align: inherit;"><font style="vertical-align: inherit;"><br />
               41<br />
             </font></font></div>
</div>
<pre class="CodeMirror-line"><span style="padding-right: 0.1px;"><span class="cm-tag cm-bracket"><</span><span class="cm-tag">script</span><span class="cm-tag cm-bracket">></span></span></pre>
</div>
<div style="position: relative;">
<div class="CodeMirror-gutter-wrapper" style="left: -31px;">
<div class="CodeMirror-linenumber CodeMirror-gutter-elt" style="left: 0px; width: 23px;"><font style="vertical-align: inherit;"><font style="vertical-align: inherit;"><br />
               42<br />
             </font></font></div>
</div>
<pre class="CodeMirror-line"><span style="padding-right: 0.1px;"><span class="cm-variable">alert</span>(<span class="cm-string">'@TempData["msg"]'</span>)</span></pre>
</div>
<div style="position: relative;">
<div class="CodeMirror-gutter-wrapper" style="left: -31px;">
<div class="CodeMirror-linenumber CodeMirror-gutter-elt" style="left: 0px; width: 23px;"><font style="vertical-align: inherit;"><font style="vertical-align: inherit;"><br />
               43<br />
             </font></font></div>
</div>
<pre class="CodeMirror-line"><span style="padding-right: 0.1px;"><span class="cm-tag cm-bracket"></</span><span class="cm-tag">script</span><span class="cm-tag cm-bracket">></span></span></pre>
</div>
<div style="position: relative;">
<div class="CodeMirror-gutter-wrapper" style="left: -31px;">
<div class="CodeMirror-linenumber CodeMirror-gutter-elt" style="left: 0px; width: 23px;"><font style="vertical-align: inherit;"><font style="vertical-align: inherit;"><br />
               44<br />
             </font></font></div>
</div>
<pre class="CodeMirror-line"><span style="padding-right: 0.1px;">}</span></pre>
</div>
<div style="position: relative;">
<div class="CodeMirror-gutter-wrapper" style="left: -31px;">
<div class="CodeMirror-linenumber CodeMirror-gutter-elt" style="left: 0px; width: 23px;"><font style="vertical-align: inherit;"><font style="vertical-align: inherit;"><br />
               45<br />
             </font></font></div>
</div>
<pre class="CodeMirror-line"><span style="padding-right: 0.1px;">}</span></pre>
</div>
<div style="position: relative;">
<div class="CodeMirror-gutter-wrapper" style="left: -31px;">
<div class="CodeMirror-linenumber CodeMirror-gutter-elt" style="left: 0px; width: 23px;"><font style="vertical-align: inherit;"><font style="vertical-align: inherit;"><br />
               46<br />
             </font></font></div>
</div>
<pre class="CodeMirror-line"/></div> 
          </div> 
         </div> 
        </div> 
       </div> 
      </div> 
      <div style="position: absolute; height: 15px; width: 1px; border-bottom: 0px solid transparent; top: 1066px;"> 
       <br/> 
      </div> 
      <div class="CodeMirror-gutters" style="height: 1081px; left: 0px;"> 
       <div class="CodeMirror-gutter CodeMirror-linenumbers" style="width: 31px;"> 
        <br/> 
       </div> 
      </div> 
     </div> 
    </div> 
   </div> 
  </div> 
 </div> 
</ol> 
<p> </p> 
<p> <br/> </p> 
<h3><strong><font style="vertical-align: inherit;"><font style="vertical-align: inherit;">Добавить новый предмет</font></font></strong></h3> 
<p><font style="vertical-align: inherit;"><font style="vertical-align: inherit;">Отредактируйте </font><font style="vertical-align: inherit;">страницу </font></font><strong><font style="vertical-align: inherit;"><font style="vertical-align: inherit;">Views / Shared / _Layout</font></font></strong><font style="vertical-align: inherit;"><font style="vertical-align: inherit;"> и добавьте новое меню </font></font><strong><font style="vertical-align: inherit;"><font style="vertical-align: inherit;">Add Employee</font></font></strong><font style="vertical-align: inherit;"><font style="vertical-align: inherit;"> . </font><font style="vertical-align: inherit;">Для этого добавьте следующий код:</font></font></p> 
<ol start="1"> 
 <div class="codeMirror-wrapper"> 
  <div contenteditable="false"> 
   <div class="codeHeader"> 
    <div class="nameLanguage"><font style="vertical-align: inherit;"><font style="vertical-align: inherit;">
      HTML 
    </font></font></div> 
    <i class="icon-cancel-circled-1 cm-remove"> </i> 
   </div> 
   <div class="codeMirror-code--wrapper" data-code="<ul class="nav navbar-nav">
<li><a asp-area="" asp-controller="Home" asp-action="Index">Home</a></li>
<li><a asp-area="" asp-controller="Home" asp-action="About">About</a></li>
<li><a asp-area="" asp-controller="Home" asp-action="Contact">Contact</a></li>
<li><a asp-area="" asp-controller="Employee" asp-action="Create">Add Employee</a></li>
</ul>" data-lang="text/html"> 
    <div class="CodeMirror cm-s-default CodeMirror-wrap"> 
     <div style="overflow: hidden; position: relative; width: 3px; height: 0px; top: 5px; left: 36px;"> 
      <textarea spellcheck="false" tabindex="0" style="position: absolute; bottom: -1em; padding: 0px; width: 1000px; height: 1em; outline: none;" value=""/> 
     </div> 
     <div class="CodeMirror-vscrollbar"> 
      <div style="min-width: 1px; height: 0px;"> 
       <br/> 
      </div> 
     </div> 
     <div class="CodeMirror-hscrollbar"> 
      <div style="height: 100%; min-height: 1px; width: 0px;"> 
       <br/> 
      </div> 
     </div> 
     <div class="CodeMirror-scrollbar-filler"> 
      <br/> 
     </div> 
     <div class="CodeMirror-gutter-filler"> 
      <br/> 
     </div> 
     <div class="CodeMirror-scroll" tabindex="-1"> 
      <div class="CodeMirror-sizer" style="margin-left: 31px; margin-bottom: -15px; border-right-width: 15px; min-height: 169px; padding-right: 0px; padding-bottom: 0px;"> 
       <div style="position: relative; top: 0px;"> 
        <div class="CodeMirror-lines"> 
         <div style="position: relative; outline: none;"> 
          <div class="CodeMirror-measure"> 
           <pre><span>xxxxxxxxxx</span></pre>
<div class="CodeMirror-linenumber CodeMirror-gutter-elt">
<div>
              1
            </div>
</div>
</div>
<div class="CodeMirror-measure">
           <br /> 
          </div>
<div style="position: relative; z-index: 1;">
           <br /> 
          </div>
<div class="CodeMirror-cursors">
<div class="CodeMirror-cursor" style="left: 4px; top: 0px; height: 23px;">
              
           </div>
</div>
<div class="CodeMirror-code">
<div style="position: relative;">
<div class="CodeMirror-gutter-wrapper" style="left: -31px;">
<div class="CodeMirror-linenumber CodeMirror-gutter-elt" style="left: 0px; width: 23px;"><font style="vertical-align: inherit;"><font style="vertical-align: inherit;"><br />
               1<br />
             </font></font></div>
</div>
<pre class="CodeMirror-line"><span style="padding-right: 0.1px;"><span class="cm-tag cm-bracket"><</span><span class="cm-tag">ul</span> <span class="cm-attribute">class</span>=<span class="cm-string">"nav navbar-nav"</span><span class="cm-tag cm-bracket">></span></span></pre>
</div>
<div style="position: relative;">
<div class="CodeMirror-gutter-wrapper" style="left: -31px;">
<div class="CodeMirror-linenumber CodeMirror-gutter-elt" style="left: 0px; width: 23px;"><font style="vertical-align: inherit;"><font style="vertical-align: inherit;"><br />
               2<br />
             </font></font></div>
</div>
<pre class="CodeMirror-line"><span style="padding-right: 0.1px;"><span class="cm-tag cm-bracket"><</span><span class="cm-tag">li</span><span class="cm-tag cm-bracket">><</span><span class="cm-tag">a</span> <span class="cm-attribute">asp-area</span>=<span class="cm-string">""</span> <span class="cm-attribute">asp-controller</span>=<span class="cm-string">"Home"</span> <span class="cm-attribute">asp-action</span>=<span class="cm-string">"Index"</span><span class="cm-tag cm-bracket">></span>Home<span class="cm-tag cm-bracket"></</span><span class="cm-tag">a</span><span class="cm-tag cm-bracket">></</span><span class="cm-tag">li</span><span class="cm-tag cm-bracket">></span></span></pre>
</div>
<div style="position: relative;">
<div class="CodeMirror-gutter-wrapper" style="left: -31px;">
<div class="CodeMirror-linenumber CodeMirror-gutter-elt" style="left: 0px; width: 23px;"><font style="vertical-align: inherit;"><font style="vertical-align: inherit;"><br />
               3<br />
             </font></font></div>
</div>
<pre class="CodeMirror-line"><span style="padding-right: 0.1px;"><span class="cm-tag cm-bracket"><</span><span class="cm-tag">li</span><span class="cm-tag cm-bracket">><</span><span class="cm-tag">a</span> <span class="cm-attribute">asp-area</span>=<span class="cm-string">""</span> <span class="cm-attribute">asp-controller</span>=<span class="cm-string">"Home"</span> <span class="cm-attribute">asp-action</span>=<span class="cm-string">"About"</span><span class="cm-tag cm-bracket">></span>About<span class="cm-tag cm-bracket"></</span><span class="cm-tag">a</span><span class="cm-tag cm-bracket">></</span><span class="cm-tag">li</span><span class="cm-tag cm-bracket">></span></span></pre>
</div>
<div style="position: relative;">
<div class="CodeMirror-gutter-wrapper" style="left: -31px;">
<div class="CodeMirror-linenumber CodeMirror-gutter-elt" style="left: 0px; width: 23px;"><font style="vertical-align: inherit;"><font style="vertical-align: inherit;"><br />
               4<br />
             </font></font></div>
</div>
<pre class="CodeMirror-line"><span style="padding-right: 0.1px;"><span class="cm-tag cm-bracket"><</span><span class="cm-tag">li</span><span class="cm-tag cm-bracket">><</span><span class="cm-tag">a</span> <span class="cm-attribute">asp-area</span>=<span class="cm-string">""</span> <span class="cm-attribute">asp-controller</span>=<span class="cm-string">"Home"</span> <span class="cm-attribute">asp-action</span>=<span class="cm-string">"Contact"</span><span class="cm-tag cm-bracket">></span>Contact<span class="cm-tag cm-bracket"></</span><span class="cm-tag">a</span><span class="cm-tag cm-bracket">></</span><span class="cm-tag">li</span><span class="cm-tag cm-bracket">></span></span></pre>
</div>
<div style="position: relative;">
<div class="CodeMirror-gutter-wrapper" style="left: -31px;">
<div class="CodeMirror-linenumber CodeMirror-gutter-elt" style="left: 0px; width: 23px;"><font style="vertical-align: inherit;"><font style="vertical-align: inherit;"><br />
               5<br />
             </font></font></div>
</div>
<pre class="CodeMirror-line"><span style="padding-right: 0.1px;"><span class="cm-tag cm-bracket"><</span><span class="cm-tag">li</span><span class="cm-tag cm-bracket">><</span><span class="cm-tag">a</span> <span class="cm-attribute">asp-area</span>=<span class="cm-string">""</span> <span class="cm-attribute">asp-controller</span>=<span class="cm-string">"Employee"</span> <span class="cm-attribute">asp-action</span>=<span class="cm-string">"Create"</span><span class="cm-tag cm-bracket">></span>Add Employee<span class="cm-tag cm-bracket"></</span><span class="cm-tag">a</span><span class="cm-tag cm-bracket">></</span><span class="cm-tag">li</span><span class="cm-tag cm-bracket">></span></span></pre>
</div>
<div style="position: relative;">
<div class="CodeMirror-gutter-wrapper" style="left: -31px;">
<div class="CodeMirror-linenumber CodeMirror-gutter-elt" style="left: 0px; width: 23px;"><font style="vertical-align: inherit;"><font style="vertical-align: inherit;"><br />
               6<br />
             </font></font></div>
</div>
<pre class="CodeMirror-line"><span style="padding-right: 0.1px;"><span class="cm-tag cm-bracket"></</span><span class="cm-tag">ul</span><span class="cm-tag cm-bracket">></span></span></pre>
</div>
</div>
</div>
</div>
</div>
</div>
<div style="position: absolute; height: 15px; width: 1px; border-bottom: 0px solid transparent; top: 169px;">
       <br /> 
      </div>
<div class="CodeMirror-gutters" style="height: 184px; left: 0px;">
<div class="CodeMirror-gutter CodeMirror-linenumbers" style="width: 31px;">
       </div>
</div>
</div>
</div>
</div>
</div>
</div>
</ol>
<h3><strong><span><font style="vertical-align: inherit;"><font style="vertical-align: inherit;">Построить и запустить</font></font></span></strong></h3>
<p><font style="vertical-align: inherit;"><font style="vertical-align: inherit;">Теперь нажмите F5, чтобы запустить приложение или запустить приложение. </font><font style="vertical-align: inherit;">Нажмите « </font></font><strong><font style="vertical-align: inherit;"><font style="vertical-align: inherit;">Добавить сотрудника»,</font></font></strong><font style="vertical-align: inherit;"><font style="vertical-align: inherit;"> чтобы перейти к представлению «  </font></font><em><span><strong><font style="vertical-align: inherit;"><font style="vertical-align: inherit;">Создать»</font></font></strong> </span></em><font style="vertical-align: inherit;"><font style="vertical-align: inherit;"> .</font></font></p>
<p><font style="vertical-align: inherit;"><font style="vertical-align: inherit;">Мы также добавили проверку с использованием  </font></font><code>DataAnnotations</code><font style="vertical-align: inherit;"><font style="vertical-align: inherit;">на странице «Создать представление». </font><font style="vertical-align: inherit;">Если мы пропустим данные в каком-либо поле при создании записи сотрудника, мы получим сообщение об ошибке проверки требуемого поля.</font></font></p>
<p><font style="vertical-align: inherit;"><font style="vertical-align: inherit;">Когда данные будут сохранены, появится сообщение об успехе. </font><font style="vertical-align: inherit;">Оттуда, нажмите ОК. </font><font style="vertical-align: inherit;">После того, как данные сохранены, вы можете проверить свою базу данных.</font></font></p>
<h2><font style="vertical-align: inherit;"><font style="vertical-align: inherit;">Вывод </font></font></h2>
<p><font style="vertical-align: inherit;"><font style="vertical-align: inherit;">В этой статье вы узнали, как создать проект библиотеки классов .NET Core 2.1 с помощью ADO.NET с помощью Visual Studio 2017. Вы также узнали, как использовать библиотеку классов .NET Core в ASP.NET Core MVC. приложение для вставки данных.</font></font></p>
</p>
<h2><font style="vertical-align: inherit;"><font style="vertical-align: inherit;">Дальнейшее чтение</font></font></h2>
<ul>
<li><a href="https://translate.google.com/translate?sl=en&tl=ru&hl=ru&u=https://dzone.com/articles/20-useful-open-source-libraries-for-java-programme&client=webapp" rel="nofollow"><font style="vertical-align: inherit;"><font style="vertical-align: inherit;">20 полезных библиотек, которые должны знать Java-программисты</font></font></a><font style="vertical-align: inherit;"><font style="vertical-align: inherit;"> .</font></font></li>
<li><a href="https://translate.google.com/translate?sl=en&tl=ru&hl=ru&u=https://dzone.com/articles/c-best-practices&client=webapp" rel="nofollow">C# Best Practices</a>.</li>
<li><a href="https://translate.google.com/translate?sl=en&tl=ru&hl=ru&u=https://dzone.com/articles/best-of-dzone-c-and-aspnet-tutorials&client=webapp" rel="nofollow">Best of DZone: Developing Web Apps and Services With C# and ASP.NET</a>.</li>
</ul>
</div>
<div class="content-html" dz-code-container="" ng-cloak="">
                        <a ng-href="{{articles[0].pdf}}"></p>
<p>                        </a></p>
<div class="pub-content content-html" ng-bind-html="article.shortDesc"/>
                    </div>
</div>

														</div><!-- .entry-content -->

														<div class="saxon-social-share-fixed sidebar-position-right">
									<div class="post-social-wrapper">
        <div class="post-social-title">Share:</div>
		<div class="post-social">
			<a title="Share with VKontakte" href="https://coderlessons.com/articles/veb-razrabotka-articles/sozdanie-proekta-biblioteki-klassov-net-core-2-1-s-ispolzovaniem-ado-net" data-type="vk" data-title="Создание проекта библиотеки классов .NET Core 2.1 с использованием ADO.NET" data-image="" class="vk-share"> <i class="fa fa-vk"></i></a><a title="Share to Telegram" href="tg://msg?text=%D0%A1%D0%BE%D0%B7%D0%B4%D0%B0%D0%BD%D0%B8%D0%B5+%D0%BF%D1%80%D0%BE%D0%B5%D0%BA%D1%82%D0%B0+%D0%B1%D0%B8%D0%B1%D0%BB%D0%B8%D0%BE%D1%82%D0%B5%D0%BA%D0%B8+%D0%BA%D0%BB%D0%B0%D1%81%D1%81%D0%BE%D0%B2+.NET+Core+2.1+%D1%81+%D0%B8%D1%81%D0%BF%D0%BE%D0%BB%D1%8C%D0%B7%D0%BE%D0%B2%D0%B0%D0%BD%D0%B8%D0%B5%D0%BC+ADO.NET: https://coderlessons.com/articles/veb-razrabotka-articles/sozdanie-proekta-biblioteki-klassov-net-core-2-1-s-ispolzovaniem-ado-net" data-type="link" class="telegram-share"> <i class="fa fa-telegram"></i></a><a title="Share by Email" href="mailto:?subject=Создание⠀проекта⠀библиотеки⠀классов⠀.NET⠀Core⠀2.1⠀с⠀использованием⠀ADO.NET&body=https://coderlessons.com/articles/veb-razrabotka-articles/sozdanie-proekta-biblioteki-klassov-net-core-2-1-s-ispolzovaniem-ado-net" data-type="link" class="email-share"> <i class="fa fa-envelope-o"></i></a>		</div>
		<div class="clear"></div>
	</div>
								</div>
							
							
														</div>

					</div>
				</article>

								<div class="saxon-post saxon-post-bottom">
					<div class="post-details-bottom">
						<div class="post-info-tags">
																											</div>
						
						<div class="post-info-wrapper">
						
												<div class="post-info-views"><i class="fa fa-eye" aria-hidden="true"></i>54</div>
												

						</div>

												<div class="post-info-share">
						  	<div class="post-social-wrapper">
        <div class="post-social-title">Share:</div>
		<div class="post-social">
			<a title="Share with VKontakte" href="https://coderlessons.com/articles/veb-razrabotka-articles/sozdanie-proekta-biblioteki-klassov-net-core-2-1-s-ispolzovaniem-ado-net" data-type="vk" data-title="Создание проекта библиотеки классов .NET Core 2.1 с использованием ADO.NET" data-image="" class="vk-share"> <i class="fa fa-vk"></i></a><a title="Share to Telegram" href="tg://msg?text=%D0%A1%D0%BE%D0%B7%D0%B4%D0%B0%D0%BD%D0%B8%D0%B5+%D0%BF%D1%80%D0%BE%D0%B5%D0%BA%D1%82%D0%B0+%D0%B1%D0%B8%D0%B1%D0%BB%D0%B8%D0%BE%D1%82%D0%B5%D0%BA%D0%B8+%D0%BA%D0%BB%D0%B0%D1%81%D1%81%D0%BE%D0%B2+.NET+Core+2.1+%D1%81+%D0%B8%D1%81%D0%BF%D0%BE%D0%BB%D1%8C%D0%B7%D0%BE%D0%B2%D0%B0%D0%BD%D0%B8%D0%B5%D0%BC+ADO.NET: https://coderlessons.com/articles/veb-razrabotka-articles/sozdanie-proekta-biblioteki-klassov-net-core-2-1-s-ispolzovaniem-ado-net" data-type="link" class="telegram-share"> <i class="fa fa-telegram"></i></a><a title="Share by Email" href="mailto:?subject=Создание⠀проекта⠀библиотеки⠀классов⠀.NET⠀Core⠀2.1⠀с⠀использованием⠀ADO.NET&body=https://coderlessons.com/articles/veb-razrabotka-articles/sozdanie-proekta-biblioteki-klassov-net-core-2-1-s-ispolzovaniem-ado-net" data-type="link" class="email-share"> <i class="fa fa-envelope-o"></i></a>		</div>
		<div class="clear"></div>
	</div>
							</div>
											</div>
				</div>
							</div>

													
			  <nav id="nav-below" class="navigation-post">
		
  		
    
  <div class="container-fluid">
  <div class="row">
          <div class="col-md-6 nav-post-prev saxon-post no-image">
                        <a href="https://coderlessons.com/articles/veb-razrabotka-articles/sozdanie-polzovatelskogo-displeia-dlia-biblioteki-google-analytics-embed" class="nav-post-title-link"><div class="nav-post-title">Назад</div><div class="nav-post-name">Создание пользовательского дисплея для библиотеки Google Analytics Embed</div></a>
        </div>
        <div class="col-md-6 nav-post-next saxon-post no-image">
        
      <a href="https://coderlessons.com/articles/veb-razrabotka-articles/polzovatelskii-komponent-konteinera-v-react-native-s-razlichnym-soderzhimym-i-stilem" class="nav-post-title-link"><div class="nav-post-title">Далее</div><div class="nav-post-name">Пользовательский компонент контейнера в React Native с различным содержимым и стилем</div></a>

              </div>

  </div>
  </div>  
  
  </nav>
  
			

			
			
		</div>
				<div class="col-md-4 post-sidebar sidebar sidebar-right" role="complementary">
		<ul id="post-sidebar">
				
		  <li id="saxon-categories-3" class="widget widget_saxon_categories"><h2 class="widgettitle">Категории</h2>
        <div class="post-categories">
            <a href="https://coderlessons.com/articles/veb-razrabotka-articles" data-style="">Веб разработка<span class="post-categories-counter">11825</span></a><a href="https://coderlessons.com/articles/java" data-style="">Java<span class="post-categories-counter">7473</span></a><a href="https://coderlessons.com/articles/programmirovanie" data-style="">Программирование<span class="post-categories-counter">3465</span></a><a href="https://coderlessons.com/articles/mobilnaia-razrabotka-articles" data-style="">Мобильная разработка<span class="post-categories-counter">2983</span></a><a href="https://coderlessons.com/articles/predprinimatelstvo" data-style="">Предпринимательство<span class="post-categories-counter">2337</span></a><a href="https://coderlessons.com/articles/devops-articles" data-style="">DevOps<span class="post-categories-counter">1817</span></a><a href="https://coderlessons.com/articles/wordpress" data-style="">Wordpress<span class="post-categories-counter">1583</span></a><a href="https://coderlessons.com/articles/dizain" data-style="">Дизайн<span class="post-categories-counter">1256</span></a><a href="https://coderlessons.com/articles/php" data-style="">PHP<span class="post-categories-counter">1191</span></a><a href="https://coderlessons.com/articles/bazy-dannykh-articles" data-style="">Базы данных<span class="post-categories-counter">947</span></a><a href="https://coderlessons.com/articles/ruby" data-style="">Ruby<span class="post-categories-counter">692</span></a><a href="https://coderlessons.com/articles/upravlenie-proektami" data-style="">Управление проектами<span class="post-categories-counter">232</span></a><a href="https://coderlessons.com/articles/ai-ml" data-style="">AI/ML<span class="post-categories-counter">25</span></a><a href="https://coderlessons.com/articles/go" data-style="">Go<span class="post-categories-counter">10</span></a><a href="https://coderlessons.com/articles/node-js" data-style="">Node.js<span class="post-categories-counter">8</span></a><a href="https://coderlessons.com/articles/testirovanie" data-style="">Тестирование<span class="post-categories-counter">8</span></a><a href="https://coderlessons.com/articles/gamedev" data-style="">GameDev<span class="post-categories-counter">7</span></a><a href="https://coderlessons.com/crypto" data-style="">Программирование в криптовалюте<span class="post-categories-counter">7</span></a>        </div>
            </li>
        <li id="saxon-list-posts-14" class="widget widget_saxon_list_entries">        <h2 class="widgettitle">Последние статьи</h2>
        <ul>

                <li class="template-postsmasonry1-2">
            <div class="saxon-postsmasonry1-post saxon-postsmasonry1_2-post saxon-post saxon-post-no-image format-"><div class="post-categories"><a href="https://coderlessons.com/articles" data-style="background-color: #81d742;">Статьи</a></div><div class="saxon-post-details">

     <h3 class="post-title"><a href="https://coderlessons.com/articles/programmirovanie/refaktoring-hudson-god-class">Рефакторинг Hudson God Class</a></h3><div class="post-date">Июнь 3, 2019</div></div></div>        </li>
                <li class="template-postsmasonry1-2">
            <div class="saxon-postsmasonry1-post saxon-postsmasonry1_2-post saxon-post saxon-post-no-image format-"><div class="post-categories"><a href="https://coderlessons.com/articles" data-style="background-color: #81d742;">Статьи</a></div><div class="saxon-post-details">

     <h3 class="post-title"><a href="https://coderlessons.com/articles/java/alternativy-sintaksisa-java-liambda">Альтернативы синтаксиса Java лямбда</a></h3><div class="post-date">Июнь 2, 2019</div></div></div>        </li>
                <li class="template-postsmasonry1-2">
            <div class="saxon-postsmasonry1-post saxon-postsmasonry1_2-post saxon-post saxon-post-no-image format-"><div class="post-categories"><a href="https://coderlessons.com/articles" data-style="background-color: #81d742;">Статьи</a></div><div class="saxon-post-details">

     <h3 class="post-title"><a href="https://coderlessons.com/articles/java/morphia-i-mongodb-razvivaiushchiesia-struktury-dokumentov">Morphia и MongoDB: развивающиеся структуры документов</a></h3><div class="post-date">Май 29, 2019</div></div></div>        </li>
                <li class="template-postsmasonry1-2">
            <div class="saxon-postsmasonry1-post saxon-postsmasonry1_2-post saxon-post saxon-post-no-image format-"><div class="post-categories"><a href="https://coderlessons.com/articles" data-style="background-color: #81d742;">Статьи</a></div><div class="saxon-post-details">

     <h3 class="post-title"><a href="https://coderlessons.com/articles/java/openshift-express-razvertyvanie-prilozheniia-java-ee-s-podderzhkoi-as7">OpenShift Express: развертывание приложения Java EE (с поддержкой AS7)</a></h3><div class="post-date">Май 29, 2019</div></div></div>        </li>
                <li class="template-postsmasonry1-2">
            <div class="saxon-postsmasonry1-post saxon-postsmasonry1_2-post saxon-post saxon-post-no-image format-"><div class="post-categories"><a href="https://coderlessons.com/articles" data-style="background-color: #81d742;">Статьи</a></div><div class="saxon-post-details">

     <h3 class="post-title"><a href="https://coderlessons.com/articles/java/integratsiia-jqgrid-rest-ajax-i-spring-mvc">Интеграция jqGrid, REST, AJAX и Spring MVC</a></h3><div class="post-date">Май 29, 2019</div></div></div>        </li>
        
        </ul>
        </li>
<li id="custom_html-8" class="widget_text widget widget_custom_html"><div class="textwidget custom-html-widget"><div class="rl_cnt_bg" data-id="289286"></div></div></li>
<li id="custom_html-9" class="widget_text widget widget_custom_html"><div class="textwidget custom-html-widget"><div class="rl_cnt_bg" data-id="289288"></div></div></li>
<li id="custom_html-10" class="widget_text widget widget_custom_html"><div class="textwidget custom-html-widget"><div class="rl_cnt_bg" data-id="289289"></div></div></li>
		</ul>
		</div>
			</div>
	</div>
</div>








<a class="scroll-to-top btn alt" aria-label="Scroll to top" href="#top"></a>

<div class="footer-wrapper">
  <footer class="footer-black">
      <div class="container">
        <div class="row">
            
            
                        <div class="col-md-12 footer-menu" role="navigation">
                        </div>
                        <div class="col-md-12 col-sm-12 footer-copyright">
                <p>© Copyright 2024 <a href="https://coderlessons.com">CoderLessons.com</a></p>            </div>

        </div>
      </div>
    </footer>
</div>




<script type='text/javascript'>
"use strict";var _createClass=function(){function defineProperties(target,props){for(var i=0;i<props.length;i++){var descriptor=props[i];descriptor.enumerable=descriptor.enumerable||!1,descriptor.configurable=!0,"value"in descriptor&&(descriptor.writable=!0),Object.defineProperty(target,descriptor.key,descriptor)}}return function(Constructor,protoProps,staticProps){return protoProps&&defineProperties(Constructor.prototype,protoProps),staticProps&&defineProperties(Constructor,staticProps),Constructor}}();function _classCallCheck(instance,Constructor){if(!(instance instanceof Constructor))throw new TypeError("Cannot call a class as a function")}var RocketBrowserCompatibilityChecker=function(){function RocketBrowserCompatibilityChecker(options){_classCallCheck(this,RocketBrowserCompatibilityChecker),this.passiveSupported=!1,this._checkPassiveOption(this),this.options=!!this.passiveSupported&&options}return _createClass(RocketBrowserCompatibilityChecker,[{key:"_checkPassiveOption",value:function(self){try{var options={get passive(){return!(self.passiveSupported=!0)}};window.addEventListener("test",null,options),window.removeEventListener("test",null,options)}catch(err){self.passiveSupported=!1}}},{key:"initRequestIdleCallback",value:function(){!1 in window&&(window.requestIdleCallback=function(cb){var start=Date.now();return setTimeout(function(){cb({didTimeout:!1,timeRemaining:function(){return Math.max(0,50-(Date.now()-start))}})},1)}),!1 in window&&(window.cancelIdleCallback=function(id){return clearTimeout(id)})}},{key:"isDataSaverModeOn",value:function(){return"connection"in navigator&&!0===navigator.connection.saveData}},{key:"supportsLinkPrefetch",value:function(){var elem=document.createElement("link");return elem.relList&&elem.relList.supports&&elem.relList.supports("prefetch")&&window.IntersectionObserver&&"isIntersecting"in IntersectionObserverEntry.prototype}},{key:"isSlowConnection",value:function(){return"connection"in navigator&&"effectiveType"in navigator.connection&&("2g"===navigator.connection.effectiveType||"slow-2g"===navigator.connection.effectiveType)}}]),RocketBrowserCompatibilityChecker}();
</script>
<script type='text/javascript'>
class RocketLazyLoadScripts{constructor(t,e){this.attrName="data-rocketlazyloadscript",this.browser=e,this.options=this.browser.options,this.triggerEvents=t,this.userEventListener=this.triggerListener.bind(this),window.addEventListener("touchstart",function(){})}init(){this._addEventListener(this)}reset(){this._removeEventListener(this)}_addEventListener(t){this.triggerEvents.forEach(e=>window.addEventListener(e,t.userEventListener,t.options))}_removeEventListener(t){this.triggerEvents.forEach(e=>window.removeEventListener(e,t.userEventListener,t.options))}_loadScriptSrc(){const t=document.querySelectorAll(`script[${this.attrName}]`);0!==t.length?(Array.prototype.slice.call(t).forEach(t=>{const e=t.getAttribute(this.attrName);t.setAttribute("src",e),t.removeAttribute(this.attrName)}),this.reset()):this.reset()}triggerListener(t){if(t&&t.target){if("A"==t.target.tagName)return;if("I"==t.target.tagName&&"fa fa-bars"==t.target.className)return}this._loadScriptSrc(),this._removeEventListener(this)}static run(){if(!RocketBrowserCompatibilityChecker)return;const t=new RocketBrowserCompatibilityChecker({passive:!0});new RocketLazyLoadScripts(["keydown","mouseover","touchmove","touchstart"],t).init()}}RocketLazyLoadScripts.run();
</script>
<script type='text/javascript'>
/* <![CDATA[ */
var RocketPreloadLinksConfig = {"excludeUris":"\/(.+\/)?feed\/?.+\/?|\/(?:.+\/)?embed\/|\/(index\\.php\/)?wp\\-json(\/.*|$)|\/wp-admin|\/logout|\/wp-login.php","usesTrailingSlash":"","imageExt":"jpg|jpeg|gif|png|tiff|bmp|webp|avif","fileExt":"jpg|jpeg|gif|png|tiff|bmp|webp|avif|php|pdf|html|htm","siteUrl":"https:\/\/coderlessons.com","onHoverDelay":"100","rateThrottle":"3"};
/* ]]> */
</script>
<script type='text/javascript'>
(function() {
"use strict";var r="function"==typeof Symbol&&"symbol"==typeof Symbol.iterator?function(e){return typeof e}:function(e){return e&&"function"==typeof Symbol&&e.constructor===Symbol&&e!==Symbol.prototype?"symbol":typeof e},e=function(){function i(e,t){for(var n=0;n<t.length;n++){var i=t[n];i.enumerable=i.enumerable||!1,i.configurable=!0,"value"in i&&(i.writable=!0),Object.defineProperty(e,i.key,i)}}return function(e,t,n){return t&&i(e.prototype,t),n&&i(e,n),e}}();function i(e,t){if(!(e instanceof t))throw new TypeError("Cannot call a class as a function")}var t=function(){function n(e,t){i(this,n),this.browser=e,this.config=t,this.options=this.browser.options,this.prefetched=new Set,this.eventTime=null,this.threshold=1111,this.numOnHover=0}return e(n,[{key:"init",value:function(){!this.browser.supportsLinkPrefetch()||this.browser.isDataSaverModeOn()||this.browser.isSlowConnection()||(this.regex={excludeUris:RegExp(this.config.excludeUris,"i"),images:RegExp(".("+this.config.imageExt+")$","i"),fileExt:RegExp(".("+this.config.fileExt+")$","i")},this._initListeners(this))}},{key:"_initListeners",value:function(e){-1<this.config.onHoverDelay&&document.addEventListener("mouseover",e.listener.bind(e),e.listenerOptions),document.addEventListener("mousedown",e.listener.bind(e),e.listenerOptions),document.addEventListener("touchstart",e.listener.bind(e),e.listenerOptions)}},{key:"listener",value:function(e){var t=e.target.closest("a"),n=this._prepareUrl(t);if(null!==n)switch(e.type){case"mousedown":case"touchstart":this._addPrefetchLink(n);break;case"mouseover":this._earlyPrefetch(t,n,"mouseout")}}},{key:"_earlyPrefetch",value:function(t,e,n){var i=this,r=setTimeout(function(){if(r=null,0===i.numOnHover)setTimeout(function(){return i.numOnHover=0},1e3);else if(i.numOnHover>i.config.rateThrottle)return;i.numOnHover++,i._addPrefetchLink(e)},this.config.onHoverDelay);t.addEventListener(n,function e(){t.removeEventListener(n,e,{passive:!0}),null!==r&&(clearTimeout(r),r=null)},{passive:!0})}},{key:"_addPrefetchLink",value:function(i){return this.prefetched.add(i.href),new Promise(function(e,t){var n=document.createElement("link");n.rel="prefetch",n.href=i.href,n.onload=e,n.onerror=t,document.head.appendChild(n)}).catch(function(){})}},{key:"_prepareUrl",value:function(e){if(null===e||"object"!==(void 0===e?"undefined":r(e))||!1 in e||-1===["http:","https:"].indexOf(e.protocol))return null;var t=e.href.substring(0,this.config.siteUrl.length),n=this._getPathname(e.href,t),i={original:e.href,protocol:e.protocol,origin:t,pathname:n,href:t+n};return this._isLinkOk(i)?i:null}},{key:"_getPathname",value:function(e,t){var n=t?e.substring(this.config.siteUrl.length):e;return n.startsWith("/")||(n="/"+n),this._shouldAddTrailingSlash(n)?n+"/":n}},{key:"_shouldAddTrailingSlash",value:function(e){return this.config.usesTrailingSlash&&!e.endsWith("/")&&!this.regex.fileExt.test(e)}},{key:"_isLinkOk",value:function(e){return null!==e&&"object"===(void 0===e?"undefined":r(e))&&(!this.prefetched.has(e.href)&&e.origin===this.config.siteUrl&&-1===e.href.indexOf("?")&&-1===e.href.indexOf("#")&&!this.regex.excludeUris.test(e.href)&&!this.regex.images.test(e.href))}}],[{key:"run",value:function(){"undefined"!=typeof RocketPreloadLinksConfig&&new n(new RocketBrowserCompatibilityChecker({capture:!0,passive:!0}),RocketPreloadLinksConfig).init()}}]),n}();t.run();
}());
</script>












<script>window.lazyLoadOptions={elements_selector:"img[data-lazy-src],.rocket-lazyload",data_src:"lazy-src",data_srcset:"lazy-srcset",data_sizes:"lazy-sizes",class_loading:"lazyloading",class_loaded:"lazyloaded",threshold:300,callback_loaded:function(element){if(element.tagName==="IFRAME"&&element.dataset.rocketLazyload=="fitvidscompatible"){if(element.classList.contains("lazyloaded")){if(typeof window.jQuery!="undefined"){if(jQuery.fn.fitVids){jQuery(element).parent().fitVids()}}}}}};window.addEventListener('LazyLoad::Initialized',function(e){var lazyLoadInstance=e.detail.instance;if(window.MutationObserver){var observer=new MutationObserver(function(mutations){var image_count=0;var iframe_count=0;var rocketlazy_count=0;mutations.forEach(function(mutation){for(i=0;i<mutation.addedNodes.length;i++){if(typeof mutation.addedNodes[i].getElementsByTagName!=='function'){continue}
if(typeof mutation.addedNodes[i].getElementsByClassName!=='function'){continue}
images=mutation.addedNodes[i].getElementsByTagName('img');is_image=mutation.addedNodes[i].tagName=="IMG";iframes=mutation.addedNodes[i].getElementsByTagName('iframe');is_iframe=mutation.addedNodes[i].tagName=="IFRAME";rocket_lazy=mutation.addedNodes[i].getElementsByClassName('rocket-lazyload');image_count+=images.length;iframe_count+=iframes.length;rocketlazy_count+=rocket_lazy.length;if(is_image){image_count+=1}
if(is_iframe){iframe_count+=1}}});if(image_count>0||iframe_count>0||rocketlazy_count>0){lazyLoadInstance.update()}});var b=document.getElementsByTagName("body")[0];var config={childList:!0,subtree:!0};observer.observe(b,config)}},!1)</script><script data-no-minify="1" async src="https://coderlessons.com/wp-content/plugins/wp-rocket/assets/js/lazyload/16.1/lazyload.min.js"></script><!-- Yandex.Metrika counter -->

<noscript><div><img src="https://mc.yandex.ru/watch/54595627" style="position:absolute; left:-9999px;" alt="" /></div></noscript>
<!-- /Yandex.Metrika counter -->
<script>"use strict";var wprRemoveCPCSS=function wprRemoveCPCSS(){var elem;document.querySelector('link[data-rocket-async="style"][rel="preload"]')?setTimeout(wprRemoveCPCSS,200):(elem=document.getElementById("rocket-critical-css"))&&"remove"in elem&&elem.remove()};window.addEventListener?window.addEventListener("load",wprRemoveCPCSS):window.attachEvent&&window.attachEvent("onload",wprRemoveCPCSS);</script><script src="https://coderlessons.com/wp-content/cache/min/1/31d12193e4cb16e69e26e968bb79b73e.js" data-minify="1" defer></script><noscript><link rel="stylesheet" href="https://coderlessons.com/wp-content/cache/min/1/19d33e39b7c587b839152fc8a61b9d10.css" media="all" data-minify="1" /></noscript></body>
</html>

<!-- This website is like a Rocket, isn't it? Performance optimized by WP Rocket. Learn more: https://wp-rocket.me -->