linq

Need some quick help as I've suffered over this easy problem all afternoon. Yes, I could do it in SQL easily then call that FillBy or 20 other different ways but I'm trying to figure out LINQ since I never used it before. Group by Year Month and sum all three integer columns Simple table...

Due to most of the computers uses Windows XP or a non updated framework, as developer sometimes you need to use the most common tools, but what happens when the common tools doesn't have what you want? That's exactly what happens to me now with the reference 'System.XML.Linq' I need that...

Hi all, I hope you can help. I have an object called tblTask (From linq query to the object) which has fields such as T3_1, T3_2, T3_3, T3_4. These are questions that need to be filled in by the user. I want to run a dynamic query to find out if any information is in that field or not. The...

Can someone help me please, i`m looking for a way to build a filter like LINQ but i want to use it before selecting data out of the database. For building a ORM witch can be used for our business. I`m looking for a way to execute a where function for example with ObjectA.PropertyB as argument...

To Revisit a previous question with a further stipulation... Anyone know how to do the following, IGNORING CASE? Dim Matches = From mRows In LinqMasterTable Join sRows In LinqSecondTable _ On mRows(ThePrimaryKey) Equals sRows(TheForignKey) _ Order By...

I'm trying to LINQ two tables based on a dynamic key. User can change key via a combo box. Key may be money, string, double, int, etc. Currently I'm getting the data just fine, but without filtering out the doubles. I can filter the double in VB, but it's slooooow. I'd like to do it in the LINQ...

Hi, I have two tables Students and Origami. Origami has Foreign Key of Students table. Each student can make one or more origami for each month. Students sample data: StudentId, FirstName, LastName - 187 , John , Maslow - 196 , Crystal , Hood - 195 , Sarah , Lewis Origami sample data...

Hi, New to vb so please go easy on me :) Im trying to populate the combobox with items that are returned from a search of the database with linq from the combobox when the text changes(in the combo box) here is some of my code: Dim db As New ProdLinqDataContext Dim searchstring =...

What’s new in Aspose.Total for .NET Q3 2009? This Q3 2009 release of Aspose.Total for .NET includes a detailed quarterly summary about major feature enhancements and a large number of newly supported features by Aspose .NET components. Let me list down some of these important features for your...

Hello everybody! My application looks like the following: 1. An XML file is read using LINQ and the result is an enumeration of objects of a specific type (i don't use anonymous types). The result is then converted with result.ToList() to a standard list and saved to a list-variable. 2. I...

Hi everybody! I'm new here and I'm not a native speaker, so please don't be to severe ;). My XML source file: <?xml version="1.0" encoding="ISO-8859-1" standalone="no" ?> <pricelist> <item> <item_no>123</item_no> <item_description> <description1>new item...

Hello, I'm trying to learn how to write and save a new record to a SQL Server Db using LINQ. When I run my code and view the data in the table, the new record isn't there. However, when I query the table, the new record shows up! When I close the project, open it up, and run the query the...

Let´s say I have an array (I named it "Points") of objects. Each object has a custom property called for example "Selected". The property type is Boolean. Can I use LINQ to determine the INDEX of the element in the "Points" array where "Selected=True"? (I´ve ensured that only one element can...

I have an array wherein i have to populate some objects that are not part of another object. For e.g there are objects called viewgroup and membershipgroup.i have to populate the array with viewgroup obj that are not part of the membershipgroup. i need to do this using LINQ in VB.Net. can anyone...

Using a Linq statement to select objects from a custom collection Private Items As New Generic.List(Of T). The funtion is as follows... Public Function AllChildren() As Generic.IEnumerable(Of T) Dim Query = From Child As T In Items Select Child Return Query.ToList End...