Databases
StackOverflow2013
Postsdbo
PO
 

Note that there are some explanatory texts on larger screens.

plurals
  1. PO
    primarykey
    data
    text
    <p>NHibernate does not know how to deal with complex types like TcpClient out of the box. But it lets you provide your own loading and storing code. You can use <a href="http://intellect.dk/post/Implementing-custom-types-in-nHibernate.aspx" rel="nofollow">IUserType</a>:</p> <pre><code>public class TcpClientMapper : IUserType { public SqlType[] SqlTypes { get { return new[] { new SqlType(DbType.String), new SqlType(DbType.Int32) }; } } public Object NullSafeGet(IDataReader rs, String[] names, ...) { String address = NHibernateUtil.String.NullSafeGet(rs, names[0]); Int32 port = NHibernateUtil.Int32.NullSafeGet(rs, names[1]); return new TcpClient(address, port); } public void NullSafeSet(IDbCommand cmd, Object value, Int32 index) { TcpClient tcpClient = value as TcpClient; if(tcpClient == null) { NHibernateUtil.String.NullSafeSet(cmd, null, index); NHibernateUtil.Int32.NullSafeSet(cmd, null, index + 1); } else { EndPoint red = tcpClient.Client.RemoteEndPoint; IPEndPoint endpoint = ((IPEndPoint)red); NHibernateUtil.String.Set(cmd, endpoint.Address.ToString(), index); NHibernateUtil.Int32.Set(cmd, endpoint.Port, index + 1); } } public Type ReturnedType { get { return typeof(TcpClient); } } // TODO: implement other methods } </code></pre> <p>And map it like this in hbm:</p> <pre><code>&lt;property name="_tcpClient" type="MyNamespace.TcpClientMapper, MyAssembly"&gt; &lt;column name="Address" /&gt; &lt;!-- NullSafeGet/Set index == 0 --&gt; &lt;column name="Port" /&gt; &lt;!-- NullSafeGet/Set index == 1 --&gt; &lt;/property&gt; </code></pre> <p>Or use fluent <a href="http://wiki.fluentnhibernate.org/Available_conventions" rel="nofollow">UserTypeConvention</a>:</p> <pre><code>public class TcpClientUserTypeConvention : UserTypeConvention&lt;TcpClientMapper&gt; { } </code></pre>
    singulars
    1. This table or related slice is empty.
    1. POFluent NHibernate automapping
      singulars
      1. PTQuestion
    1. PTAnswer
    1. USDmitry
    1. USDmitry
    plurals
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. POFluent NHibernate automapping
      singulars
      1. PTQuestion
    1. This table or related slice is empty.
    1. VO
      singulars
      1. PO
      1. This table or related slice is empty.
      1. VTUpMod
    2. VO
      singulars
      1. PO
      1. This table or related slice is empty.
      1. VTAcceptedByOriginator
    3. VO
      singulars
      1. PO
      1. This table or related slice is empty.
      1. VTUpMod
    1. COI see. I'll have to implement all the methods for the IUserType then I'd presume in order for it to work? If so how would you implement the NullSafeSet for this? The property in my class itself would still remain a regular TcpClient right or would I need to change that to the ClientMapper class?
      singulars
      1. PO
      1. USNathan Raley
    2. COYes, you have to implement all methods, it is not hard, take a look at the link in the answer. Property would still remain a regular TcpClient (which is a bit strange from design standpoint). See last edit for NullSafeSet implementation.
      singulars
      1. PO
      1. USDmitry
    3. COThat looks great, thanks for the help. Another quick question? How do you know the order of what is getting sent to the Strings[] array? I realize your reading the properties but how do you know that the address is at position 0 and the port at position 1 in the array? The reason I ask is b/c I am trying to implement the same for a serial connection.
      singulars
      1. PO
      1. USNathan Raley
 

Querying!

 
Guidance
A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload