I have an XML File that I am processing using LINQ. I want to basically serialize the XML data into custom objects but don't know how.
[Code]...
How can I finish the above LINQ query to populate the Children property of the Group object?
I would like to know if there is any simple/fast way to create a complex XML file, when I say complex, I mean more than 20 elements encapsulated. Although this is VB.net,unfortunately literals will not work in this case
View 2 RepliesI have a collection as follows
Private _bankRates As Dictionary(Of RateSourceBank.Key, RateSourceBank)
Where RateSourceBank.Key is simply
Public Class Key
Public RateType As String
Public EffectiveDate As DateTime
[Code].....
I'm using Linq to Sql and have a stored proc that won't generate a class. The stored proc draws data from multiple tables into a flat file resultset. The amount of data returned must be as small as possible, the number of round trips to the Sql Server need to be limited, and the amount of server-side processing must be limited as this is for an ASP.NET MVC project. So, I'm trying to write a Linq to Sql Query however am struggling to both replicate and limit the data returned. Here's the stored proc that I'm trying to convert:
[Code]....
This question is very similar to a previous question of mine, Use LINQ to count the number of combinations existing in two lists, except with some further twists.
I have a list of CartItems that can receive a discount based on the items specified in the list of DiscountItems. I need to be able to pull out the items in the Cart that can receive a discount and apply the appropriate discount specfied in the DiscountItem. The discount is only applied for each combination that exists. Here's what the two lists might look like to before the discount is applied[code]...
I'm trying to save some settings in a complex object. If I make a dll of the class I can then add it in the projects properties settings list as that type.When the program runs though it won't show up as anything other than nothing. I read you have to have a sub new empty constructor which I have but don't know why else this would fail.First question is how to you do this. Second is there anyway to use a class inside the project as the target of the settings type or do you have to bring a in an external dll to do this every time? [code]
View 4 RepliesI am trying to send an object created in JavaScript to an ASP.NET PageMethod. This object mirrors the properties of an existing custom business object, so i was hoping that i could pass a single object instead of a parameter for each property. I am getting an error "Unknown web method SavePart when attempting to use this method.
Javascript:
function() {
var pt = { Id: 1, Onhand: 20, LowPoint: 30, __type: 'Custom.Objects.Part'};
$.ajax({
[Code].....
i have a complex object that holds a WPF Canvas with many child canvases, rectangles and, lines. The object includes some home grown classes as well. The main object and the home grown classes have the <Serializable()> attribute set. I tried the general formatter.Serialize(strm, rb_x) to serialize the object to a memory stream. I then found out that WPF classes are set as serializable. So after some research I discovered the System.Runtime.Serialization and found a generic Serialization Surrogate.So after some debugging I was able to serialize the object to a memory stream then copied the stream to an array of bytes then store that array in an OLE field in an MS Access table.
When I read back the access record and copy the OLE field byte array back to a memory stream and then de-serialize it back to the object I get a SerializationException "Error binding to target method."
So question #1 - is what I am trying even possible?Question #2, (assuming #1 is yes) do I need to do something special with WPF Baml type objects.
I have to join two main tables, and I need to filter the results by elements in an ASP.NET web form. These filters are created on the fly so I have to use a lot of where extensions to filter the query. I want to execute the query with as optimized SQL as possible.
I am first doing a simple join between TW_Sites and TW_Investigators. Then there are two sub-tables that are involved. TW_InvestigatorToArea and TW_InvestigatorToDisease. While most of the where clauses are working fine, I have found a performance issue that won't be an issue right now, but will be an issue as the table gets bigger.
The arrays DiseaseCategories and DiseaseAreas would be the results of a CheckBoxList result.
Protected Sub LoadResults()
'Get Dictionary of Filters
Dim FilterDictionary As OrderedDictionary = Session.Item("InvestigatorFilterDictionary")
' Initialize LinqToSql
[code]....
I have Country=>Ligue=>Team(Name, Score)I need to select all team Name-Scores from a country.
something like this, does not work )
query = from ligue in myCountry.Ligues, from team in ligue.Teams
select name = team.Name, score = team.Score distinct
[code]....
Am new to the concept Linq.I created a var where i joined 3 tables to get the data and then bind it in a datatable and create a csv file. Now i want to use an additioanl table in the same variable to be bind with the datatable but my problem is i cant use join here since i dnt have any common col or primary col in this additional table.How do i add this extra table?
[Code]...
I created a typed dataset a day or so ago, then I added a whole bunch of tableadapter/tables with some relationships etc... suddenly out of nowhere it decides my dataset "is not defined". everywhere in my code where i use this dataset now has an error. I tried not to pull out my hair and do a Clean then Rebuild solution... out of nowhere it just refuses to generate code. Object reference not set to an instance of an Object. It would be nice if it was my object so i could find it but it's not.
Curiously I also lost the little database icon on the dataset in the solution explorer.I can still open it in the designer and preview my queries etc... it just wont make the code. it's driving me insane. anyone got a solution?
I am getting following error whenever I want to use IIf function inside entity framework query.
LINQ to Entities does not recognize the method 'System.Object IIf(Boolean, System.Object, System.Object)' method, and this method cannot be translated into a store expression.
How can I convert an object of type System.Data.Linq.DataQuery to System.Linq.IQueryable?I'm working with Visual Basic/Silverlight, and the source code of my query is as follows:
Public Function Get_Cli_Pag() As IQueryable(Of V_Cliente_Pagare)
Dim Qry = From P In Me.Context.Pagares Join C In Me.Context.Codigos On C.Codigo
[code]....
This is my first post here so forgive me if I am not following any correct protocols. I am attempting to generate a DataSet and bind it to a datarepeater object. I had been doing this at Design Time and was getting an error message when filling the dataset when the form loaded. So I am basically createing the dataset in my code now when the form loads and binding it to the datarepeater. However, when I attempt to bind the dataset I get a NullReferenceException - even through I know that there are 60 rows of data in the dataset table.
[Code]...
As you can see i have several debug messages in there. I get the error on the last line when setting the datarepeater data source. I try and get data for a specified lot - if it doesn't return any values I create some values in the datatable and add them to the DB. On first load when there is no data this works perfectly. If I then close the form and reload it, it will display fine. However, if I change any of the data (database is updated) and then go back in again, I get the error above.
I have a situation where I have an xml document that has a bunch of elements that I basically use as data variables. I populate the variables from various sources and then transform the xml file to an html file for user viewing.having to remember the names of all the data elements in the file is somewhat tedious. Is there a way to generate a strongly typed xml document object so that one can simply dot into the various data elements?
View 5 RepliesI have the following line of Dim clients = From client In db.clients Select client Where client.ClientID = id
In debugging, the clients object populates perfectly, but how can get get data from the clients object? Like if the clients object has a FirstName property, how can I set a textboxes text property to that property from the clients object?
I thought it'd be something like:
tbClientFirstName.Text = clients.FirstName But that doesn't work.
how to convert a linq query directly back to the same object type. But I have failed!
Dim test(2) As myStructures.ReturnData
test(0).Partnumber = "2055"
Dim result = From n In test _
Where n.Partnumber = "2055"
'now convert result to a myStrucutres.ReturnData() how?
I can't quite figure out why this Linq Statement isn't working as i would expect:
[Code]....
I would assume that this would create a new collection of anonymous types, that would be distinct. Instead it creates a collection the size of the "ThisParentCollection" with duplicate "MyAnonymousType" in it (duplicate id's).
So say I have a collection of Bloops
Class Bloop
Public FirstName
Public LastName
[Code]....
Is it possible using Linq to select the FirstName and LastName out of all the Bloops in the collection of Bloops and return a collection of Razzies? Or am i limited to a For-Loop to do my work?
To clear up any confusion, either VB or C# will do. Also this will probably lead to me asking the question of (What about using a "Where" clause).
In VB.Net class, I have a JSON data as string. I want to convert them to LINQ class Object.[code]....
View 2 Repliesfrom a list, which got 3 attributesI want to return a new list of that class where attribut1 recurrence in the list equals Xfor an example this;
1,a,b
1,c,d
1,e,f
[code]....
I am using LINQ - VB.Net I want to filter my List object by passing String object in the where.
Dim _permittedTransactionCodes As List(Of String) = Nothing 'String object
it is populated with data.
Dim tap100transCodeInfos As List(Of Tap100transCodeInfo) = _dal.GetActiveTap100transCodeByHdrScreenCde(UCase(screenId), "TRAN_CDE")
i am trying something below, but not getting the filtered results
tap100transCodeInfos.Where(Function(x) _permittedTransactionCodes.Contains(x.TranCde))
I am trying to use a simple LINQ to Objects query.When I try to run my application I get the message:
System.InvalidOperationException was unhandled Message="An error occurred creating the form. See Exception.InnerException for details. The error is: Method not found: 'Void sharatTashlumimWS.paymentDetailsManager.set_ReleaseDate(System.DateTime)'."
Source="WindowsApplication1"
StackTrace:
[Code]...
I have a collection (IList(Of Sample)) of the following class:
Public Class Sample
Public sampleNum As String
Public volume As Integer[code].....
This collection is filled from a regex that gets passed over a file.What I want to do is use Linq to generate a collection of these for each unique samplenum using the following conditions.For each samplenum: Have the highest volume where the final is greater then one
If the sample has multiple records for this volume then pick the one with the the highest final
If the previous step leaves us with no records pick the record with the highest final ignoring volume
I am extremely new to Linq and just can't get my head around this. For now I have solved this using for each's and temporary lists but I am interested in how this would be handled using pure Linq.Sample Data:
samplenum | volume | initial | final
1 | 50 | 8.47 | 6.87
1 | 300 | 8.93 | 3.15[code]......
I'm trying out some LINQ expressions and can't get them to work with the List class. Basically I want to be able to sort a list of custom objects by property type, however the C# LINQ syntax is KILLING me and I can't figure out how to convert it to VB
Class Foo
Sub New(Name As String, Position As Integer)
Me.Name = Name
[code]....
I have got the list of Class Name as Follows: Type[] typelist = typeof(Sample.Students).Assembly.GetTypes();
Now i have complete list of all classes available in Sample NameSpace:
Now i want to get data through class I am using Devexpress Persistance class so basically i have to create XPQuert Object as follows: XPQuery<Employee> EmployeeQuery = new XPQuery<Employees>(XPODefault.Session);
But in my case Employee class will be listed in typelist variable..How can i create the object of XPQuery.. is it possible something like this: XPQuery<typeof(typelist[0].Name)> EMployeeQuery = new XPQuery<typeof(typelist.Name)> (XPODefault.Session);
I meant i want to create object dynamically.
I have an array of unknown (to the current method) class objects. I do know that each class has a property called "Number". I am trying to write a LINQ query where I am looking for the object with the next Number in sequence. AKA, I'm at Number 8, use a LINQ query to find the object where Number=9.
View 5 RepliesI have an object that may have been inflated via a plain old DataContext, or may just have been new-ed up with just its .ID property set. There's no way to know for sure. I'm looking to rehydrate the entire object from whatever is in the database. If the object was new-ed up, I can call .Attach() on the table object and refresh from the Data Context with no trouble. But, if the object was already inflated from the DataContext I get the error: "Cannot attach an entity that already exists.". There's no timestamp field or anything like that - just an integer primary key being used to control the rehydration. I'd like to know if there's a way to conditionally attach. Here's the code - it works the way I want it to, but this seems a hackish way to go about it:
' myDC is a shared instance of a vanilla DataContext...
' myObj is an instance of a linqed-up `SomeLinqObject`
Dim tbl = myDC.GetTable(Of SomeLinqObject)()
[Code[,,,,,
I'm trying to write a linq to object query in vb.net, here is the c# version of what I'm trying to achieve (I'm running this in linqpad):
void Main()
{
var items = GetArray(
[code].....