tags:

views:

20

answers:

0
Q: 

How to map HasMany using non Primary Key column?

Hi I use Castle.ActiveRecord's HasMany mapping. I have something like:

[HasMany (typeof (childtype), ColumnKey = "this_relation_column", Table = "childtype_table")]

I would like to use a different column on childtype_table to relate with this_relation_column. Actually, this_relation_column is of type text (string), and the PK of childtype_table is INT. I do not have a foreign key on childtype_table and I cannot have it (for other reasons).

How to achieve the mapping?

related questions

Implements several interfaces with conflict in signatures
Using Small (1-10 Items) Instance-Level Collections in Java
Which .Net collection for adding multiple objects at once and getting notified ?
Are non-generic collections in .NET obsolete?
Return collection as read-only
What is the correct .NET exception to throw when try to insert a duplicate object into a collection?
How would you implement the IEnumerator interface?
Python: What is the best way to check if a list is empty?
Comparing two collections for equality
Rule of thumb for choosing an implementation of a Java Collection?
Select a random N elements from List<T> in C#
Would you recommend using "The C5 Generic Collection Library for C# and CLI" based on your experience with it ?
Check if a record exists in a VB6 collection?
Does C# have a way of giving me an immutable Dictionary?
How do I efficiently keep track of the smallest element in a collection?
Filtering collections in C#
How Best to Compare Two Collections in Java and Act on Them?
List<BusinessObject> or BusinessObjectCollection?
How do I page a generic collection without Linq?
shortcut for creating a Map from a List in groovy?
Java: Best way of converting List<Integer> to List<String>
What is the best way to iterate through a strongly-typed generic List<T>?
WPF - Sorting a composite collection
[C#] Best implementation for Key Value Pair Data Structure?
Limit size of Queue<T> in .NET?