If I have a parent object (Parent) which has a List(Of Child) objects as a many-one relationship. Is it possible to return a Parent with a subset of it's child objects (eagerly loaded)? I am using VB and Criteria.
e.g. If Parent 1 has 50 children (20 type X 30 type Y) and I want to return the Parent with a collection containing only type X.
I only want a collection with a size of 20 with it's eagerly loaded children?
The tables described herein both utilize composite keys. I have a parent table that stores eligibility information per "case". The child table stores eligibility information regarding each individual associated with the case. The child records are differentiated by pin number to make them unique in the child table only.
I am using NHibernate v3.1 with Fluent NHibernate v1.2, both acquired via NuGet packages. The entities are mapped in using the Fluent NHibernate auto-mapper functionality. Any custom mapping is done in the mapping override method for each entity.
Another thing to know is that these tables do not have a "primary key" defined in DB2. They only have "unique keys", which are what you see in the composite key definition below (see code).
T0026_AG_ELIG is the name of the parent table and the corresponding POCO class.
T0265_AG_IN_ELIG is the name of the child table and the corresponding POCO class.
Problem:
The problem is that when I execute the query, all the data is queried, the parent record is successfully mapped to the class, but the returned child rows do not map into the collection on the parent class. NHibernate does generate the queries for the parent and child data. When I execute my own query against the database, the correct data for the conditions does come back. For some reason, the child records are just not being bound to the property on the parent (T0026) class.
Question:
What do I need to do to get the multiple rows coming back from T0265_AG_IN_ELIG to map to their corresponding class and load properly into the specified collection property on the parent class (T0026_AG_ELIG)?
Collection Property of Parent (T0026_AG_ELIG):
Public Overridable Property IndividualEligibilityRecords As IList(Of T0265_AG_IN_ELIG)
Mapping Override for Parent (T0026_AG_ELIG):
mapping.CompositeId() _
[Code].....
Basically, I wish to fetch a filtered set of objects from the database (Oracle 9.2) based on the id property of the object PsalertsEvent. The code being executed is:
Public Overloads Function GetAll(ByVal laterThan As Long, ByVal filteredPsalertsEvents As IList) As IList Implements IPsalertsEventRepo.GetAll
'Get all psalerts events with an ID greater then the specified laterThan parameter
filteredPsalertsEvents = MyBase.NHibernateSession.CreateQuery("from PsalertsEvent p where p.id > " & laterThan).List
[Code]...
I just read this article about the Entity Framework 4 (actually version 2).Entity Framework seems to offer a huge improvement over its first release. Thus, I have never ever used EF in any project, since I think EF is not mature enough in comparison to NHibernate.NHibernate and its current contributions of FluentNHibernate and Linq for NHibernate by Ayende RahienMy feeling is that Microsoft is solely trying to gain terrain it has lost in favor of NHibernate when the 2nd version of NHibernate came out.Nevertheless, my concerns are the followings (not in particular order):Will EF4 tend to be less XML-verbose?Will EF4 be compatible with other underlying datastore than just SQL Server?What are the greatest benefits of going with EF4 instead of FluentNHibernate or NHibernate itself.
NHibernate is a great tool, I guess everyone agrees. Due to its predecessor Hibernate, we may easily find documentions and tutorials and sample applications to get acquainted with it. This is not the case for FluentNHibernate. Particularly as per the project I'm working on right now which demands that I investigate further about NHibernate and its options (FluentNHibernate for instance) in order to document the rules of usage and the best practices of NHibernat and FluentNHibernate technology. Thus, being handcuffed with VB.NET, being a C-Style developer, I can't find some syntax equivalencies in VB.NET for the examples provided, though I made I way so far
I was following the example laid out here for implementing Ajax panels in MVC. I'm using VB.NET, but the conversion is pretty straightforward. However, I can't seem to get it to work?
Here is my code:
HomeController:
Function Index() As ActionResult
Return View()
End Function
Function Archive() As ActionResult
Threading.Thread.Sleep(5000)
Return View()
End Function
[Code] .....
When I run it, all I see is the ajax-loader animation endlessly. When I run it in debug mode, it never seems to trigger the Archive action.
I would like to ask if you can use VB.NET for NHibernate and Fluent Nhibernate?I have searched the web, but I can't seem to get a detailed or explicit statement that tells that one can use VB.NET for NHibernate and with Fluent.
Many of the samples in the NHibernate site are made in C#. That's why I was wondering if I can't use VB.NET when using NHibernate.
I have a parent child collection objects and was wondering how to get a single item from the child collection using Linq
[Code]...
way to return a collection of treenodes which are children of a selected node? I can't find on MSDN a object of treenodes that is a collection of childnodes.
I have two treeviews, and I am writing code that will copy treenodes from one treeview to another treeview if it is selected. If a parent node is selected, I would also like to copy over all the children. If it is just a childnode, then I would like to copy just that.
Here is what I have so far.
Dim treeobj As TreeNode
treeobj = TreeView2.Nodes.Add(TreeView1.SelectedNode.Text)
If TreeView1.SelectedNode.Parent.Index.ToString Is System.DBNull.Value Then
[Code]...
After getting the current mdi active child form, how can I get it's control collection so I can access their data?
View 8 RepliesI get the following string expression provided:"ChildObject.FullName" ...where ChildObject is an instance property on the MyObject1 type.ChildObject has a property named "FullName" and I want to sort a collection of type "MyObject1" based on this child properties "FullName" value.
I can do this all day long on properties directly on MyObject1 but I run into 2 challanges when doing it on a child instance and I can't get all the pieces working. The main 2 challanges are:
MyObject1 has a few different child property types so I can't hardcode the type for ChildObject. The string could be of any type.The sort expression is a String and not a known type.Above the value returned from the last line in the expression (if I run the code outsode the OrderBy method, does provide me the 'FullName' information I need. So the code must be close, but it still does not work.
Any ideas on how I can accomplish this? What I am trying to prevent is hardcoding a series of 'If' blocks on the child's type to then hardcode in its type to the sort or OrderBy method.
I have extended an Entity Framework 4 entity class with a calculated property in a partial class. This member is not available on the client to which the entities are exposed via WCF RIA Services.when using C# appears to be changing the extension of the partial class file from .cs to .shared.cs. I tried this with my VB.Net solution (.vb to .shared.vb) and got a long list of errors. I believe what happened is that the partial class lost its association with the entity on the client - it inherited from object rather than EntityObject.
My best guess is that this is related to the way that VB.Net handles namespaces.Each project has a 'Root Namespace' which is prepended to anything that is defined within a code file. C# has a 'Default Namespace'which is the namespace into which new types are placed by default - via a namespace statement within the file.The partial class is probably having the client namespace prepended to it which puts it into a different namespace than the entity with which it is associated on the server.Is there any means of extending an entity in such a way that those extensions are available on the client via WCF RIA Services and VB.Net?
i have a string = "/a/value1/x/valueforx/b/value2/c/value3"
the keys a, b, and c can be in any order in the string that is coming in and will always be separated by a slash.
What i need to do is to find a, b, c and then add their values to a collection
I'm creating an open-source web browser in VB.NET Express 2008 and I've created a User Setting named History to save a collection of strings for the browsing history. However, when I try to load the history form at runtime, only the first item (of the three I added) shows up in the listbox. Below are both examples of code I have tried to use to accomplish this task.
Private Sub Form1_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
ListBox1.DataSource = My.Settings.History
[Code]....
I'm trying to create a favorite box in my web browser using this code in Favorites.vb
Public Class favorites
Private Sub btnAdd_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnAdd.Click
[Code]....
Now I have it so when you click the add button it will put the URL in the string FavList, and place the URL in Listbox1 however I have no idea how to save it, and load it.
So the next time the user opens it, it will have the URL in the string and URL box, so when they click the URL in listbox1 it will redirect the WebBrowser. I think it works like that already I just need to know how to save it, and load it.
I am trying to get a MDI child form to load at the center of the MDI parent. I know it's a property on the form but it is not working. any suggestions?
View 3 RepliesI am using the following code in the load event of my form to populate autocomplete string collection but it gives me DBNULL error. Is there any other workaround where it skips DBnull values?
[Code]...
i have a one two many relationship on a form that loads empty so that the user have to do a search in order to populate the data into the form. To acomplish this, i created a filter (query) in the dataset. The filter works fine for the parent data, but how can i load its corresponding child data?
This is the code generated automatically when i created the filter in the DataSet:
VBCode
Try Me.TblConfidencialesTableAdapter.Buscar_Confidencial(Me.ConfidencialesDataSet.tblConfidenciales, TablillaConfidencialToolStripTextBox.Text)
Catch ex As System.Exception
[Code]....
I have a webpage with a form that is used to edit some object. This object contains a Collection of other objects defined like this: Public Overridable Property Employees As List(Of Employee)
On a form I can delete an employee, add a new one or modify existing one. When I click save new values are sent to the server. On a server I check if the user exists. If exists then I modify its values, if it does not exist then I add it. All employees that exist on the server and were not sent are marked as deleted (State changed to EntityState.Deleted). I try to use the following code (dbCollection = database entities, newCollection = collection sent from the form):
[Code]...
This code does not work, because changing to EntityState.Deleted removes the object from collection, and for each loop breaks, since the collection is modified...I know that I can overcome this problem by using a for loop or adding objects to delete to some other list first, but I hope maybe there is a pattern that would make my code nicer.
I build my project and i got some problems. First i want to print barcode for books(toolstripmenu item). but i cant. here's the code that i found:
[code..]
second problem is printing again. i want to print my MS ACCESS .mdb from child datagridview's records.
third one i want to save and load(with dialogs) my database from main form to child forms' datagridview.and the last one is help provider. i prepare my own .htm help file, when press F1 it opens. but i dont know how to call provider to toolstripmenuitem and help provider keep my computer's path so when i call provider another computer, the programme cant find the path.
I have an MDI parent screen that loads on startup and a lot of child forms that load when opening. So as the child forms load there's a lot of flashing and it looks really ugly. Once they're loaded all I have to do is use a bring to front, maximized command and it works smoother than closing a form and opening a new one every time a different form is selected. I've tried creating a splash screen, minimizing the forms on load, etc and everything still works in order so first the splash screen then the forms load.
How would you set it up so a splash screen stays on top of all other forms for like 5 seconds while the forms load in the background without seeing them load? Right now the screen shows then when it's done it moves on to step 2 which is loading the child forms. If no splash screen, how do I make it load so you don't see all the child forms opening at once?
Im working with MDI parent/child objects. when closing the child objects i need the child to check to see if it is the last child object before closing. i couldn't find anything on google, maybe im searching for the wrong thing.
View 2 Repliesi am asking about using the progress bar into the status bar to move when i load any child form inside the MDIParent form.
View 1 RepliesI have two forms. Form A and Form B. Form A has a datagrid that is populated from a SQL Database Table query. When a button is pressed Form B is launched that allows you to add a record to the database table. I need for the datagrid to be refreshed and show the newly added record when I close form B and go back to the parent.
[Code]...
i am having an issue populating two combo boxes on form load. The program will connect to an access database and pull data as instructed. Then as it pulls each record it puts it into the combo box.
This was working.. atleast i think it was. i dont recall it ever not working, however i wasn't looking for it.
My problem is that if when i load the MDI parent form and have it skip the selection form and the login form and load the next form in the sequence, it loads everything perfectly. However if the select form is loaded first, then the login form and then the form i need loaded, it will not populate. The only difference between the two different loads is that the login form calls a function that loads the form as a new project.form
I did this so that I can have multiple forms open at a time. I am assuming my problem is that I need to get the child forms handle then populating controls using that handle? but i think if I had to do that then I would beable to populate the comboboxes on the first form load using the login method of opening the form.
Here's my code.
vb.net
Private Sub frmLine1t5_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
Me.Text = "Line " & LineNumber & " Test Form"
[Code].....
I want to load a child form which is a login form by default when the parent form is loaded.Right now when I click new file on the toolbar of the parent form, then only the login form is loaded but i want it be loaded by default without clicking anything.
View 10 Replieshow to use nHibernate with Vb.net using all the examples online(which are in C#) to learn. Which has been fine for the basics, but now I'm trying to learn how to use QueryOver's JoinAlias, and going from C# to VB.net is difficult. I've been using this page's answer as a reference, but I'm still having trouble converting an example like that to Vb.net.
View 1 RepliesI'm struggling with getting Linq To NHibernate to work.I have referenced NHibernate, NHibernate.Linq and NHibernate.ByteCode.Castle . Also I have all other dependencies in the same folder.
Code / Error message:
Public Function GetProjectsByName(ByVal ProjectName As String) As List(Of Project)
Return (From x In _session.Linq(Of Project)() Where x.Name.Equals(Project))
End Function[code]....
... tells me that the LINQ extensions aren't loaded. Using NHibernate.Linq seems to be made in a way that it's incredibly easy to use, hence there are no tutorials on how to set it up. (Or at least I couldn't find any).
I have a repository class that defines some basic Get/Save/Delete methods. Inside these, I use NHibernate to do the work on my business entities. For example:
[code]...
However, on my User class I have some properties and collections of other objects that ideally I'd like to be lazy loaded. But of course, the ISession is created and disposed within the repository, which I guess is why, outside of that, when I try to access those properties I get a "Could not initialize proxy - no Session" error.Is my only option then to disable lazy loading when using repositories? Or is it possible (or just foolish) to somehow get the session into scope in the business layer?I do like the repository model, and NHibernate is growing on me (after lots of initial frustration trying to make it work), so what's the best way you gurus have found of using them together?
I can't find what's going on with the following nHibernate HQL.
here's my VB.Net code:
Return _Session.GetNamedQuery("PersonAnthroSummary").SetInt32(0, 2).UniqueResult()
My Named Query:
[code].....
I have an ado.net statement I want to convert to use NHibernate:
Dim sql As New StringBuilder()
sql.AppendLine("SELECT r.RoleId, r.RoleName ")
sql.AppendLine("FROM dbo.aspnet_Roles r ")
[code]...
