I am Not Able to connect .NET MAUI Project with MS SQL Connection

Question

I am Using MS SQL in .NET Maui Project and I am not able to get connected . the problem is that when i am using System.data.Sqlclient it is not showing me mssqlconnection object so I tried with Microsoft.data.mssqlclient and this time it is giving error "Connection was established but there is problem during pre login handshake " can you please give me any suggestion ,

string myconnect = "Data Source =hostname\\servername; " +
       "Initial catalog =dbase;User ID=user;Password=pass;";  
    SqlConnection MyConnection = new SqlConnection (myconnect);
    MyConnection.Open();
    SqlCommand mycmd = new SqlCommand();
    mycmd.CommandType = CommandType.Text;
    mycmd.CommandText = "select * from logins where UserName =@user and PassWord=@pass ";
    mycmd.Parameters.AddWithValue("user", txtUser.Text);
    mycmd.Parameters.AddWithValue("pass", txtPass.Text);
    mycmd.Connection = MyConnection;
    SqlDataReader myread = mycmd.ExecuteReader();
    if (myread.Read())
    {
        DisplayAlert("TEST", "PasswordOK", "Press");
    }
    else
    {
        DisplayAlert("TEST", "Password Is Bad", "Press");
    }

it is a very, very bad idea to connect directly from a mobile client to a database server — Jason, Sep 20 '22 at 11:29
https://www.google.com/search?q=there+is+problem+during+pre+login+handshake+site:stackoverflow.com — Jason, Sep 20 '22 at 11:31
one small suggestion, please use `using` and don't use `select *` and define your connection string in some config file — Vivek Nuna, Sep 20 '22 at 11:34
Put your data access behind a web service or headless function. In Azure, web app or function app should handle the data access. — Dana Reed, Oct 07 '22 at 01:34
Does this answer your question? [.Net Maui how to connect](https://stackoverflow.com/questions/74778682/net-maui-how-to-connect) — James Risner, Mar 05 '23 at 22:57

score 1 · Answer 1 · edited Mar 05 '23 at 22:55

1

Use Microsoft.Data.SqlClient package from NuGet instead of System.Data.SqlClient.

See this other answer.

edited Mar 05 '23 at 22:55

James Risner

5,451
11
25
47

answered Mar 05 '23 at 22:53

Mustafa Mutasim

29
1
4

I am Not Able to connect .NET MAUI Project with MS SQL Connection

1 Answers1