public IList <LookupItem> Lookup(DataEntityType type,
string filter, int top)
{
EnsureConnected();
string sql = _queryBuilder.BuildLookup(type, filter, top);
List <LookupItem> items = new List <LookupItem>();
using (IDbCommand cmd = _connection.CreateCommand())
{
cmd.CommandText = sql;
using var reader = cmd.ExecuteReader();
while (reader.Read())
{
items.Add(new LookupItem
{
Id = reader.GetInt32(0),
Name = reader.GetString(1)
});
}
}
_connection.Close();
return(items);
}
private void OnGenerateLookupClick(object sender, RoutedEventArgs e)
{
if (_cboTables.SelectedIndex == -1)
{
return;
}
try
{
_txtSql.Text = _sqlBuilder.BuildLookup(
(DataEntityType)_cboTables.SelectedIndex,
_txtLookupFilter.Text,
int.Parse(_txtLookupLimit.Text, CultureInfo.InvariantCulture));
_tabs.SelectedItem = _tabSql;
}
catch (Exception ex)
{
Debug.WriteLine(ex.ToString());
MessageBox.Show(ex.Message, Title, MessageBoxButton.OK);
}
}