>Hey, Mike, just curious (and I'm asking because I truly don't know) - does nHibernate have the ability to pass a datatable as a parameter to a stored proc that receives a table type as a parameter?
>
>Thanks....
Honestly, not 100% sure... I know you can called Stored Procs, and from this post on SO it seems like you can:
http://stackoverflow.com/questions/10292695/how-to-pass-datatable-as-a-parameter-to-stored-procedure-by-not-commiting-the-cuIt's funny how things change. 6-8 years ago I bought your book and it was my bible for awhile - then I started to try to unwind from the relational database paradigm. I started using ORMs and saw the benefits, but also saw the limitations. Now I'm trying to steer to a NoSQL approach. Not that I have anything against SQL Server and relational database design - I just feel for the systems I work on, and the methodologies I use, I can deliver much much faster if I don't have to worry about persisting to relational data.
YMMV, obviously.
I'm still coming straight to you next time I'm in a SQL Server bind, though. :-)