Can I set up a local SQL Server on my Windows machine for my DOTNET Maui App, running on android?

SETH BARRERE 0
Viewed 47

I am new to DOTNET Maui, and was wondering if it is possible to use the local SQL Server, running on my PC, to supply data for my application, running on my Android.

This connection string works when I run the Maui app on my Windows Machine, but I get runtime errors when I run on an emulator, or my physical android.

//In the data context
protected override void OnConfiguring(DbContextOptionsBuilder optionsBuilder)
{
    optionsBuilder.UseSqlServer("Server=10.56.231.242,49172; Database=Gym;Trusted_Connection=True;");
 
}

I could be thinking about this completely wrong, and appreciate all your input, thanks!

mobile maui .net sql-server
1 Answers

When running your SQL server and .NET MAUI app on Windows they are both on the actual same physical machine. That is why local works. Local means that it reaches that exact same machine.

If you then run the .NET MAUI app on an Android emulator, technically it runs on the same machine probably, but your Android emulator is treated as a virtual machine and thus a separate machine. What now happens is that your .NET MAUI apps starts looking for local on the Android emulator so it expects that the SQL server is running on the Android device which is obviously not the case.

On your Windows machine go to your network settings or open a command window and type ipconfig that will give you info on your network. Find an IP address and use that in your .NET MAUI app.

The IP address probably looks like 192.168.x.x or 10.x.x.x where the x stands for other numbers.

More info can also be found here: https://docs.microsoft.com/xamarin/cross-platform/deploy-test/connect-to-local-web-services

Gerald Versluis0
Related