Re: [nhusers] Re: SQL Server Identity and Nhibernate.... what is the latest story?

2012-11-28 Thread Sam Jonesom
On Wednesday, November 28, 2012 11:55:01 AM UTC-8, Gunnar Liljas wrote: It's very easy to justify the use of something that doesn't require database roundtrips in order to retreive a new PK value. Gunnar, I think you are talking about something different than what I am talking about.

[nhusers] Re: New: Redis cache provider

2012-11-27 Thread Sam Jonesom
Say, any updates to this? We use NH 3.2, and are rolling out redis for other purposes would love to use it as an L2 cache for NH -- You received this message because you are subscribed to the Google Groups nhusers group. To view this discussion on the web visit

[nhusers] SQL Server Identity and Nhibernate.... what is the latest story?

2012-11-27 Thread Sam Jonesom
Hello All! I do not mean to beat a dead horse, but the blog posts and articles I have read on this are 3 or more years old, and refer to NH 2.x. Why I am asking: We have a large SQL DB. We are finding that the use of GUIDs as primary keys and clustered indexes is creating LARGE indexes. Very

[nhusers] Quoting in MsSql2005Dialect

2011-09-19 Thread sam
Wondering if there is there a way to get the nhibernate dialect for sqlserver to produce quoted column and table names for sqlserver like: select this_.[USER] from [MY_TABLE] -- You received this message because you are subscribed to the Google Groups nhusers group. To view this discussion

Re: [nhusers] Quoting in MsSql2005Dialect

2011-09-19 Thread sam
Ya that's what I've been doing but that's really a dialect level information that i would have preferred to have the nHibernate dialect figure out if possible. Could the dialect not quote all database objects by default? -- You received this message because you are subscribed to the Google

Re: [nhusers] Grouped Subquery with Linq

2011-08-16 Thread sam
I've looked around for a bit but I have not found a full list of limitations of the current Linq provider for nHibernate 3.2. Most of the material found on the net seems to be applicable to 3.x. How much of an effort would it be to implement the missing gaps to get it on par with EF4 linq

Re: [nhusers] Grouped Subquery with Linq

2011-08-15 Thread sam
When I use the same Linq and pass it to Linq to SQL, the generated SQL is: SELECT COUNT(*) AS [Count], [t1].[STATE] AS [State], [t1].[value] AS [Assigned] FROM ( SELECT [t0].[STATE], (CASE WHEN [t0].[ASSIGNED_TO] IS NULL THEN @p0 ELSE @p1 END) AS

[nhusers] Grouped Subquery with Linq

2011-08-12 Thread sam
.ASSIGNED_TO IS NULL THEN @p1 ELSE @p2 END AS INT); This is on a SQL Server 2005 dialect. My attempt to do the subquery seems to be totally ignored by the linq provider. Why does nHibernate put the @p01,@p2 in the CASE statement and what happened to my subquery! Thanks, Sam -- You

[nhusers] Re: Grouped Subquery with Linq

2011-08-12 Thread sam
Sorry I missed a line of my Linq where I pasted it here. It should have read: from t in ( from d in docs where d.ProgramYear == programYear select new { State =

[nhusers] Re: Grouped Subquery with Linq

2011-08-12 Thread sam
Sorry I missed a line when I pasted my Linq. It should have read: from t in ( from d in docs where d.Year == 2010 select new { State = d.State,

Re: [nhusers] Grouped Subquery with Linq

2011-08-12 Thread sam
Well I was trying to group by counts where there is an assigned user and where there is not, and hence ended up with the construct. So basically this type of query is not possible with linq for nHibernate; but is it the case that no subqueries are allowed in linq? Thanks, -- You received

[nhusers] NHibernate Profiler super slow with 2nd level cache loading

2010-10-01 Thread Sam
*** FORGIVE ME IF THIS ISN'T THE RIGHT PLACE FOR THIS POST *** Everytime an item is pulled from 2nd level cache I get a hit on nhProf; however, this is making my whole app run extremely slow. Even when I filter these out it still runs dog slow. Is there anything I can do? -- You received this

[nhusers] Trying first nHibernate .Net Oracle10g app

2010-07-23 Thread Sam
I am new to nHibernate, so hopefully this is not to much of a newb question. I am trying to get my first C# .Net3.5 nHibernate Oracle 10g application running. To get started I have set it to do something pretty simple, at least I thought. Here is my hibernate.cfg.xml file: ?xml version=1.0

[nhusers] N+1 problem with ManyToMany mapped property on Entity

2010-07-16 Thread Sam
I have an N+1 issue that happens on a property and can't figure out what to do. HasManyToManyFacility(x = x.Facilities) .Table(UGRXFAC).BatchSize(30) .ParentKeyColumn(UGRID) .ChildKeyColumn(FACID)

Re: [nhusers] Specification pattern and Criteria API

2010-05-11 Thread Sam Dlg
predicates. So guys, this is what I'm looking for, but I have no idea how to implement it. Again thanks for your help and I appreciate all your guidance. Thanks, Sam On Mon, May 10, 2010 at 12:37 PM, Fabio Maulo fabioma...@gmail.com wrote: If you don't have any problems to spam

[nhusers] Session.Linq - handling empty lists

2010-05-04 Thread Sam
before ToList() and of course it's an enumerable that hasn't executed yet so that doesn't work. Trying to safely peek with Any() doesn't work either. Thoughts? Thanks, Sam -- You received this message because you are subscribed to the Google Groups nhusers group. To post to this group, send email

Re: [nhusers] Session.Linq - handling empty lists

2010-05-04 Thread Sam Dlg
Message- From: nhusers@googlegroups.com [mailto:nhus...@googlegroups.com] On Behalf Of Sam Sent: Tuesday, May 04, 2010 10:35 AM To: nhusers Subject: [nhusers] Session.Linq - handling empty lists Not sure what I'm doing wrong, but I have a nhib linq query that returns no results

[nhusers] Re: NHibernate.Linq Where clause doesn't do strings correctly

2010-04-26 Thread Sam
it with a handwritten sql statement. Any help is appreciated. Sam On Apr 24, 8:38 am, Tuna Toksoz tehl...@gmail.com wrote: That being said, it would be cool if we can see NHProf or SQL Prof output for this query. Tuna Toksöz Eternal sunshine of the open source mind. http://devlicio.us/blogs

[nhusers] SessionFactory discovery at runtime

2010-04-26 Thread Sam
strings. This dictionary is then used to create the sessionFactories (as singletons) just in time? 2.) Create SM profiles? 3.) another approach? We require that our sessions live through the http request only. - Sam -- You received this message because you are subscribed to the Google Groups

[nhusers] NHibernate.Linq Where clause doesn't do strings correctly

2010-04-24 Thread Sam
().Where(x = x.Id == otherObject.Id); Yes, you are seeing this correctly, the legacy database has certain Ids as strings. Could that be the issue? Sam -- You received this message because you are subscribed to the Google Groups nhusers group. To post to this group, send email to nhus

[nhusers] Business Logic Queries within Session

2010-02-06 Thread Sam Kimmel
I'm writing a proof-of-concept app for using NHibernate and have a quick question... The code below is a simple method for updating an existing user object. We intend to utilize web services so it is written with a session per method (also why the user is merged into the session, then evicted at

[nhusers] Best Practices for Sessions in Web Services?

2010-01-27 Thread Sam Kimmel
What are the best practices for using NHibernate in web services (or in any n-tier pattern) where you pass your object out of the scope of the session to the client, have them modify it, then send it back for persistence? Simple Example with User object: * Client calls service to request

[nhusers] Re: Best Practices for Sessions in Web Services?

2010-01-27 Thread Sam Kimmel
/modify individual views because the view's Model isn't shared by multiple views. It's also easier to see what a view does because the view model will only contain properties it needs. On Jan 27, 4:24 pm, Sam Kimmel sweep...@gmail.com wrote: What are the best practices for using NHibernate

[nhusers] Why would I get this error while using NHibernate.Validator?

2010-01-23 Thread Sam Kimmel
I currently have 3 tiers to my application: 1) Entities (decorated with NHV attributes) 2) Data (Contains my session manager and Data access objects. Validate objects prior to save/update in the DAOs.) 3) Web (Calls data access objects to get/save/update entities) The error below gets

Re: [nhusers] Re: Why would I get this error while using NHibernate.Validator?

2010-01-23 Thread Sam Kimmel
23, 2010 at 4:28 PM, Fabio Maulo fabioma...@gmail.com wrote: such destabilization. 2010/1/23 Sam Kimmel sweep...@gmail.com Okay, I was able to fix this error by modifying the code in NHibernate.Validator slightly. I was reading some forum discussions on the Operation could destabilize

Re: [nhusers] Re: Why would I get this error while using NHibernate.Validator?

2010-01-23 Thread Sam Kimmel
://forums.asp.net/p/981415/1255521.aspx... kind of ridiculous. I'll document my process and post things to JIRA as I find them and fix them. On Sat, Jan 23, 2010 at 9:38 PM, Fabio Maulo fabioma...@gmail.com wrote: No Sam, no... what I'm saying is that somebody in MS had the brilliant idea to define something

[nhusers] Re: NHibernate ProxyGenerators - Update to Support 2.1.2?

2010-01-22 Thread Sam Kimmel
: NHibernate.Cfg.Environment.UseReflectionOptimizer = false; config = new Configuration().Configure(); Should the XML configuration be working? On Jan 22, 1:12 am, Sam Kimmel sweep...@gmail.com wrote: I downloaded the Castle Dynamic Proxy trunk and noticed that there was not an AssemblyInfo file so I added one

[nhusers] NHibernate ProxyGenerators - Update to Support 2.1.2?

2010-01-21 Thread Sam Kimmel
I am working on a web project and medium trust is a requirement. I downloaded the NHibernate Proxy Generator contrib (1.0.0 Beta 621) and quickly found out that it was created with NH 2.0.1, which was before the Castle Proxy stuff was split out. I wanted to work with the latest and greatest so I

[nhusers] Re: NHibernate ProxyGenerators - Update to Support 2.1.2?

2010-01-21 Thread Sam Kimmel
On Jan 21, 2:39 pm, Sam Kimmel sweep...@gmail.com wrote: So the error above is a known issue with Castle Dynamic Proxy 2.1? I'll try your suggestions when I get home tonight. On Jan 21, 2:03 pm, Fabio Maulo fabioma...@gmail.com wrote: Now you can : 1) download NH2.1.2GA sources 2

[nhusers] Re: NHibernate ProxyGenerators - Update to Support 2.1.2?

2010-01-21 Thread Sam Kimmel
System.Web.MapHandlerExecutionStep.System.Web.HttpApplication.IExecutionStep.Execute () +93 System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean completedSynchronously) +155 On Jan 22, 12:07 am, Sam Kimmel sweep...@gmail.com wrote: Fabio, I tried what

[nhusers] Mapping Attributes - Why class name and id type required?

2010-01-20 Thread Sam Kimmel
After a couple days of tinkering around I was able to get NHibernate.Mapping.Attributes (2.1 GA) to work. Does anyone know why I need to explicitly specify the Class name or the type of the ID in the attributes? It is smart enough to figure out the names and types of the properties without

Re: [nhusers] Mapping Attributes - Why class name and id type required?

2010-01-20 Thread Sam Kimmel
as easy to use. Diego On Wed, Jan 20, 2010 at 14:31, Sam Kimmel sweep...@gmail.com wrote: After a couple days of tinkering around I was able to get NHibernate.Mapping.Attributes (2.1 GA) to work. Does anyone know why I need to explicitly specify the Class name or the type of the ID

[nhusers] Re: NHibernate in Medium Trust

2009-07-16 Thread Sam Kimmel
will follow Fabio's advice and ask for guidance from the list. I may also do as Markus suggests and pick up the Manning book. I apologize if I've offended anyone as it was not my intention. Is there a moderator that can lock or remove this topic? Best Regards, Sam

[nhusers] NHibernate in Medium Trust

2009-07-15 Thread Sam Kimmel
in the downloadable zip on the front page, pronto! Have a good one! Sam --~--~-~--~~~---~--~~ You received this message because you are subscribed to the Google Groups nhusers group. To post to this group, send email to nhusers@googlegroups.com To unsubscribe from