The type 'MySqlConnection' exists in both 'MySql.Data Issue

Question

I have Referenced MySql.Data on one project and Other project referenced nuget package which also referenced MySqlConnector inside of it. projects has dependency .

when i compile application im getting this error

This is application hierarchy

is there any way to avoid this? or did i do anything wrong when referencing packages?

Thanks

UPDATE this is the same namespaces from difference libs

UPDATE 2

This is the sample repo which reproduced same issue

Either use the fully qualified type name, or a using qualifier at the head of the cs file to disambiguate. — Matt
– Matt, Commented Feb 8, 2018 at 10:30
@Matt thanks. problem is both have same namespaces please have a look i have updated post. — Gayan
– Gayan, Commented Feb 8, 2018 at 10:36
Well then how is the compiler meant to know which one to use? — Christopher Lake
– Christopher Lake, Commented Feb 8, 2018 at 10:50
If you google "c# type exists in both assemblies" - you will find a lot of questions about the same issue. If nothing from those questions help - please include what you tried in question. — Evk
– Evk, Commented Feb 8, 2018 at 10:54

AlbertK · Accepted Answer · 2018-02-08 13:37:51Z

16

In NET.Framework projects you can go to the reference properties and set an alias for assembly. Net core projects doesn't fully support yet aliases for assemblies. But there is a workaround to use aliases in .net core. Edit your csproj file like this:

<Project Sdk="Microsoft.NET.Sdk.Web">
...

  <Target Name="ChangeAliasesOfStrongNameAssemblies" BeforeTargets="FindReferenceAssembliesForReferences;ResolveReferences">
    <ItemGroup>
      <ReferencePath Condition="'%(FileName)' == 'MySqlConnector'">
        <Aliases>MySqlConnectorAlias</Aliases>
      </ReferencePath>
    </ItemGroup>
  </Target>
...
</Project>

then in your cs file before all usings:

extern alias MySqlConnectorAlias;

then you can reference to you type from MySqlConnector like this:

MySqlConnectorAlias::MySql.Data.MySqlClient.MySqlConnection

answered Feb 8, 2018 at 13:37

AlbertK

13.5k5 gold badges45 silver badges42 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

Ben Over a year ago

Hi Albertk, I am trying to use your suggestion in my code as:

MySqlConnectorAlias::MySql.Data.MySqlClient.MySqlConnection mysql =                 new MySqlConnectorAlias::MySql.Data.MySqlClient.MySqlConnection();

and then get the error Cannot resolve symbole MySql. MySql.Data.MySqlClient are all read in my case. Can you please help? Thanks

AlbertK Over a year ago

It is hard to say for sure. Are you using Resharper? If yes then try to follow answers given here: 1, 2, 3

hardik patel · Accepted Answer · 2019-11-13 06:12:21Z

1

It will work If you remove mysql.data reference from Your project/references.

Hope it will work for you. for me it was worked. My project is ASP.NET Core Framework. Created project in VS2017 and opening in VS2019 at that time it introduced.

answered Nov 13, 2019 at 6:12

hardik patel

2784 silver badges9 bronze badges

Collectives™ on Stack Overflow

The type 'MySqlConnection' exists in both 'MySql.Data Issue

2 Answers 2

2 Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

2 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related