TableAdapter exception with joins
<p>I build asp.net application, for db i use TableAdapter. 
Select Query</p>

<pre><code>SELECT
    U.empID,
    U.firstName,
    U.lastName,
    R.name AS Role
FROM
    USER_T AS U
INNER JOIN USER_ROLES_T AS UR ON U.empID = UR.empID
INNER JOIN ROLES_T AS R ON UR.roleID = R.typeID
</code></pre>

<p><code>empId</code> with constraint <code>primary key</code>. Employee has many role attributes, it named role.</p>

<p>When I perform request for user data from db:</p>

<pre><code>UsersTableAdapter usersTableAdapter = new UsersTableAdapter();
DataBase.UsersDataTable users = usersTableAdapter.GetUsers();
</code></pre>

<p>I get following exception:</p>

<blockquote>
  <p>Controllers.UI.Login.LoginController|System.Data.ConstraintException:
  Failed to</p>
  
  <p>enable constraints. One or more rows contain values violating
  non-null, unique, or foreign-key constraints.</p>
</blockquote>

<p>If I perform request select-request with any admin program it get</p>

<pre><code>    28 Roman Ivanov Admin
    28 Roman Ivanov Developer
</code></pre>

<p>I understand, this happens because of <code>primary key empId</code>, how can this problem get solved? How can i remove a primary key from adapter?</p>