If you have defined the relationships in the data context (.dbml), linq has what i would say lazy loading intellisense which gives you a way to do complex query in a simple linq friendly way. Here is an example related to your query: using (dataContext db = new dataContest) { var q = from p in db.ProjectCatergories where p.ProjectCategoryDetails.ProjectContentInfoSamples.ProjectID == "Pr-09" select new { p.projectCategoryName }; } So basically linq joins the tables automatically and that is one of the reasons I believe linq is so powerful! Hope this helps!

So you only want to count the records? Then you shouldn't even fetch all the records, but count them in the database query and only return the number of records. Example: strSQL = "select count(*) from Users" objRS = objConnection.Execute(strSQL) lngCount = objRS(0) objRS.Close() Set objRS = Nothing --- b { font-weight: normal; }

Hello Tushar many thanks for your help regards Yousuf

It sounds like two of the four methods need to either be not abstract, or more likely defined in an interface that only class B uses. You definately cannot hide methods from a base class on a class by class basis, that would be ridiculous. Christian Graus - Microsoft MVP - C++

myousuf wrote: I like to hear some comments on the above decided architecture. Unless you want lots of multimedia crap, there's no reason to use flash. ASP.NET does a good job of converting your code into HTML for different browsers. ASP.NET is also totally wasted if you're just going to host flash on each page. myousuf wrote: How to make webservices effective in performance? As interface will use them for communication with the Framework (Business Objects) which will do all the retrieving and storing tasks. coarse granularity, mainly. What's your reason to use webservices ? Does your planned architecture demand the middle tier on a different machine to the web tier ( which is just going to serve flash pages ) ? myousuf wrote: I prefer to use VB.NET language to write code. Please, give an example of writing a business object which should be prior in performance rather than security. Pick User object as an example. You prefer performance over security ? You want someone to write and entire user object for you as an example ? I don't think so. myousuf wrote: I did some work on the business objects. I have two classes one is doing all the db work and other holds the business rules. When you initiate its object, the business class, it inform the db class to load the required data in a DataSet object and use it to CUD (create, update and delete) tasks. Is this a acceptable approach to do? Performance wise, DataSet's are expensive to create. Christian Graus - Microsoft MVP - C++

Thanks for ur reply. connection string are workin fine with both windows application and web application, but dont know wats wrong with webservices. Error is occured with web service. thanks

Thank You so much Heath....you have solved my problem.:)