Best way?

Firstly, im an old c programmer, so probably got some daft questions.

Have created a simple web page, with a simple gridview control on it.
I have a sql database which i have linked to using linq.
Ive created a nice pictorial view of my tables using the server explorer and this has created default classes for each table.

I can simply create my linq query, and bind it to the control, this works fine, except, i would like to push the linq code into a class firstly to tidy up my code, and secondly to reuse as its called from a few different places.

My first attempt partially succeded, shove the linq code into its own static class, it tuns, but i cant return the results of the query easily.

Whats the simplist way to do this?

Thanks,

Jim

Jim:

I am not sure what you mean by saying that you cannot return the results of the query easily. I tend to do what you have described in that, along with the dbml, I create a set of static accessor and mutator methods that are used to return types lists, full tables, or single results based upon a passed in argument item or list. For example, using the Northwind database, if I wanted to return a list of orders by order ID, I would create an accessor method such as this:

public static List<Order> GetOrdersById(int orderId)

{

NorthWindDataClassesDataContext dc = new

NorthWindDataClassesDataContext();

return (from ord in dc.GetTable<Order>()

where (ord.OrderID == orderId)

select ord).ToList<Order>();

}

The method returns a List of Orders which can then be bound to a grid.

1 Reply

Know the answer? Post it — somebody with the same question will find it here.

Scott Lysle18y ago
Jim:

I am not sure what you mean by saying that you cannot return the results of the query easily. I tend to do what you have described in that, along with the dbml, I create a set of static accessor and mutator methods that are used to return types lists, full tables, or single results based upon a passed in argument item or list. For example, using the Northwind database, if I wanted to return a list of orders by order ID, I would create an accessor method such as this:

        public static List<Order> GetOrdersById(int orderId)

        {

            NorthWindDataClassesDataContext dc = new

            NorthWindDataClassesDataContext();

            return (from ord in dc.GetTable<Order>()

                    where (ord.OrderID == orderId)

                    select ord).ToList<Order>();

        }

The method returns a List of Orders which can then be bound to a grid.