Hi,
How can I prevent deadLock in async?
In ComboBoxCategories_SelectionChanged I have deadLock.
I used ConfigureAwait(false).
It don't wait even I used await.
Please help me.
private ObservableCollection<wordsGViewModel> WordsGS;
public ObservableCollection<wordsGViewModel> wordsGS
{
get
{
return WordsGS;
}
set
{
WordsGS = value;
RaisePropertyChanged("wordsGS");
}
}
public async Task<ObservableCollection<wordsGViewModel>> GetwordsGScategoryS(string category1)
{
wordsGS = new ObservableCollection<wordsGViewModel>();
var db = new SQLite.SQLiteAsyncConnection(App.DBPath);
var _wordsGS = await db.Table<wordsG>().Where(
p1 => p1.nameCategory == category1).OrderBy(
p2 => p2.nameCategory).ToListAsync().ConfigureAwait(false);
foreach (var _wordsG in _wordsGS)
{
var wordsG = new wordsGViewModel()
{
_id = _wordsG._id,
nameCategory = _wordsG.nameCategory,
nameWord1 = _wordsG.nameWord1,
nameWord2 = _wordsG.nameWord2,
nameWord3 = _wordsG.nameWord3,
nameWord4 = _wordsG.nameWord4,
nameWord5 = _wordsG.nameWord5,
nameWord6 = _wordsG.nameWord6,
nameWord7 = _wordsG.nameWord7,
nameWord8 = _wordsG.nameWord8,
nameWord9 = _wordsG.nameWord9,
nameWord10 = _wordsG.nameWord10
};
wordsGS.Add(wordsG);
}
return wordsGS;
}
public ObservableCollection<wordsGViewModel> GetwordsGScategory(string category1)
{
wordsGS = new ObservableCollection<wordsGViewModel>();
using (var db = new SQLite.SQLiteConnection(App.DBPath))
{
var query = db.Table<wordsG>().Where(
p1 => p1.nameCategory == category1).OrderBy(
p2 => p2.nameCategory).ToList();
foreach (var _wordsG in query)
{
var wordsG = new wordsGViewModel()
{
_id = _wordsG._id,
nameCategory = _wordsG.nameCategory,
nameWord1 = _wordsG.nameWord1,
nameWord2 = _wordsG.nameWord2,
nameWord3 = _wordsG.nameWord3,
nameWord4 = _wordsG.nameWord4,
nameWord5 = _wordsG.nameWord5,
nameWord6 = _wordsG.nameWord6,
nameWord7 = _wordsG.nameWord7,
nameWord8 = _wordsG.nameWord8,
nameWord9 = _wordsG.nameWord9,
nameWord10 = _wordsG.nameWord10
};
wordsGS.Add(wordsG);
}
}
return wordsGS;
}
}
// private void newGameFirst(string selectedItem1)
private async void newGameFirst(string selectedItem1)
{
wordsGSViewModel1 = new wordsGSViewModel();
wordsGS1 = new ObservableCollection<wordsGViewModel>();
// wordsGS1 = wordsGSViewModel1.GetwordsGScategory(selectedItem1);
wordsGS1 = await wordsGSViewModel1.GetwordsGScategoryS(selectedItem1);
writeInTBs();
}
private void ComboBoxCategories_SelectionChanged(object sender, SelectionChangedEventArgs e)
{
if (comboBoxCategories.SelectedIndex == -1)//check if anything is selected
return; //do nothing if nothing is selected
if (e.RemovedItems != null && e.RemovedItems.Count > 0)
{
if (this.comboBoxCategories.SelectedItem != null)
{
selectedItem = this.comboBoxCategories.SelectedItem.ToString().Trim();
selectedCategory = listCategories.IndexOf(selectedItem);
comboBoxCategories.SelectedIndex = selectedCategory;
roamingSettings = Windows.Storage.ApplicationData.Current.RoamingSettings;
roamingSettings.Values["MyValueSelectedIndexCategory"] = selectedCategory.ToString();
roamingSettings.Values["MyValueCategory"] = selectedItem.Trim();
if (GridX.Children.Count() > 0)
{
removeChildren1();
}
loadTBs();
newGameFirst(selectedItem);
}
}
}
private void removeChildren1()
{
int intTotalChildren = GridX.Children.Count - 1;
for (int intCounter = intTotalChildren; intCounter >= 0; intCounter--)
{
if (GridX.Children[intCounter].GetType() == typeof(TextBlock))
{
TextBlock ucCurrentChild = (TextBlock)GridX.Children[intCounter];
GridX.Children.Remove(ucCurrentChild);
}
}
}
private void loadTBs()
{
// System.Diagnostics.Debug.WriteLine("In loadTBs: ");
for (int i = 0; i < _maxRow; i++)
{
for (int j = 0; j < _maxCol; j++)
{
TextBlock lbl = new TextBlock();
var tblock = lbl;
tblock.Name = "tb_" + i.ToString() + j.ToString();
// tblock.Text = matrix[i, j].ToString();
// tblock.Text = i.ToString() + j.ToString();
tblock.Width = 50; //Width
tblock.Height = 50; //Height
tblock.VerticalAlignment = VerticalAlignment.Center;
tblock.VerticalAlignment = VerticalAlignment.Bottom;
tblock.TextWrapping = TextWrapping.Wrap;
tblock.Margin = new Windows.UI.Xaml.Thickness(0, -12, 0, -12);
tblock.TextAlignment = TextAlignment.Center;
tblock.HorizontalAlignment = HorizontalAlignment.Center;
tblock.FontSize = 24;
tblock.FontStyle = Windows.UI.Text.FontStyle.Normal;
tblock.FontWeight = Windows.UI.Text.FontWeights.Bold;
tblock.Foreground = _blackBrush; // new SolidColorBrush(Colors.Yellow);
tblock.TextWrapping = TextWrapping.Wrap;
tblock.IsTapEnabled = true;
Grid.SetRow(tblock, i);
Grid.SetColumn(tblock, j);
tblock.Tapped += new TappedEventHandler(tblock_Tapped);
GridX.Children.Add(tblock);
}
}
}
private void writeInTBs()
{
for (int i = 0; i < _maxRow; i++)
{
for (int j = 0; j < _maxCol; j++)
{
object wantedNode = GridX.FindName("tb_" + i.ToString() + j.ToString());
if (wantedNode is TextBlock)
{
TextBlock wantedChild = wantedNode as TextBlock;
wantedChild.Text = matrix[i, j].ToString();
}
}
ADRIAN DIBU
