public static bool CheckLoginOld(string login, string password) { try { using (SqlConnection connection = DBSQLServerUtils.GetDBConnection()) { try { connection.Open(); } catch (Exception ex) { Debug.WriteLine(ex.Message);//Вывод в лог текст исключения throw; } SqlCommand command = connection.CreateCommand(); command = new SqlCommand(@"SELECT [Password] FROM [StudyDB].[dbo].[Account] WHERE [Login] = '" + login + "'", connection); SqlDataReader reader = command.ExecuteReader(); reader.Read(); if (password == reader["Password"].ToString()) { reader.Close(); return(true); } reader.Close(); return(false); } } catch (Exception ex) { Debug.WriteLine(ex.Message);//Вывод в лог текст исключения MessageBox.Show("Ошибка подключения к базе данных!", "Error", MessageBoxButton.OK, MessageBoxImage.Error); return(false); } }
protected override void OnConfiguring(DbContextOptionsBuilder optionsBuilder) { optionsBuilder.UseSqlServer(DBSQLServerUtils.GetDBStringConnection()); }