LINQ

Maybe I'm missing something, but shouldn't this work? var matches = from request in RequestTable             where request.MessageId == 2 and request.State == State.Completed             select request; Life, family, faith: Give me a visit. From my latest post: "How differently the psalmist saw it! How blessed -- how truly happy with real joy! -- is the man who delights in the Law of the Lord." Judah Himango

martin_hughes wrote: A while back I can't remember who, and I think it was in the lounge, someone mentioned that there was a specific limitation of Linq that can only be solved with XPath. Can anyone remember who said this, or better yet know what the limitation is? Sorry it took so long to find this, but you posted the message the day before Developer Day Scotland and I wasn't very active around that point as I was too busy arranging a conference. Anyway... Reasons why you still need XPath (that I've found so far): * Not everything you do can be done purely in .NET * XSLT * Having WiX create an installer that configures the config file Recent blog posts: * Introduction to LINQ to XML (Part 1) - (Part 2) - (part 3) My website | Blog

Very nice. Thanks for the link (no pun intended). Deja View - the feeling that you've seen this post before. My blog | My articles

Thanks for your replies guys. I had a wee read and messed around. I think I have it cracked but i need to test it yet. What do you reckon of this? Makes sense? Dim result = From a In dc.OFG_AdStats _ Group By AdId = a.AdId _ Into Impressions = Count(a.Type = 0) _ Order By Impressions Descending _ Select AdId, Impressions Thanks JimBob SquarePants ******************************************************************* "He took everything personally, including our royalties!" David St.Hubbins, Spinal Tap about Ian Faith, their ex-manager *******************************************************************

Hey For any one who has this trouble in the future - ended up reinstalling VS2008 and it now works. At university studying Software Engineering - if i say this line to girls i find they won't talk to me Dan

Simple google search found me this article[^]. Don't be overcome by evil, but overcome evil with good

In which case - why not take a look at people's answers to posts in this forum and decide who (if any) you feel that meets your criteria. You could email them via the email link in their replies and explain your position to them - I'm not advocating this because they may construe this as spam, but you could do this. Deja View - the feeling that you've seen this post before. My blog | My articles

Roger: Thank you! Joe Rattz suggested the following solution: http://www.albahari.com/nutshell/linqkit.html This solution is provided by Joe Albahari. It's quite convenient. Sheng

Your solution is perfectly fine for the context where the OP is using it. Mine is more general (doesn't require IList, just IEnumerable), doesn't crash when the lists have different lengths (whether this is good depends of course highly depends on what you want to do). And in your solution, inserting new items in list1 while the query is evaluated will result in an InvalidOperationException (collection modified during enumeration), but inserting new items in list2 doesn't. The Zip solution is symmetric regarding input1/input2 (throws InvalidOperationException in both cases).

Watch it guys Knowledge Experts :cool: are Here with Solution Follow the Link http://www.blog.vimallakhera.com/BlogId_2073_BlogItem.aspx (Knowledge Experts) Vimal Lakhera, Senior Software Engineer Corbus (India) Pvt. Ltd. | A CMMi Level 5 Company Cell) (+91) 9818 511 428 E-Mail: info@vimallakhera.com | http://www.vimallakhera.com

Wrong forum. Please use the Visual Studio[^] forum for this type of question. Recent blog posts: * Introduction to LINQ to XML (Part 1) - (Part 2) - (part 3) My website | Blog

Oren Eini, the author of Rhino Mocks, wrote a post about it here: Awkward Testability for LINQ to SQL[^]. Be sure to read the comments to that post, Scott Guthrie from Microsoft offers some options for mocking LINQ queries. Tech, life, family, faith: Give me a visit. From my latest post: "It's sobering to watch: the whole country stops for 2 minutes as a siren is blast to remember the 22,437 victims of terror and soldiers who died in defense of Israel..." The apostle Paul, modernly speaking: Epistles of Paul Judah Himango

It would have been helpful if you explained exactly what you wanted but is this the kind of thing you're after? var results = from s in students where teachers.FirstOrDefault(t => (t.Subject == s.Subject)) != null select s.Last + " " + s.First + " MARK: " + s.Scores[0]; I doubt it. If it isn't intuitive then we need to fix it. - Chris Maunder

Well i figured it out and the problem was with my Eval statement, nothing to do with LINQDataSources or the gridview. Eval("User1.UserName") is how it should be done instead of Eval(User1.UserName). I thought the days of missing ; or " off your code were long gone but obviously not :laugh: Kev http://esendexdeveloper.spaces.live.com/

Thanks.... Ranjeet Singh

Imthu wrote: I am new to DNN .. while creating report module i am getting this error. Error: UserReports is currently unavailable. DotNetNuke.Services.Exceptions.ModuleLoadException: Unable to cast object of type 'ASP.desktopmodules_userreports_viewuserreports_ascx' to type 'DotNetNuke.Entities.Modules.PortalModuleBase'. ---> System.InvalidCastException: Unable to cast object of type 'ASP.desktopmodules_userreports_viewuserreports_ascx' to type 'DotNetNuke.Entities.Modules.PortalModuleBase'. at DotNetNuke.UI.Skins.Skin.InjectModule(Control objPane, ModuleInfo objModule, PortalSettings PortalSettings) --- End of inner exception stack trace --- I'm confused. Whereabouts in this question is there anything that leads you to think that this is the appropriate forum for this question? Wouldn't you be served better by asking this on a specialist DotNetNuke forum? Seriously, I doubt you'll get much joy in a Linq/.NET3.5 forum with this question, so I would ask you to consider posting this on a DotNetNuke forum. Deja View - the feeling that you've seen this post before. My blog | My articles

Mmm, sure, it's about public face. But I don't understand - since LINQ stuff can leak out (after all, the basic structure of LINQ is IEnumerable<T>, which is CLS-compliant), it ought to be CLS-compliant. I think it is, but I'm not 100% certain. Tech, life, family, faith: Give me a visit. From my latest post: "The world will call you weak, unintelligent, and foolish for following God. Don't worry about them. God's picked the foolish things in order to put the world's wisdom to shame." The apostle Paul, modernly speaking: Epistles of Paul Judah Himango

Something like that. You may need to still do: var nestedGroup = blah blah blah; var suppliersWithMailBoxes = ConvertNestedGroupToSuppliers(); // something like this. You get the idea.

hi Daniel, this one is AND condition. How to implement OR Condition. Thanks in Advance! Have A Nice Day! Murali.M Blog