.NET Maui iOS build error using Microsoft.Data.SqlClient

Question

.NET Maui iOS build error using Microsoft.Data.SqlClient

Kurt K 176

In my .NET Maui project, I need to connect to a Sql Server database over local network connections only (NOT over the Internet).

I am using Microsoft.Data.SqlClient. The Windows platform builds and runs fine.

The iOS build results in the following error:

Error clang++ exited with code 1:
ld: framework not found System
... Xamarin.Shared.Sdk.targets

I had been successful using System.Data.SqlClient, but I wanted to use Microsoft.Data.SqlClient since it is now the recommended SqlClient.

Please let me know how to get local network connections to a Sql Server database working in .NET Maui.

Thank you.

Wenyan Zhang (Shanghai Wicresoft Co,.Ltd.) 36,436 Reputation points Microsoft External Staff

2022-11-24T02:25:38.637+00:00

Hi @Kurt K , I check the Microsoft.Data.SqlClient NuGet package, it is not supported for .net Windows and .net iOS, and it's recommended that you can request the web API via HTTPClient to access SQL server. For the Apps, it's also suggested that you can use SQLite with iOS and Android to store and retrieve objects.
In addition, may I ask how did you make it run fine on Windows platform? Would you mind sharing the detailed error message on iOS platform?
Kurt K 176 Reputation points

2022-11-26T22:12:21.55+00:00
Hi again @Wenyan Zhang (Shanghai Wicresoft Co,.Ltd.) ,
Hope you had a nice Thanksgiving!
To make it run fine on the Windows platform, I saw the following Stack Overflow article: https://stackoverflow.com/questions/17615260/the-certificate-chain-was-issued-by-an-authority-that-is-not-trusted-when-conn. (I was getting error "A connection was successfully established with the server, but then an error occurred during the login process. (provider: SSL Provider, error: 0 - The certificate chain was issued by an authority that is not trusted.)".)
So I added "Encrypt=False" to the connection string to make the Windows platform run fine.

I went back to using "System.Data.SqlClient", which works fine on both Windows and iOS, without adding "Encrypt=False" to the connection string. (Again, the app will ONLY be sued to connect to SQL Server over a local, private network.)

Two questions:

You mentioned that Microsoft.Data.SqlClient is not supported on .NET Maui, so I assume the same is true for System.Data.SqlClient?

You suggested "request the web API via HTTPClient to access SQL server". I did not realize SQL server supported HTTP requests. Can you point me to an article that explains how to do this?

Thank you.
Wenyan Zhang (Shanghai Wicresoft Co,.Ltd.) 36,436 Reputation points Microsoft External Staff

2022-11-28T08:48:02.45+00:00

From the NuGet page link of System.Data.SqlClient, NET Maui doesn't support it either. (The Compatible target framework(s) don't include .net Windows and .net iOS)
For the second question, it means that you can make web services, and the APP sends requests and receives the response from the web service. This doc (Consume a REST-based web service) is about how to use it in client side, you also should create web services on the server side. For the further support about server side, you can create a new thread.
In addition, it's recommended that you use SQLite (but not SQL server) with iOS and Android to store and retrieve objects, please see .NET MAUI local databases - .NET MAUI | Microsoft Learn
Kurt K 176 Reputation points

2022-11-29T00:06:12.273+00:00

Dear @Wenyan Zhang (Shanghai Wicresoft Co,.Ltd.) ,

Thank you for the information. Sorry, I misunderstood your original statement, which I thought was that the server-side part of the web service was built in to Microsoft SQL Server.

The mobile app we are trying to develop will be an add-on to our existing product that runs on Windows PCs, and ONLY on a local, private network. Our existing (agricultural) clients have asked about the possibility of adding iPhone/iPad clients on the network.

Our prototype using System.Data.SqlClient works great, and it is fast. We will look at doing it with HTTPClient. However, we worry about performance and about the extra complexity and potential extra cost introduced with the additional layer.

A follow-up question:

If we find that we need to stay with System.Data.SqlClient, can we rely on it remaining a part of .NET Maui, at least for a while, even though it is not officially supported?

Thank you,
Kurt
Wenyan Zhang (Shanghai Wicresoft Co,.Ltd.) 36,436 Reputation points Microsoft External Staff

2022-11-29T09:37:45.25+00:00

can we rely on it remaining a part of .NET Maui, at least for a while, even though it is not officially supported?

Yes, you can keep using System.Data.SqlClient if it works. If you have any other issues, please feel free to post here.
Kurt K 176 Reputation points

2022-11-29T21:31:51.197+00:00

Hello again @Wenyan Zhang (Shanghai Wicresoft Co,.Ltd.) ,

On the ability to use System.Data.SqlClient, thanks, that's great! Allowing developers the choice to use System.Data.SqlClient for situations like ours (non-internet local, private networks) is a great benefit. We really appreciate it.

Thank you so much for your time, help, and advice on this.

Best regards,
Kurt
Wenyan Zhang (Shanghai Wicresoft Co,.Ltd.) 36,436 Reputation points Microsoft External Staff

2022-12-01T03:02:54.493+00:00

You are welcome. I have summarized our comments into an answer, you could check it.

Accepted answer

0 additional answers

Your answer

Wenyan Zhang (Shanghai Wicresoft Co,.Ltd.) 36,436 Reputation points Microsoft External Staff

2022-11-24T02:25:38.637+00:00

Hi @Kurt K , I check the Microsoft.Data.SqlClient NuGet package, it is not supported for .net Windows and .net iOS, and it's recommended that you can request the web API via HTTPClient to access SQL server. For the Apps, it's also suggested that you can use SQLite with iOS and Android to store and retrieve objects.
In addition, may I ask how did you make it run fine on Windows platform? Would you mind sharing the detailed error message on iOS platform?
Kurt K 176 Reputation points

2022-11-26T22:12:21.55+00:00

Hi again @Wenyan Zhang (Shanghai Wicresoft Co,.Ltd.) ,
Hope you had a nice Thanksgiving!
To make it run fine on the Windows platform, I saw the following Stack Overflow article: https://stackoverflow.com/questions/17615260/the-certificate-chain-was-issued-by-an-authority-that-is-not-trusted-when-conn. (I was getting error "A connection was successfully established with the server, but then an error occurred during the login process. (provider: SSL Provider, error: 0 - The certificate chain was issued by an authority that is not trusted.)".)
So I added "Encrypt=False" to the connection string to make the Windows platform run fine.

I went back to using "System.Data.SqlClient", which works fine on both Windows and iOS, without adding "Encrypt=False" to the connection string. (Again, the app will ONLY be sued to connect to SQL Server over a local, private network.)

Two questions:

You mentioned that Microsoft.Data.SqlClient is not supported on .NET Maui, so I assume the same is true for System.Data.SqlClient?

You suggested "request the web API via HTTPClient to access SQL server". I did not realize SQL server supported HTTP requests. Can you point me to an article that explains how to do this?

Thank you.
Wenyan Zhang (Shanghai Wicresoft Co,.Ltd.) 36,436 Reputation points Microsoft External Staff

2022-11-28T08:48:02.45+00:00

From the NuGet page link of System.Data.SqlClient, NET Maui doesn't support it either. (The Compatible target framework(s) don't include .net Windows and .net iOS)
For the second question, it means that you can make web services, and the APP sends requests and receives the response from the web service. This doc (Consume a REST-based web service) is about how to use it in client side, you also should create web services on the server side. For the further support about server side, you can create a new thread.
In addition, it's recommended that you use SQLite (but not SQL server) with iOS and Android to store and retrieve objects, please see .NET MAUI local databases - .NET MAUI | Microsoft Learn
Kurt K 176 Reputation points

2022-11-29T00:06:12.273+00:00

Dear @Wenyan Zhang (Shanghai Wicresoft Co,.Ltd.) ,

Thank you for the information. Sorry, I misunderstood your original statement, which I thought was that the server-side part of the web service was built in to Microsoft SQL Server.

The mobile app we are trying to develop will be an add-on to our existing product that runs on Windows PCs, and ONLY on a local, private network. Our existing (agricultural) clients have asked about the possibility of adding iPhone/iPad clients on the network.

Our prototype using System.Data.SqlClient works great, and it is fast. We will look at doing it with HTTPClient. However, we worry about performance and about the extra complexity and potential extra cost introduced with the additional layer.

A follow-up question:

If we find that we need to stay with System.Data.SqlClient, can we rely on it remaining a part of .NET Maui, at least for a while, even though it is not officially supported?

Thank you,
Kurt
Wenyan Zhang (Shanghai Wicresoft Co,.Ltd.) 36,436 Reputation points Microsoft External Staff

2022-11-29T09:37:45.25+00:00

can we rely on it remaining a part of .NET Maui, at least for a while, even though it is not officially supported?

Yes, you can keep using System.Data.SqlClient if it works. If you have any other issues, please feel free to post here.
Kurt K 176 Reputation points

2022-11-29T21:31:51.197+00:00

Hello again @Wenyan Zhang (Shanghai Wicresoft Co,.Ltd.) ,

On the ability to use System.Data.SqlClient, thanks, that's great! Allowing developers the choice to use System.Data.SqlClient for situations like ours (non-internet local, private networks) is a great benefit. We really appreciate it.

Thank you so much for your time, help, and advice on this.

Best regards,
Kurt
Wenyan Zhang (Shanghai Wicresoft Co,.Ltd.) 36,436 Reputation points Microsoft External Staff

2022-12-01T03:02:54.493+00:00

You are welcome. I have summarized our comments into an answer, you could check it.

Answer 1

Hello @Kurt K ,

I check the Microsoft.Data.SqlClient and System.Data.SqlClient NuGet package, they are not supported for .net Windows and .net iOS (The Compatible target framework(s) don't include .net Windows and .net iOS)
You can make web services so that the APP sends requests and receives the response from the web service. This doc (Consume a REST-based web service) is about how to use it in client side, you also should create web services on the server side. For the further support about server side, you can create a new thread.
In addition, it's recommended that you use SQLite (but not SQL server) with iOS and Android to store and retrieve objects, please see .NET MAUI local databases - .NET MAUI | Microsoft Learn

can we rely on it remaining a part of .NET Maui, at least for a while, even though it is not officially supported?

Yes, you can keep using System.Data.SqlClient if it works. If you have any other issues, please feel free to post here.

Best Regards,
Wenyan Zhang

If the answer is the right solution, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

Share via

.NET Maui iOS build error using Microsoft.Data.SqlClient

0 additional answers

Your answer