Keyword not supported: 'data source' in entity framework with azure function

Question

I am using azure function to triggerQueue with entity framework getting 'data source is not supported' error while using entity framework.My connection string is

Following is the code where I am getting error

 var connString = ConfigurationManager.ConnectionStrings["ACIGPSDBConnection"].ConnectionString;
                using (var db = new ACIGPSDBConnection(connString))
                {
                    if (!string.IsNullOrWhiteSpace(myQueueItem))
                    {
                        var breadCrumbList = JsonConvert.DeserializeObject<IList<BreadCrumb>>(myQueueItem);
                        if (breadCrumbList != null && breadCrumbList.Count() > 0)
                        {

                            var activeRouteJob = from j in db.Jobs
                                                 join rj in db.RouteJobs on j.Id equals rj.JobID
                                                 where j.IsActive == true && j.EndDate > DateTime.UtcNow &&
                                                      breadCrumbList.Any(a => a.CarrierId == rj.CarrierID)
                                                 select new RouteJobDelivery
                                                 {
                                                     RouteJobId = rj.Id,
                                                     StartDate = j.StartDate,
                                                     EndDate = j.EndDate
                                                 };
 <add name="ACIGPSDBConnection"
         connectionString="metadata=res://*/ACIGPSDataContext.csdl|res://*/ACIGPSDataContext.ssdl|res://*/ACIGPSDataContext.msl;
         provider=System.Data.SqlClient;provider connection string=&quot; 
         Data source=sqlsrv-scu-dev.database.windows.net;
         initial catalog=md_ACI-dev;user id=;password=;
         MultipleActiveResultSets=True;App=EntityFramework&quot;" providerName="System.Data.EntityClient" />

Tried with the follwing things 1) try with changing providerName from System.Data.EntityClient to System.Data.SqlClient 2) tried removing $quot to single quote 3) tried removing MultipleActiveResultSets=True 4)tried In azure,Select App->Application settings->New connection string->Save

Edit: code imageError Code CodeImage

Can you show the full exception message and the code where you use the connection string? — DavidG, Jun 21 '19 at 09:20
No, I'm not going to look at images of error messages and code, if you need help, [edit] the question and add the text here. — DavidG, Jun 21 '19 at 09:36

score 0 · Answer 1 · answered Jun 25 '19 at 08:38

I think the problem may still be in the escaping of characters.

If there would be a quote in the connectionString value, as the value itself is enclosed in quotes. The quote in the value will be escaped to & quot ; .

I suggest you try the following:

Try to hardcode this connection string into the code instead of getting it from the configuration file to see if there is any error.
If you get a success in step 1, then you get back to get connection string from configuration file. But, you add a output or set a breakpoint before you use it. In this way, you can check if you get the connection string in a right format.
If you want to get the connection string from Azure app settings, then replace & quot ; with a " .

score -1 · Answer 2 · answered Jun 21 '19 at 09:17

-1

Try removing MultipleActiveResultSets = True from connection string and it will works.

answered Jun 21 '19 at 09:17

Joey Cai

18,968
1
20
30

Enter connectionstring in appsetting: Select App -> Application Settings -> Enter new Connection String -> Save – Joey Cai Jun 21 '19 at 09:19
Pretty sure this will not change anything. – DavidG Jun 21 '19 at 09:19
Make sure you also select ‘Custom’ instead of ‘SQL Azure’ for your Entity Framework connection string, even though the database runs on Azure. – Joey Cai Jun 21 '19 at 09:23
@JoeyCai Yes I made it as Custom type only.Still not working – Dnyaneshwar Shivbhakta Jun 21 '19 at 12:07

Keyword not supported: 'data source' in entity framework with azure function

2 Answers2