sure you can

I have same error like you

Yes of course :) But api are used to connect with multiple devices on multiple areas where as direct SSMS connection is confined with same place over shared internet.

Never do this! This is a horrible example and is exactly what not to do. You need an API. Yes it’s more work, but here he has opened SQL to attacks and removes any business logic. You mobile app will contain the username and password to your server. 30 seconds of decompiling will give a hacker access to your database. Furthermore this is horribly expensive as each query connects and authenticates before the query can be executed. An api allows you to use a connection factory which reuses connections. Done the way he does it here, each connecting device is another connection. Honestly you could write a whole book on why not to do this.

Yes, It's possible please wait for the next video.

Welcome 😊

We can make lots of small scale apps with in the organization. And this mobile apps needs internet connection for sure as it needs sql server IP address to be connected. But the main advantage is you can visualize the database and manipulate it with your own. CRUD Is the next part. 🙂

Looking forward to it, TIA..

Thank you

i have the same problem and did not find a solution yet.

I respect your thought. I am getting synchronized data and want to load my large data at first then only show my UI. I agree Open Async() is what need to be used

@@xamaringuy1951 OpenAysnc() is the way, getting data async, not synchronously and use an animated spinner to indicate that data is being received ;) Always use Async/Await, never block the UI.

The practice use case will be you will be creating Api with the sql database. Where as local SQLite.net is just for local storage of info.

For windows and iOS app I was able to connect my sql clinet in dotnet Maui but there’s the issue with android.

@@xamaringuy1951 when will they fix it ?

same error to me also, trying to figure out since 1 month but still no luck. If anyone found the answer please share

Same here How did you fix the problem?

Same goes for me How Did you Fix the Problem?

Did you get it to work? if yes, can you tell me how'd you do it? Thanks!

same. but no solution yet. Recommendations like "use package Version 3.0.1 and cs parameter encrypt = false does not work.