<Window x:Class="WpfAppTEST1.MainWindow"
        xmlns="http://schemas.microsoft.com/winfx/2006/xaml/presentation"
        xmlns:x="http://schemas.microsoft.com/winfx/2006/xaml"
        Title="MainWindow" Height="384" Width="554">
    <Grid>
        <Button Content="appDICT" Height="23" HorizontalAlignment="Left" Margin="24,12,0,0" Name="button1" VerticalAlignment="Top" Width="75" Click="button1_Click" />
        <DataGrid RowHeight="30" FontSize="10" 
                  AutoGenerateColumns="True" Height="283" HorizontalAlignment="Left" 
                  Margin="24,41,0,0" Name="dtg_Show" VerticalAlignment="Top" 
                  Width="463" DataContext="{Binding}" />
    </Grid>
</Window>

        private void button1_Click(object sender, RoutedEventArgs e)
        {

            if (cnnsql_Collector.State == ConnectionState.Closed)
            {
                cnnsql_Collector.Open();
            }

            using (tbl_appDICT ctx = new tbl_appDICT(cnnsql_Collector))
            { 
                var q = from item in ctx.appDICT
                        where item.dicNameID.Equals(-50)
                        select item;

                dtg_Show.ItemsSource = q; // <- НЕТ ОТОБРАЖЕНИЯ В ГРИДЕ
                // dtg_Show.ItemsSource = q.ToArray(); // <- ТАК ТОЖЕ НЕТ ОТОБРАЖЕНИЯ В ГРИДЕ

            }

        }

[Table()]
public sealed class appDICT
{
    
    [Column(AutoSync = AutoSync.OnInsert, DbType = "bigint", IsPrimaryKey = true, IsDbGenerated = true, UpdateCheck = UpdateCheck.Never)]
    public Int64 RecID;
    [Column(DbType = "varchar(200)", CanBeNull = false)]
    public string dicItem;
    [Column(DbType = "varchar(500)", CanBeNull = true)]
    public string dicItemValue;
    [Column(DbType = "varchar(200)", CanBeNull = true)]
    public string dicName;
    [Column(AutoSync = AutoSync.OnInsert, DbType = "bigint", IsPrimaryKey = false, IsDbGenerated = true, UpdateCheck = UpdateCheck.Never)]
    public Int64 dicNameID;
    [Column(DbType = "int", CanBeNull = true)]
    public Int32 dicItemSort;
    [Column(DbType = "datetime", IsDbGenerated = true, CanBeNull = false)]
    public DateTime dtStamp;
} //  class appDICT --------------------------------------------------------------------------------------------


public class tbl_appDICT: DataContext
 {
    public Table<appDICT> appDICT;
    public tbl_appDICT(SqlConnection connectionString)
        : base(connectionString)
    {
        //connectionString = connectionString;
    }
 }

[Table()]
public sealed class appDICT
{
    [Column(AutoSync = AutoSync.OnInsert, DbType = "bigint", IsPrimaryKey = true, IsDbGenerated = true, UpdateCheck = UpdateCheck.Never)]
    public Int64 RecID {get; set;} 
    [Column(DbType = "varchar(200)", CanBeNull = false)]
    public string dicItem {get; set;} 
    [Column(DbType = "varchar(500)", CanBeNull = true)]
    public string dicItemValue {get; set;} 
    [Column(DbType = "varchar(200)", CanBeNull = true)]
    public string dicName {get; set;} 
    [Column(AutoSync = AutoSync.OnInsert, DbType = "bigint", IsPrimaryKey = false, IsDbGenerated = true, UpdateCheck = UpdateCheck.Never)]
    public Int64 dicNameID {get; set;} 
    [Column(DbType = "int", CanBeNull = true)]
    public Int32 dicItemSort {get; set;} 
    [Column(DbType = "datetime", IsDbGenerated = true, CanBeNull = false)]
    public DateTime dtStamp {get; set;} 
} //  class appDICT ----