NHibernate Mapping SQL-VIEW Without Unique Identifier?
Oct 13, 2011
I have a read-only mssql-view, and I want to map it to nhibernate (using hbm.xml files). The view is a select that joins two tables. For give an abstract-insight, the select is something like this:
SELECT A.Id As A_ID, B.Id As B_ID,
A.AttributeA, B.AttributeB,
FROM A INNER JOIN B ON
A.Id = B.RootID
It's a one-to-many relationship between A and B (B entries are dependant/leafs of A entries).
I'm using nhibernate's hbm.xml files, and I can't make it to work. I'd gladly appreciate if someone can enlight me of the kind of XML that I have to use, I guess that as my view has no ID, I have to create a composite-nhibernate id (wich will be the ids os A and B together) but I couldn't make it to work. Also the view is READ ONLY so I think that should make the solution easier.
Sub emailConfirm() Dim email As String = txtMail.Text Dim name As String = txtPrenom.Text + txtNom.Text[code]....
note:I want to send Link contains a unique identifier and verify the unique identifier in the login.aspx.I don't know when to do this...I found nothing interesting on the net ...
Question: I get an exception serializing this class to a nHibernate xml file ({"Could not determine type for: System.Drawing.Image, System.Drawing, for columns:NHibernate.Mapping.Column(Settings)"}).
using System; using System.Collections.Generic; using System.Text;
I am using Fluent NHibernate to map an Oracle database. It is a legacy database so I cant really change everything I want.There is a GUID field, but the keys are still composite (I will change this as soon as I can so that the keys are not composite, but I cant do it right now). The GUID is a VARCHAR2 field with this layout: 551608b1-275d-49f6-9561-44d01aacf23f. The GUID is not added by a sequence in Oracle, but inserted from code (C# or VB.net)[code]Is the problem that I dont use a sequence to generate my GUID? How can I overcome this?
I'm a C# programmer constrained to write VB.NET code.While exploring NHibernate further for my current client, I encountered FluentNHibernate, which I find real attractive.But now, I wonder how to "translate" this C# code for component mapping into VB.NET code:
what I miss is how to continue with the brackets in VB.NET, since there's no Begin End keywords or so.
EDIT 1: Following Mr. JaredPar instructions, I figured that his solution might work. If we take the time to read his answer, we may notice that we both don't know what the MType is within his solution. I might have found out that the MType is:
Thus, TComponent is, from my understanding, an anonymous type that I shall parameter to use. From this point of view, since I wish to map the properties of my Address object, replacing TComponent in my help method signature seems not to work.
Private Sub MapAdresseHelper(Of Adresse)(ByVal a As FluentNHibernate.Mapping.ComponentPart(Of Adresse)) a.Map(Function(m) m.Number) a.Map(Function(m) m.Street).Length(50)
[code]...
The error I get is that my Address class doesn't have a property member named Street, for instance. It sees my Address type, it recognizes it, but it seems buggy somehow. I guess VBNET is poorly designed for lambda expressions and is less evolved than C#?
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() _
Question: When you have a .NET GUID for inserting in a database, it's structure is like this:
60 bits of timestamp, 48 bits of computer identifier, 14 bits of uniquifier, and 6 bits are fixed,
128 bits total Now I have problem with a GUID, because it's a 128 bit number, and some of the DBs I'm using only support 64 bit numbers. Now I don't want to solve the dilemma by using an autoincrement bigint value, since I want to be able to do offline replication.
how to determine this? I know how to get the "processor ID" etc. but this is apparently not a unique identifier.This is for an intel i7 975. My boss has asked us to make sure that no-one tampers with several parts of a process control computer.
Anyone know of a unique identifier I can grab from a Windows PC?I am working on licensing of my app and I want to assign the user a license key and have the key and some unique piece of data from the PC hit a database server of mine and then check credentials before the program runs.I thought about using host name but that can be cloned. I also thought of MAC address but if a computer has a wired and wireless NIC then there are multiple MAC addresses.
I have a table in an SQL database bound to a datagridview and am having an issue with understanding what happens when I add a new data row.
My datatable is built in code with the first column created using this sql command...
vb
cmdString = String.Format("CREATE TABLE {0} ({1} INT IDENTITY(1,1) NOT NULL, ", tableName, columnNames(0))
after that there a a number of other columns added to the command to build the table. After the table is created, I fill the datatable and bind the datagridview using this code....
vb Dim cmdString As String = String.Format("SELECT * FROM {0}", DB_DATALOG_TABLE_NAME) DataLogAdapter = New SqlDataAdapter(cmdString, dBConnection) DataLogTable = New DataTable
[Code].....
This is where my understanding is falling. Because I have created the datatable's first column with the NOT NULL key word, an exception throws when I try to update the data adapter because the first column of the data row is empty By creating the table with the first column the IDENTITY key word, doesn't that imply that the database will generate the value for that column? If so, when I add a new datarow, how does the identity column get filled?
I am looking to return a machine specific unique identifier from an EXE. I've tried MAC, hard drive serial and CPU ID, but all contain alpha characters. This makes returning them as an integer difficult - integer seems to be the only type you can return from an EXE.
I want to send a Link that contains a unique identifier and verify the Guid in an another page named login.aspx So how do I add the link and how do I retrieve the Guid from the login.aspx to compare it to the one I saved in the SQL database...
In my [2005] application, I use the MacAddr / CpuId / DiskId of the computer to validate my licence using the WMI calls. The problem is we just can't thrust this feature because on a good percentage of the computers this feature is not installed properly or completely disabled.The users are not experienced, they are located in a remote location and I just don't feel like debugging their Windows installation every time they want to try my application.Is there a working alternative that I can use that will always return me a unique identifier for every computer which will always be available on 2000 / XP / Vista systems?
ASPX: <a href="ShowImageVB.aspx?id=<%# Eval("ProdID") %>"> <asp:Image runat="server" ID="ImageThumbnail" AlternateText="Click here to open the real size image" ImageUrl='<%# "ShowImageVB.aspx?thumbnail=true&ID="& Eval("ProdID").toString%>' Style="border-width: 0px;" /> </a>
Code Behind: Dim data As DataView = SqlDataSource1.[Select](New DataSourceSelectArguments()) The above code does not seems to work when I change my ProductID to UniqueIdentifier Datatype. This is the error I have ""Input string was not in a correct format." But when change the ProductID to Int datatype is working fine.
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
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 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 am using VB .Net to access the eBay API and store all completed orders in a database. This database is then fed into a proprietary shipping system, which can not handle an order number larger than 20 characters. eBay returns an order number like so 230407279314-680141236013 which is too long. The order number is always 12 numbers a hyphen and 12 more numbers. What I need to do, is turn this (the result can be alpha numerical) into a shorter, unique order key to store in my database alongside the true orderId (so that this can be referenced by the shipping software instead of the actual order number). The reason for the 20 character limit is the barcode algorithm used. Is there any way to achieve this in VB .Net 2010? This number can be anything unique, so long as it does not exist already (even a good uniqueid function would work, but I would have to query the database to make sure it isn't taken)
How generate the unique no. 1,2,3 and so on .... on button click of each new user ..
the code mentioned below is a readwrite coding in vb.net ...
but the problem is it generate the same id for different users on button click event... but i want the no. of times button clicked the new ids will be generated
Protected Sub Button1_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles Button1.Click Dim FILE_NAME As String = Server.MapPath("counts.vbi")
Unique constraint - these columns currently doesn't have unique values..?? I have created Unique Constraint with 3 columns. My code works perfectly but once - two users @ same time entered same data and somehow it saved in DB; after that incident. This UniqueConstraint gives me error - These columns currently doesn't have unique values. How can I check if user enters this kind of entry or how can I restrict the Entry?
I am working on a periodic table of elements with buttons for each element-done next step. textbox + chemistry formulas = grams to mole conversions/ moles to L/ moles to molecules. The problem I'm having is dimming the chemicals Arsenic(As) and Indium(In). I need to dim these as integers = to their atomic mass G/Moles. But I am not able to Dim them because they are highlighted in blue and the help tip comes up as "keyword is not a valid identifier" is there anyway I can tell VB to not use "In" and "As" how it normally does and use it for integer values?
I instaled vb.net 2005 and when i want to see my old project that has been created by vb.net 2003 (when i click on one of the forms that i created) vb.net 2005 show me this error "
One or more errors encountered while loading the designer. The errors are listed below. Some errors can be fixed by rebuilding your project, while others may require code changes.
how 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.
In visual studio 2008 when open the design for a VB.Net windows form, i am getting the error " '.ctor' is not a valid identifier". I can see the form designer if I press the "Ignore and Continue" link. All other forms are loading fine.
The callstack with the error message:
at Microsoft.VisualStudio.Shell.Design.Serialization.CodeDom.CodeDomEventBindingService.ValidateMethodName(String methodName) at
In visual studio 2008 when open the design for a VB.Net windows form, i am getting the error " '.ctor' is not a valid identifier". I can see the form designer if I press the "Ignore and Continue" link.All other forms are loading fine.The callstack with the error message:
at Microsoft.VisualStudio.Shell.Design.Serialization.CodeDom.CodeDomEventBindingService.ValidateMethodName(String methodName)
If you try and do the same in a control that inherits Control, you get an error,Keyword is not valid as an identifier. Since Step is a keyword via the For Next statement.
So, how do you achieve the same as the ProgressBar has done in a custom control?
i am new to visual basic and have a question with text boxes and sounds the goal is so that you put a word in a text box and then it plays that sound if it has it as a resource
