C#

<br />
      protected void _linqDataSourceProductsFirst_Selecting(object sender, LinqDataSourceSelectEventArgs e)<br />
      {<br />
            using (SpDBDataContext myDbContext = new SpDBDataContext())<br />
            {<br />
                var productResults = myDbContext.products.Where(x => emran.publish).OrderBy(x => x.isFeatured);<br />
               e.Result = productResults;<br />
            }<br />
     }<br />

Emran Hussain wrote:

How come the object gets Disposed already before using it ?

Emran Hussain wrote:

I placed the DataContext within a using statement so that it get disposed as soon as it is used

protected void _linqDataSourceProductsFirst_Selecting(object sender, LinqDataSourceSelectEventArgs e)
     {
           using (SpDBDataContext myDbContext = new SpDBDataContext())
           {
               var productResults = myDbContext.products.Where(x => emran.publish).OrderBy(x => x.isFeatured);
              e.Result = productResults;
           }
    }

Emran Hussain wrote:

I used to have Data Access Layer whole life until I learned LINQ to SQL.

Emran Hussain wrote:

I always hated data access layer

Emran Hussain wrote:

the ORM page (.dbml page) is working as a data access layer

Emran Hussain wrote:

I did not find any article that discuss any Design Pattern using LINQ to SQL

if ((Control.ModifierKeys & Keys.Control) == Keys.Control & (Control.ModifierKeys & Keys.A) == Keys.A)
            {
                MessageBox.Show("test");
            }

if (e.KeyCode == Keys.A && e.Control)
{
        Messagebox.show("");
}