LINQ and .NET 3.5 | Forum profile

That solved my problem. Thank you Eslam. Uroš

hi guys , in n-tier there is sequental access from UI--> BLL --> DAL. but when we user linq can we say that UI can access the data source directly , it ot doext not voilate the convention ? or i am wrong some where . because we can do like that in UI Customer cus = Datacontext.gettable

Using the let clause [ ^ ] your query becomes var records = from record in document.Descendants( " Variable" ) let type = Support.GetType((string)record.Element( " type" )) select new Variable { Name = (string)record.Element( " name" ), DataType = type, DefaultValue = Support. Convert ((string)record.Element( " value" ), type) };

Hi all, I have a data table with columns ID and amount.I need to check whether the amount is zero or >0. Instead of looping the whole datatable,I want to use linq here. Could any one provide the sample to achieve the task... Thanks in advance, Srinivas Mateti

Has anyone benchmarked XML Linq speed compared to network'd MySql? I have a fairly big XML database here and was wondering if I might get better performance by loading it into MySql. It's the read access I'm most interested in at the moment. Yeah, I know I could mash up some test code, but I wondered what the scuttlebutt might be. Budsy

IMO this [ ^ ] is a must visit for anyone starting with LINQ.

The way I used to do it w/ LINQ2SQL is to generate an interface on the table, for each table class in the datacontext. I would then manually go through each interface and convert it to a class. I'm not sure if someone has figured out how to automate this. After a year of so, I bought a commercial ORM from Mindscape called Lightspeed, it supports linq and generates the DTOs for me =)

I think MySql will be better if the size of the data is very long. Reading the entire xml file into memory and then apply LINQ will not be great compared to Database. In case of database you can select only the part you want. XML files are read totally into memory before searching.

MySQL is RDBMS system and tuned for high performance. So you will get better performance than file system storage like XML. LINQ to XML is just an abstraction over the XML manipulation classes and it has to read the nodes sequentially. So the larger your file, slower your program will be.