LinqConnect for Metro connection string problem

[Zainab]

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

[MariiaI]

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 ... nnect.html

[Zainab]

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

Thanks in advance

[MariiaI]

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/devel ... /?fb=ru-ru.

[Zainab]

Thank you for the reply

[Zainab]

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

Thanks in advance

[MariiaI]

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.