LinqConnect for Metro connection string problem

LinqConnect for Metro connection string problem

Postby Zainab » Mon 28 Oct 2013 10:32

Hello there,

I'm try to connect to my windows azure sql database, here is my connection string:

public const string DefaultConnectionString = "Data Source=xxxxxxxxxx.database.windows.net:yyyy;database=TaskList;user=clinicDatabase@xxxxxxxxxx;password=******;encrypt=true;hostNameInCertificate=*.database.windows.net;loginTimeout=30";

but it gives me the following error:

Unknown connection string parameter "database"

Is there a certain format for windows azure sql?

Thanks in advance
Zainab
 
Posts: 4
Joined: Mon 28 Oct 2013 10:14

Re: LinqConnect for Metro connection string problem

Postby MariiaI » Mon 28 Oct 2013 10:52

LinqConnect for Metro doesn't allow connections to SQL Azure due to the fact LinqConnect relies on the standard System.Data.SqlClient provider to connect to SQL Server and SQL Azure. As this provider is not available for Metro-style applications, LinqConnect for Metro doesn't support it.
Please refer to:
http://www.devart.com/linqconnect/editions.html
http://www.devart.com/linqconnect/metro-database-access-with-linqconnect.html
MariiaI
Devart Team
 
Posts: 1472
Joined: Mon 13 Feb 2012 08:17

Re: LinqConnect for Metro connection string problem

Postby Zainab » Tue 29 Oct 2013 03:49

Is there any way around it please? I only have windows azure database as a global storage place.

Thanks in advance
Zainab
 
Posts: 4
Joined: Mon 28 Oct 2013 10:14

Re: LinqConnect for Metro connection string problem

Postby MariiaI » Tue 29 Oct 2013 11:50

There is no workaround for Windows Store applications and LinqConnect for Metro in this case. Windows store applications and LinqConnect for Metro don't provide support for SQL Server/SQL Azure connections.
The SQL Server/SQL Azure connections are available in LinqConnect Professional, Standard and Express editions only (http://www.devart.com/linqconnect/editions.html).

We recommend you to refer to this article http://www.windowsazure.com/en-us/develop/mobile/tutorials/get-started/?fb=ru-ru.
MariiaI
Devart Team
 
Posts: 1472
Joined: Mon 13 Feb 2012 08:17

Re: LinqConnect for Metro connection string problem

Postby Zainab » Tue 29 Oct 2013 14:24

Thank you for the reply
Zainab
 
Posts: 4
Joined: Mon 28 Oct 2013 10:14

Re: LinqConnect for Metro connection string problem

Postby Zainab » Wed 30 Oct 2013 12:00

if I create any other global database for my WinRT supplication , will LinqConnect be able to establish the connection?

Thanks in advance
Zainab
 
Posts: 4
Joined: Mon 28 Oct 2013 10:14

Re: LinqConnect for Metro connection string problem

Postby MariiaI » Fri 01 Nov 2013 10:14

We have tested LinqConnect for Metro with Oracle on Amazon RDS. The connection and database operations are performed successfully.
JIC: for correct work it is necessary to select the "Internet (Client & Server)" and "Private Networks (Client & Server)" check boxes on the Capabilities tab in the Package.appxmanifest file of your application.

As for the rest of such databases, please specify which one you would like to use and we will try to find the solution for you.
MariiaI
Devart Team
 
Posts: 1472
Joined: Mon 13 Feb 2012 08:17


Return to LinqConnect (LINQ to SQL support)