<p>출처1 : <a href="https://mysqlconnector.net/" target="_blank">https://mysqlconnector.net/</a><br></p><p>출처2 :&nbsp;<a href="https://github.com/mysql-net/MySqlConnector" target="_blank">https://github.com/mysql-net/MySqlConnector</a></p><p><br></p><div style="color: rgb(212, 212, 212); background-color: rgb(30, 30, 30); font-family: Consolas, &quot;Courier New&quot;, monospace; font-size: 14px; line-height: 19px; white-space: pre;">Install-Package&nbsp;MySqlConnector&nbsp;-Version&nbsp;1.2.0</div><p><br></p><p>닷넷에서 mysql을 사용하도록 해주는 오픈소스 커넥터이다.</p><p>근데 nuget에서 설치시에 ms 라이선스를 동의하라고 나오더라. </p><p>참고하고 있는 다른 파일들 때문인거 같은데 자세한 내용은 나중에 확인해 봐야겠다.</p><p><br></p><p>아래는 DataTable과 DataSet으로 받을 수 있는 샘플이다.&nbsp;</p><p><br></p><p><br></p><p><br></p><div style="color: rgb(212, 212, 212); background-color: rgb(30, 30, 30); font-family: Consolas, &quot;Courier New&quot;, monospace; font-size: 14px; line-height: 19px; white-space: pre;"><div><span style="color: #6a9955;">//&nbsp;DataAdapter&nbsp;with&nbsp;DataTable</span></div><div><span style="color: #c586c0;">using</span>&nbsp;(<span style="color: #4ec9b0;">var</span>&nbsp;<span style="color: #4ec9b0;">connection</span>&nbsp;=&nbsp;<span style="color: #4ec9b0;">new</span>&nbsp;<span style="color: #4ec9b0;">MySqlConnection</span>("<span style="color: #4ec9b0;">Server</span>=<span style="color: #4ec9b0;">localhost</span>;<span style="color: #4ec9b0;">User</span>&nbsp;<span style="color: #9cdcfe;">ID</span>=<span style="color: #9cdcfe;">user</span>;<span style="color: #9cdcfe;">Password</span>=<span style="color: #9cdcfe;">pwd</span>;<span style="color: #9cdcfe;">Database</span>=<span style="color: #9cdcfe;">db</span><span style="color: #ce9178;">")</span><span style="color: #f44747;">)</span></div><div>{</div><div>&nbsp;&nbsp;&nbsp;&nbsp;<span style="color: #9cdcfe;">connection</span>.<span style="color: #dcdcaa;">Open</span>();</div><div>&nbsp;&nbsp;&nbsp;&nbsp;<span style="color: #569cd6;">string</span>&nbsp;<span style="color: #9cdcfe;">query</span>&nbsp;=&nbsp;<span style="color: #ce9178;">"SELECT&nbsp;*&nbsp;FROM&nbsp;tcp_company;"</span>;</div><br><div>&nbsp;&nbsp;&nbsp;&nbsp;<span style="color: #6a9955;">//&nbsp;with&nbsp;DataAdapter&nbsp;</span></div><div>&nbsp;&nbsp;&nbsp;&nbsp;<span style="color: #4ec9b0;">MySqlDataAdapter</span>&nbsp;<span style="color: #9cdcfe;">adr</span>&nbsp;=&nbsp;<span style="color: #569cd6;">new</span>&nbsp;<span style="color: #4ec9b0;">MySqlDataAdapter</span>(<span style="color: #9cdcfe;">query</span>,&nbsp;<span style="color: #9cdcfe;">connection</span>);</div><div>&nbsp;&nbsp;&nbsp;&nbsp;<span style="color: #9cdcfe;">adr</span>.<span style="color: #9cdcfe;">SelectCommand</span>.<span style="color: #9cdcfe;">CommandType</span>&nbsp;=&nbsp;<span style="color: #9cdcfe;">CommandType</span>.<span style="color: #9cdcfe;">Text</span>;</div><br><div>&nbsp;&nbsp;&nbsp;&nbsp;<span style="color: #4ec9b0;">DataTable</span>&nbsp;<span style="color: #9cdcfe;">dt</span>&nbsp;=&nbsp;<span style="color: #569cd6;">new</span>&nbsp;<span style="color: #4ec9b0;">DataTable</span>();</div><div>&nbsp;&nbsp;&nbsp;&nbsp;<span style="color: #9cdcfe;">adr</span>.<span style="color: #dcdcaa;">Fill</span>(<span style="color: #9cdcfe;">dt</span>);&nbsp;<span style="color: #6a9955;">//opens&nbsp;and&nbsp;closes&nbsp;the&nbsp;DB&nbsp;connection&nbsp;automatically&nbsp;!!&nbsp;(fetches&nbsp;from&nbsp;pool)</span></div><br><div>&nbsp;&nbsp;&nbsp;&nbsp;<span style="color: #c586c0;">foreach</span>&nbsp;(<span style="color: #4ec9b0;">DataRow</span>&nbsp;<span style="color: #9cdcfe;">dr</span>&nbsp;<span style="color: #c586c0;">in</span>&nbsp;<span style="color: #9cdcfe;">dt</span>.<span style="color: #9cdcfe;">Rows</span>)</div><div>&nbsp;&nbsp;&nbsp;&nbsp;{</div><div>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<span style="color: #9cdcfe;">Console</span>.<span style="color: #dcdcaa;">WriteLine</span>(<span style="color: #9cdcfe;">string</span>.<span style="color: #dcdcaa;">Format</span>(<span style="color: #ce9178;">"Name&nbsp;=&nbsp;{0}"</span>,&nbsp;<span style="color: #9cdcfe;">dr</span>[<span style="color: #ce9178;">"Name"</span>].<span style="color: #dcdcaa;">ToString</span>()));</div><div>&nbsp;&nbsp;&nbsp;&nbsp;}</div><div>}</div><br><br><br><div><span style="color: #6a9955;">//&nbsp;DataAdapter&nbsp;with&nbsp;DataSet</span></div><div><span style="color: #c586c0;">using</span>&nbsp;(<span style="color: #4ec9b0;">var</span>&nbsp;<span style="color: #4ec9b0;">connection</span>&nbsp;=&nbsp;<span style="color: #4ec9b0;">new</span>&nbsp;<span style="color: #4ec9b0;">MySqlConnection</span>("<span style="color: #4ec9b0;">Server</span>=<span style="color: #4ec9b0;">localhost</span>;<span style="color: #4ec9b0;">User</span>&nbsp;<span style="color: #9cdcfe;">ID</span>=<span style="color: #9cdcfe;">user</span>;<span style="color: #9cdcfe;">Password</span>=<span style="color: #9cdcfe;">pwd</span>;<span style="color: #9cdcfe;">Database</span>=<span style="color: #9cdcfe;">db</span><span style="color: #ce9178;">")</span><span style="color: #f44747;">)</span></div><div>{</div><div>&nbsp;&nbsp;&nbsp;&nbsp;<span style="color: #9cdcfe;">connection</span>.<span style="color: #dcdcaa;">Open</span>();</div><div>&nbsp;&nbsp;&nbsp;&nbsp;<span style="color: #569cd6;">string</span>&nbsp;<span style="color: #9cdcfe;">query</span>&nbsp;=&nbsp;<span style="color: #ce9178;">@"SELECT&nbsp;*&nbsp;FROM&nbsp;tcp_company;&nbsp;</span></div><div><span style="color: #ce9178;">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;SELECT&nbsp;*&nbsp;from&nbsp;tcp_admin;"</span>;</div><br><div>&nbsp;&nbsp;&nbsp;&nbsp;<span style="color: #4ec9b0;">DataSet</span>&nbsp;<span style="color: #9cdcfe;">ds</span>&nbsp;=&nbsp;<span style="color: #569cd6;">new</span>&nbsp;<span style="color: #4ec9b0;">DataSet</span>();</div><div>&nbsp;&nbsp;&nbsp;&nbsp;<span style="color: #c586c0;">using</span>&nbsp;(<span style="color: #4ec9b0;">DbCommand</span>&nbsp;<span style="color: #9cdcfe;">command</span>&nbsp;=&nbsp;<span style="color: #9cdcfe;">connection</span>.<span style="color: #dcdcaa;">CreateCommand</span>())</div><div>&nbsp;&nbsp;&nbsp;&nbsp;{</div><div>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<span style="color: #9cdcfe;">command</span>.<span style="color: #9cdcfe;">CommandText</span>&nbsp;=&nbsp;<span style="color: #9cdcfe;">query</span>;</div><br><div>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<span style="color: #c586c0;">using</span>&nbsp;(<span style="color: #4ec9b0;">DbDataReader</span>&nbsp;<span style="color: #9cdcfe;">reader</span>&nbsp;=&nbsp;<span style="color: #9cdcfe;">command</span>.<span style="color: #dcdcaa;">ExecuteReader</span>())</div><div>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;{</div><div>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<span style="color: #c586c0;">while</span>&nbsp;(!<span style="color: #9cdcfe;">reader</span>.<span style="color: #9cdcfe;">IsClosed</span>)</div><div>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;{</div><div>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<span style="color: #4ec9b0;">DataTable</span>&nbsp;<span style="color: #9cdcfe;">dtt</span>&nbsp;=&nbsp;<span style="color: #569cd6;">new</span>&nbsp;<span style="color: #4ec9b0;">DataTable</span>();</div><div>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<span style="color: #9cdcfe;">dtt</span>.<span style="color: #dcdcaa;">Load</span>(<span style="color: #9cdcfe;">reader</span>);</div><div>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<span style="color: #9cdcfe;">ds</span>.<span style="color: #9cdcfe;">Tables</span>.<span style="color: #dcdcaa;">Add</span>(<span style="color: #9cdcfe;">dtt</span>);</div><br><div>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;}</div><div>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;}</div><div>&nbsp;&nbsp;&nbsp;&nbsp;}</div><br><div>&nbsp;&nbsp;&nbsp;&nbsp;<span style="color: #c586c0;">foreach</span>&nbsp;(<span style="color: #4ec9b0;">DataTable</span>&nbsp;<span style="color: #9cdcfe;">dt</span>&nbsp;<span style="color: #c586c0;">in</span>&nbsp;<span style="color: #9cdcfe;">ds</span>.<span style="color: #9cdcfe;">Tables</span>)</div><div>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<span style="color: #c586c0;">foreach</span>&nbsp;(<span style="color: #4ec9b0;">DataRow</span>&nbsp;<span style="color: #9cdcfe;">dr</span>&nbsp;<span style="color: #c586c0;">in</span>&nbsp;<span style="color: #9cdcfe;">dt</span>.<span style="color: #9cdcfe;">Rows</span>)</div><div>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;{</div><div>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<span style="color: #9cdcfe;">Console</span>.<span style="color: #dcdcaa;">WriteLine</span>(<span style="color: #9cdcfe;">string</span>.<span style="color: #dcdcaa;">Format</span>(<span style="color: #ce9178;">"Name&nbsp;=&nbsp;{0}"</span>,&nbsp;<span style="color: #9cdcfe;">dr</span>[<span style="color: #ce9178;">"Name"</span>].<span style="color: #dcdcaa;">ToString</span>()));</div><div>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;}</div><div>}</div></div><p><br></p><p><br></p><p><br></p><p><br></p><p><br></p><p><br></p><p><br></p><p><br></p>

[C#] 닷넷에서 oracle 커넥터를 쓰지않고 mysql/mariadb 접속하기 MySqlConnector