Hi @Admin - Priti Prakash Jagtap , welcome to Microsoft Q&A forum.
It looks an issue with the connection string itself as you mentioned as you might be trying to use the connection string in ADO objects. Can you remove everything from connectionstring and keep the string between '"' as below:
From this:
<add name="yourdatabase" connectionString="metadata=res://*/Data.Model.AdvertisingModel.csdl|res://*/Data.Model.AdvertisingModel.ssdl|res://*/Data.Model.AdvertisingModel.msl;provider=System.Data.SqlClient;provider connection string="data source=*****;initial catalog=****;integrated security=True;MultipleActiveResultSets=True;App=EntityFramework"" providerName="System.Data.EntityClient" />
To this:
<add name="yourdatabase" connectionString="data source=*****;initial catalog=****;integrated security=True;MultipleActiveResultSets=True;App=EntityFramework" providerName="System.Data.EntityClient" />
Reference article:
https://stackoverflow.com/questions/34635822/how-do-i-solve-keyword-not-supported-metadata
Please let us know if this works or else we can discuss further.
----------
If answer helps, please select 'Accept Answer' as this could help other community members looking for similar queries.
Thanks @Erik Philips for pointing it out. Actually I was basically trying to say how should we use the connection string by removing metadata from the string. Above was just an example to show that.
But you are right I should have been more careful with it and mentioned proper connection string. Apologies for the inconvenience caused.