I created a C# library to write all the functions, I added the database as Entity data module( .edmx),
Database name is SchoolDB, When i create the object as SchoolDB school= new SchoolDB(), excel cant read app.config file to get the connection string,
When i hard code the Connections string & create the object as SchoolDB school = new School(Conn), functions work properly in Excel,
My app.config file is this
<?xml version="1.0" encoding="utf-8"?>
<add name="SchoolDataBase" connectionString="metadata=res://;provider=System.Data.SqlClient;provider connection string='Data Source=danu001\;Initial Catalog=school;Persist Security Info=True;User ID=DB;Password=log@12345;MultipleActiveResultSets=True'"
Does any one can help me with this problem, why cant excel read my app.config file?
Thank you Danu123