linq issue

Please try to write using correct syntax. You have:

fetch customers .in order list

I think you meant:

fetch customers. In order list

It really helps to be careful about things like that. Not being careful makes it difficult to understand what you are trying to say.

If I understand what you are saying, then the answer depends on your program. You simply need to remove the code that fills the orders list, or use a parameter of some type that your program uses to determine whether to fill the orders list. I don't know how your program works so I can't tell you how to do it. I think no one else knows otherwise they would have helped you already.

i dont want orders you are right , but i want linq not to fetch these information from data base because i am just
querying for customers,it should only fetch customers .in order list it shoud be empty or null as i am just querying customers.
is not that overhead , coz i just want 5 customers and it is bringing 200 * 5 orders 200 for each .

ok

in northwind data base , get customers with the query
var qry = from customers in datacontext.customers
                select customers;

and you can get even orders by each particular customer ,  i dont want that
i just want customers data not orders related to each customer.






now on user interface side
if i do

list  lst = new BAL.Getcustomers()

//the above query will be called in the GetCustomers method.


list  ordlst = lst[0].Orders;
so here ordlst will give all the orders , i dont want that , i hope you will understand ,now.

Based on my experience of answering thousands of questions for other developers, it is likely that there is something that is not as you describe. It is highly likely that you are assuming that something is working in a certain manner, but it is actually working in a different manner.

The thing I would do is to write a small simple sample that duplicates the problem, along with a small amount of data. You need to write a program that duplicates the problem but does nothing more than it needs to do to duplicate the problem. Sometimes that takes a few hours, but for this problem it seems it can be done in a few minutes. This might seem like too much work but it is what I would do and I have done when I needed help such as this. I usually solve the problem myself when I write a small program that I can use to play with. If you don't solve the problem yourself with the small sample, then post the small program here and some data to use to run the program.

yes dear , i can access the data of tableb with property from tablea object ...