Wilson ORMapper Forums : General Support

ORMapper

Tue, 20 May 2008 16:55:40 GMT

My contributions have stopped, and it is now open source. I don't think there has been much activity there recently either, but I could be wrong. The biggest problem is that the ORMapper is very much feature rich and stable, so there stopped being significant reasons to invest more time in it, especially given the new MS Linq-based O/RMs.

ORMapper

Tue, 20 May 2008 13:59:23 GMT

Is the ORMapper project still going, either here or on Google?

varchar(8000)

Tue, 18 Mar 2008 15:38:24 GMT

I ran into the same problem. I think this is related to the following issue:
You may receive an error message when you try to populate a SQL Server 2000 table with a Data Generation plan in Visual Studio 2005 Team Edition for Database Professionals: "System.Data.SqlClient.SqlError: Disallowed implicit conversion from data type nte

Note: I find it ironic that the title of this KB article is truncated on Microsoft's site, probably for being too long. :)

Regards,
Tim

How to abort a long running query?

Tue, 11 Dec 2007 14:26:41 GMT

I'm developing a WinForms application that uses the OR mapper against an Oracle db. I have a query that could potentially return millions of rows, so I want to provide a way for the user to cancel the query if it´s taking too long.

I'm calling the Objectspace.GetCollection() method on a separate thread, and all I can think of is to abort that thread and return control to the user, leaving the query running in the database until it completes.

Is there any better way to do it?

Indexing best practices

Thu, 08 Nov 2007 22:14:08 GMT

Hi Kel:

The same guidelines as usual apply. An O/RM doesn't change anything, it just automates it. On your own manually you would still specify filters, sorts, and pages and load objects.

Profiling and index wizards can help a lot of course. But you should also "know" your data and the usage that the UI allows. Some fields are obvious filter / sort choices, and so you may (but maybe not depending on the other factors too) want to index those. The other fields that you do not index may be something that you don't even want to allow the user to filter / sort upon in the UI (but that's really a business decision so there's no hard rule).

The nice thing about O/RMs is that they enforce consistency in your generated sql, so you can often better optimize things, assuming that you do the proper profiling and planning. But the work is still yours just as it would have been -- O/RMs just make the coding easier and more consistent, they don't remove the need for a DBA or other design aspects.

Thanks, Paul Wilson

Indexing best practices

Thu, 08 Nov 2007 19:07:27 GMT

Given how ORM tools work in the sense of filling up an entire object with its data, even when lists of objects are retrieve, are there any best practices on how to index tables in the database to support this functionality?

Thanks.

Kel

Open Source Wilson ORMapper

Tue, 30 Oct 2007 11:30:49 GMT

Jason -- you are more than welcome to do those things directly on the Google Code site. All you need to do is provide me your Google login name and I'll make you a project member.

I also think the Google project should include WORM-related items such as the many CodeSmith templates (yours included). Having all this in one place will only make it easier for people to find useful tools to help in adopting the O/R mapper.

- b

Open Source Wilson ORMapper

Mon, 29 Oct 2007 20:46:53 GMT

Well, there may be code in the subversion repository, but that is not the same as having downloads.

If you go to http://code.google.com/p/wilsonormapper/downloads/list, there is nothing there and I personally feel one shouldn't have to have Subversion installed to get at the code.

I would also like to see it have its own Google Group - I know you (Brian) have something called WilsonORWrapper or something like that, but I think that should be kept completely separate, since it has nothing directly to do with WORM.

Would also love to know what is going to be done to sort through feature requests, assign priority to them, etc. Managing a project like this isn't as easy as simply giving some people the right to check in code, there need to be plans and goals and rules, etc.

Also, I think the thing that is desperately needed before anyone modifies any code is a huge set of unit tests that will ensure any future changes or bug fixes don't break currently-understood and expected behavior. That to me should be the first thing done before any code is modified (including any bugs fixed!).

- Jason Bunting

Open Source Wilson ORMapper

Mon, 29 Oct 2007 20:10:19 GMT

Wrong!!! ;-)

I contacted you about a fix, and YOU fixed it! Only because I didnt dare...

Anyway, thanx for all the hard work Brian setting up the repository and of course for your time saving work on WORW.

Open Source Wilson ORMapper

Mon, 29 Oct 2007 19:06:47 GMT

The Google Code project has all the source code for the 4.2.2.0 release (or whatever release was pre-Subscriber Release), with some small changes (mostly cosmetic) in the SVN repo. The pre-VS2005 project files aren't there because I don't have VS2003 on my workstation any more.

The project is there and waiting for anyone who wants to contribute to it or submit patches to it. So far, not a single person has done so much as contact me about it. If you want to have direct check-in access to the repo, let me know.

Open Source Wilson ORMapper

Fri, 26 Oct 2007 06:18:32 GMT

...continuing...

Also, what about Jeff Lanning's involvement? I love OPath and I know he was planning on adding features to it in the past, but I also know he 'lost that loving feeling' after a while and seems to have moved on as well. Would love to see him finish up some of the original OPath features and add a few others.

- Jason Bunting

Open Source Wilson ORMapper

Fri, 26 Oct 2007 06:14:56 GMT

To be technical about it, WORM was already open-source for those that had paid.

;)

I love the idea and understand all of your reasons and think it wise to do this. I know that WORM (coupled with my CodeSmith templates) has saved my clients and I tons of hours and made development enjoyable again.

Now, that said - I have a question: will the version you include in your downloads reflect the latest licensing?

Also, it appears as though Brian has forgotten about this, the Google site he set up doesn't appear to be very active or have anything available for download, and we are coming up on two months since your announcement.

Might be a good idea, once that group *does* start up, to lock these forums down to prevent further posting, so as to help there be "one place" to find information.

Anyway, thanks for the years of help on this product, I know it was a significant factor in many of my projects, personal and professional.

More than one connection

Wed, 17 Oct 2007 21:59:40 GMT

I can't think of anything built-in that would handle that scenario.

Sorry, Paul Wilson

More than one connection

Tue, 16 Oct 2007 15:39:20 GMT

Hi Paul,

Is there any way to have 2 or more connections pointing to differents databases using the same Template?

I mean, now I have one datamanager class with one objectspace object, and all the Mapped classes points to this objectspace. What I have to do for having more than one objectspace?

For example, to read values from database A and write in other database B, being A and B the same E/R, and so using the same mapping.

Thanks.

Strong Typed Queries

Fri, 28 Sep 2007 00:22:52 GMT

Have you looked at the QueryHelper? Its admittedly not as nice as you would like, but its got that far off if you don't mind putting the class.property into a string. Once you do that it will translate the class.property to the proper table.field with the correct delimiters for your database. There are also some overrides to handle operations using an enum, instead of just assuming equality, so again its not that far off. That's not to say it couldn't be better if you could avoid the string completely, but that does require some type of code gen, although that may actually be something that could be automated in asp.net with its build providers.

Thanks, Paul Wilson

Strong Typed Queries

Thu, 27 Sep 2007 16:48:15 GMT

First you'd need some kind of code generation, like NHibernate Query Generator, to generate the relevant classes and query logic. If you could reverse engineer that code to work with WORM, it would be quite the useful utility. :)

Strong Typed Queries

Wed, 26 Sep 2007 19:14:04 GMT

How does everyone handle queries? Are you all typing out your WHERE clauses via a string? There has to be a better way. OPathQuerys help, but I just think they are not there yet. It would be nice if there was a Query mechinism similar to SubSonic's Query object. SubSonic generates structs for all your domain types so you could write a query in a strong manor, but they use "tables" and "columns", I think I would want it related to the objects themselves instead of the underlying database tables and columns. Something like this for example:

Products being the generated struct.

Query query = new Query(typeof(Product));
query.AddWhere(Products.ProductType,QueryType.Like,ProductTypes.BathSoap);
query.AddWhere(Products.Order.OrderDate,QueryType.GreaterThen,DateTime.Now);

...etc

Or maybe LINQ will make this a mute point?

ObjectSpace: Entity Object not being Tracked - Logic.Customer:-2

Mon, 10 Sep 2007 11:02:30 GMT

I found this post somewhere in the threads:

http://www.ormapper.net/Forums/Default.aspx?part=74&action=thread&id=2161&key=Y18kziysA5mSDDaOAvDqWQ%3D%3D

I added that change to my code, and it solved the problem. I'm not sure why that problem arose in the first place, but this resolved it.

However, I had made another change to the DataManger class (based on Paul Welter's CodeSmith template) where the ObjectSpace is recreated on every call. This change was intended to circumvent a caching problem that I had. But it conflicts with the change above.

Since my change to recreate the ObjectSpace was a temporary hack anyway, I removed it, but I'm posting my solution for the benefit of the masses :)

Noam

ObjectSpace: Entity Object not being Tracked - Logic.Customer:-2

Sun, 09 Sep 2007 09:13:56 GMT

Locally, my site works just fine. But when I upload it my shared hosting account (which has worked until now), I get this exception. Here's the stack trace:

[ORMapperException: ObjectSpace: Entity Object not being Tracked - Logic.Customer:-2]
   Wilson.ORMapper.Internals.Context.get_Item(Object entityObject) in Context.cs:45
   Wilson.ORMapper.Transaction.PersistChanges(ICollection entityObjects, PersistDepth persistDepth) in Transaction.cs:464
   Wilson.ORMapper.ObjectSpace.PersistChanges(ICollection entityObjects, PersistDepth persistDepth) in ObjectSpace.cs:1412
   Wilson.ORMapper.ObjectSpace.PersistChanges(Object entityObject, PersistDepth persistDepth) in ObjectSpace.cs:1391
   Logic.Customer.Save(Boolean includeChildren) in Customer.Generated.cs:138
   Logic.Customer.Save() in Customer.Generated.cs:127
   Logic.Cart.CreateCart(String sessionId, String ipAddress) in Cart.cs:41
   Logic.Cart.GetCartBySession(String sessionId, String ipAddress) in Cart.cs:26
   Web.UI.Controls.CartStatusControl.Page_Load(Object sender, EventArgs e) in CartStatus.ascx.cs:11
   System.Web.Util.CalliHelper.EventArgFunctionCaller(IntPtr fp, Object o, Object t, EventArgs e) +15
   System.Web.Util.CalliEventHandlerDelegateProxy.Callback(Object sender, EventArgs e) +34
   System.Web.UI.Control.OnLoad(EventArgs e) +99
   System.Web.UI.Control.LoadRecursive() +47
   System.Web.UI.Control.LoadRecursive() +131
   System.Web.UI.Control.LoadRecursive() +131
   System.Web.UI.Control.LoadRecursive() +131
   System.Web.UI.Control.LoadRecursive() +131
   System.Web.UI.Control.LoadRecursive() +131
   System.Web.UI.Control.LoadRecursive() +131
   System.Web.UI.Control.LoadRecursive() +131
   System.Web.UI.Control.LoadRecursive() +131
   System.Web.UI.Control.LoadRecursive() +131
   System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +1061

If I refresh the page, the number following the "Logic.Customer" in the exception message is incremented.

The code I use where this crashes is:

            Customer customer = new Customer();
            customer.Save();

In trying to fix it, I've changed it to

            Customer customer = new Customer();
            DataManager.ObjectSpace.StartTracking(customer, InitialState.Inserted);
            customer.FirstName = String.Empty;
            customer.LastName = String.Empty;
            customer.Save();

But neither of these nor other variations I've tried seem to make a difference.

Any idea what could be causing this? Or how to go about fixing it?

Thanks,
Noam

Open Source Wilson ORMapper

Sat, 08 Sep 2007 16:16:22 GMT

Thanks, Paul, for everything you've done with your O/R mapper over the years. I'm sure I speak for the community when I say that we'll do our best to continue its success in your name!

The Google project is set up: http://code.google.com/p/wilsonormapper/

I haven't checked in any code yet, but I expect to over the weekend. It will be the 4.2.2.0 release with only some minor changes to reflect the move to open source (i.e. new license headers, removal of the DEMO license restrictions, and other things) -- nothing functional. Over the coming weeks we'll port some of the subscriber preview changes and other community fixes to the Google project, and take it from there.

Open Source Wilson ORMapper

Sat, 08 Sep 2007 01:34:26 GMT

I'm a subscriber, and personally, I think that this is a great move. To me, the ORMapper for $50 is a steal. It has saved me so much development time that I would have been happy to have paid $1000 or more for it (I bet you're kicking yourself now ;).

Thanks again for such a great product!

Tim

Open Source Wilson ORMapper

Sat, 08 Sep 2007 01:34:15 GMT

Hey, Paul. I think going open source with ORMapper is a great idea! I completely understand your desire to focus on new development, and I'm sure most developers would agree. ORMapper has always been far more valuable than the paltry $50 subscription fee, and it has saved me countless hours of development. I can't imagine anyone who has really used the ORMapper having complaints or feeling short-changed with you going open source. You've contributed a great deal to the .NET community. I hope that you have been and will be well-rewarded.

David Neal
www.christianasp.net

Open Source Wilson ORMapper

Fri, 07 Sep 2007 14:58:52 GMT

I'm going to be changing the ORMapper to open source very soon and I wanted to make sure that everyone that has paid understands. First, the intent of my subscription was never to have a commercial product that would require updates and support forever. Many of you may even remember that I started back in 2002 with a simple website that featured page templates and best practices. In my pursuit of learning and trying things out things I added more features, like multiple forms, localization, master pages, and more. And then I became interested in O/R Mapping and at the time very few options were available for .NET, but MS was planning ObjectSpaces. Had something like NHibernate existed at that time then I most likely would never have went down this path, but it simply did not exist yet. So I made my own simple ORMapper and gradually added more features -- all for my own use initially, hoping to move to ObjectSpaces at a later time. Well ObjectSpaces was dropped, and enough people loved my ORMapper that it took on a life of its own, even after NHibernate due to the simplicity. But the cold hard facts are that I have simply been unable to find the time for far too long to continue updating and supporting the ORMapper. For the most part that hasn't been a huge deal since the ORMapper has been feature rich enough for the vast majority of users for some time now. Its also been extremely stable for the vast majority of users, although there is a "zombie" issue that a small minority of users have faced. There is also a user submitted patch for that which I have yet to officially apply since I have never been able to reliably reproduce the issue. So since users have long contributed back, and have apparently fixed this bug also, it really makes sense to just make this open source given my lack of time. Its also worth pointing out that Linq to Sql is just around the corner, and while it certainly isn't perfect, it is nonetheless probably good enough for me. And that means that it will become one of my main priorities when I do find time, already absorbing the little bit I have found, and that's not fair to the ORMapper. Also, in the spirit of my original intent, I want to use my time to continue learning and trying out new things, and that runs counter to more time on the ORMapper. So while some of you may feel you've now paid unnecessarily, my hope is that I will be able to do something else cool that you will get access to as subscribers. Very much like my original subscribers paid for page templates and eventually got a free ORMapper, you will at some point find more things on my site if I move on. For instance, I'd like to radically revise my portal framework to feature Linq to Sql and more, which will focus on best practices you can use even if you could care less about the portal itself. Of course that depends on me finding enough time, but I'm more likely to find time to do something totally new since I have to learn and try out these new things anyhow. So to finish this email before I go on longer, look for an announcement from myself and Brian DeMarzo in the coming days or weeks about the ORMapper being open source.

Thanks, Paul Wilson

"ObjectSpace: SetField failed for...." error

Sat, 25 Aug 2007 15:45:50 GMT

It sounds like your GoDaddy site doesn't have the necessary reflection permissions. If they have given you just the standard medium permission set then you'll need them to specifically give you the reflection permission. Many hosters routinely do this since there are so many cases and libraries that require it, and at one time MS was even considering adding a standard "hoster" permission set that would include this (although I don't think they ever delivered). If I remember correctly, the alternatives are to map public properties instead of private fields, or to use the IObjectHelper interface -- but its been a while and I may be off a little on the exact details of the alternative.

Thanks, Paul Wilson

"ObjectSpace: SetField failed for...." error

Sat, 25 Aug 2007 14:35:06 GMT

Hi,

I have recently started using The WilsonORMapper and am new to the capability. I get the following error when retrieving an GetObjectSet. "ObjectSpace: SetField failed for..". The odd thing is that my mapping file is very simple (with no relationships being used) and the only change I have made to it that most tables do not use an identity column for the primary key but a user defined one (example attached).

Also interestingly I do not have any problems running the application locally either in debug mode or hosted as a website on my machine. However the error is encounted when I host the application on my website (GoDaddy). I am wondering if this has anything to do with the SQL Server versions. On my local machine I have is "9.00.3042.00, SP2, Express Edition" and on the website it is "9.00.3050.00, SP2, Standard Edition (64-bit)".

Any other information associated with rectifying the problem would be appreciated.

Please note that the "Engine.ExecuteScalar" works fine in all cases.

Thanks
Nilesh

Handling nulls right.

Wed, 22 Aug 2007 20:18:42 GMT

Thank you Paul. That's great and everything is clear now.

JOIN Scenario?

Wed, 22 Aug 2007 19:38:07 GMT

Other than the Lookup for individual properties, you'll have to manually manage associations if you need more control. For instance, I do a lot of caching for objects that I know are mostly static, and so instead of using the ORMapper to pull associations, I use the ORMapper once for each type and then cache the results -- then my objects use my cache to get their associations. Its not a hard concept, or even hard code, but it is custom code nonetheless. NHibernate's certainly has more built-in options, although in my experience my manual solutions, which are still populated with my ORMapper, far outperform the pre-built solution that are overly generic.

Thanks, Paul Wilson

JOIN Scenario?

Wed, 22 Aug 2007 14:32:51 GMT

In a Many-To-One relationship, is it possible to load all parent objects using a JOIN? Similar to NHibernate's "fetch=join" attribute?

For example, if I have a large list of orders I need to display in a grid. One of the columns is the order's customer's name. So everytime I call Order.Customer.Name it makes a SQL call to load the Customer object. With lazy="false", it pre-loads them (which is expected) but it still makes a seperate SQL call for each Customer object.

Is there anyway to tell the mapper to use a join instead? I realize I could use the Lookup field, but I dont think I should have to create lookup fields for all the Customer's properties. And dont really want to. (CustomerName, CustomerAddress, CustomerPhone etc). Or is that only way?

Travis

SQL IN

Wed, 22 Aug 2007 12:02:22 GMT

Hi David:

You can make the where clause anything you want. In the simplest cases its of the form "x = y", which the ObjectHelper assists with. But there's nothing stopping the where clause from being of the form "x in (select y from . . .)". Its certainly something to avoid if possible, but sometimes things do get ugly -- you can also use a stored proc which avoids the ugly code, but of course makes it more database dependent.

Thanks, Paul Wilson

SQL IN

Tue, 21 Aug 2007 21:38:09 GMT

Hi!

I just can't figure out how to do the following efficiently :

SELECT * FROM TABLE1 WHERE ID IN (SELECT ID FROM TABLE2 WHERE SOMETHING)

The only solution I can think of is to first execute the inner sql and get an ObjectSet and then to iterate on it and call GetObject for each ID. Needless to say this is very very slow.

How could I do this in WORM in a beautiful and efficient code?

Thank you!

David

Cannot download registered ormapper

Mon, 20 Aug 2007 14:11:01 GMT

Hi Paul,

I managed to download the files a few days ago. I guess it had something to do with the hosting, like you said.

In any case, I have not received anything from you (fyi) and I was starting to get worried, but it's moot now, and things are looking up.

Also, I'm using Firefox and have IE7 installed, so it definitely is not related to IE6, but that's all moot now as well. Just mentioning it in case others have the same problem.

Finally, I've started using the ORMapper seriously now, and have some questions, but I'll post them elsewhere.

Thanks immensely!
Noam

Very interesting observation

Fri, 17 Aug 2007 01:56:47 GMT

Hi David:

The ObjectQuery constructor just wants a raw sql where clause, so if your table is named Apple and your column is named Color, then this works just fine. As for the case being COLOR, most databases are case insensitive when it comes to table and columns (and most everything else for that matter). On the other hand, .net is case sensitive (VB is not, but the IL underneath is), so the mappings and the manner that I store them must be since it matters quite a bit.

So why use the Helper.GetExpression method? Because in many (if not most) cases your objects and members are not named the same as the underlying tables and columns, and you shouldn't have to know that detail since the ORMapper has that information for you.

Thanks, Paul Wilson

Handling nulls right.

Fri, 17 Aug 2007 01:46:10 GMT

Oops. It does do "something" for both reading and saving, but not what I said. The nullValue setting is what nulls in the database get converted into, and similarly that value gets converted back to null when saved to the database. That's of course not what you were wanting at all, as you don't want nulls in your database, so the second option is by far the best I can think of.

So what is nullValue for by the way? Its for value types that cannot be null in code, but can be null in the database. And that's not necessary if you're in .net v2 since you have nullable types.

Sorry, Paul Wilson

Handling nulls right.

Thu, 16 Aug 2007 19:34:10 GMT

Hi! I actually tried nullValue="", but it didn't change anything.. As far as I can see that only influences *reading*- so if the null value is already in the DB and I read it, I will magically see it as "". It didn't work for this case. So when trying to save NULL to the DB, it still generates an exception and is not converted to "" beforehand. Can you confirm that? So is nullValue just for reading - writing doesn't pay attention to it, it seems!? THANK YOU!

I see.. I can set the member to "" in a class. I was reluctant to change the generated code, because I thought I will generate it again if the database changes so much that it's better to do it that way instead of adding things manually... But you explained what's the philosophy with this in an email.. I'm posting it for the others:

Hi David:

Sorry, but there is no one best practice or right answer here.  It comes
down to your software methodology and even your own style.

There are methodologies that use extensive code regeneration.  But they are
typically very strict metholodogies to make sure you both don't lose the
custom changes you do make and to minimize the need for those.  The ORHelper
is definitely not a tool that will work in that type of methodology.  Why?
Because it was simply never designed or intended to be anything more than a
quick and ugly start.  I did not feel that delivering the ORMapper without
any "helper" to get people started was good enough, but Nhibernate succeeded
quite well without such a "helper".  Why?  Because a good O/R Mapper in no
way depends on such "helpers" -- thus my users made their own CodeSmith
templates, as did Nhibernate's users, and many rely on doing things manually
since the whole point of an O/R Mapper is your custom objects, plus a little
xml glue.  Can a strict code regeneration methodology use an O/R Mapper?
Sure, but they will use flexible and customizable CodeSmith templates, and
while some of the ones my users have provided may help, you'll also find
you'll need to customize them to really do that right.  This is really a
whole subject all its own -- i.e. there is at least one book I know of on
code generation methodology, and there are many consultants and tools out
there.  The ORMapper on the other hand is simply a consumer of your code,
and how you produce your code is of course up to you.

I'm not personally into code regeneration.  Why?  I've been around it just
enough to know that it either doesn't work well, or requires extensive
methodology that is strictly followed.

Thanks, Paul Wilson

Very interesting observation

Thu, 16 Aug 2007 17:04:18 GMT

Hi!

I just found out about some rather curious "feature"... I'm sure it has a simple explanation and I'd like to hear it..

I tried this code just for fun:

ObjectQuery query = new ObjectQuery(typeof(Apple), "Apple.COLOR=6", string.Empty);
Manager.GetObjectSet(query);

And it runs and works!! Although the property is actually Color (not COLOR).. Of course it is not checking for this, but I don't know how it populates it!?

This is how it's supposed to be done:

string where = helper.GetExpression("Apple.Color", 6);
ObjectQuery query = new ObjectQuery(typeof(Apple), where);

Manager.GetObjectSet(query);

If I change the ".Color" to ".COLOR" in GetExpression it throws QueryHelper: EntityAlias was not Found - Apple.COLOR.. As expected..

So my question is why the first example worked (and correctly binded the property)?

Thank you!

David

Handling nulls right.

Tue, 14 Aug 2007 23:41:31 GMT

Hi David:

Just set nullValue="" in the mapping file for that property !

Another approach that's more work, but more in line with typical business / validation logic approach is to first initialize the value to "" instead of the default null, and then to have the property setter check for nulls and to set "" instead:

private string x = "";

property string X {
get { return this.x; }
set { this.x = (value == null ? "" : value); } // or use (value ?? "") if .net v2
}

Thanks, Paul Wilson

Handling nulls right.

Tue, 14 Aug 2007 19:57:24 GMT

Hi!

I would like to know the following.. I have a regular string column Apple.Color in database (which is NOT NULL and has a default value set to "").

So the class for that table that gets generated has a member:

string color;

and a corresponding property. By default this value is null and doing this

Appel apple = (ProfileStatus)Manager.GetObject(typeof(Apple));
apple.NumberOfWorms = 3;
Manager.PersistChanges(apple);

Will throw an exception, because apple.Color == null and database doesn't allow nulls. The only reasonable workaround is to explicitely say apple.Color = ""; before persisting the changes.. I'm not sure how beautiful that approach is though.. is there no way that generated classes would set the value to a deafult value as in database?

Thank you for the answer!

David

Cannot download registered ormapper

Tue, 14 Aug 2007 01:05:18 GMT

It should be fixed now -- hosting provider redid drives and I hadn't thought about how that would affect this one thing.

Thanks, Paul Wilson

Cannot download registered ormapper

Sun, 12 Aug 2007 14:27:31 GMT

Its possible there was something down when you tried, although its certainly not typically down, but I've emailed you the code directly to be safe.

There is also another possibility, although this usually manifests differently so I'm not sure this is the same thing. Basically there is an esoteric bug in the asp.net framework that leaves a couple of IE6 users unable to do some things. In every case I've dealt with they are able to succeed with IE7 and/or FF, and in at least one case I know of the same person has used a different computer with IE6 successfully. I've seen a few other devs, unrelated to anything of mine, report the same sporadic problem, and so far to my knowledge MS has not duplicated or acknowledged this. I'm pretty sure its something in asp.net v2.0 membership and cookies, possibly related to proxies -- but I'm not real sure since it works for 99.9% of the users, and even the vast majority of IE6 users.

So if you continue to have problems, please let me know -- and send me details of your browser and OS and such.

Thanks, Paul Wilson

Cannot download registered ormapper

Sat, 11 Aug 2007 16:32:45 GMT

Hello everybody,

I tried out the demo and was very impressed with it. I subsequently purcahsed the ormapper. I created an account just fine and received the PayPal receipt by email.

The problem is that when I browse to the Downloads page while logged in and click on any download in the Subscriber Downloads list, I am automatically redirected to the home page.

So when I click on
http://www.wilsondotnet.com/Downloads/WilsonORMapperProd.aspx
in the list, the browser redirects to
http://www.wilsondotnet.com/?aspxerrorpath=/Downloads/WilsonORMapperProd.aspx

I tried contacting support on the Contact form under About-->Contact and that redirected me as well! So there seems to be no way for me to get support. Hopefully, the forum will work...

Is there any other way to download the files. This is a matter of some urgency.

Thanks in advance!

Maintaing lazy loaded child collections

Thu, 09 Aug 2007 10:57:28 GMT

Hi Jamie:

A lazy-loaded collection is actually an ObjectList. Both ObjectList and ObjectSet implement IObjectSet, but there are a few differences. I'm pretty sure one of the differences is that you can use the normal Remove with ObjectList. Otherwise you'll have to simply delete the object using MarkForDeletion and then requery if you need your list updated.

And sorry about the editor. It worked in earlier versions of FF, but it does seem that at least some later versions have the lockup. I probably need to just update the component, but man am I behind.

Thanks, Paul Wilson

Maintaing lazy loaded child collections

Thu, 09 Aug 2007 10:57:26 GMT

Hi Jamie:

And sorry about the editor. It worked in earlier versions of FF, but it does seem that at least some later versions have the lockup. I probably need to just update the component, but man am I behind.

Thanks, Paul Wilson

Maintaing lazy loaded child collections

Wed, 08 Aug 2007 13:33:26 GMT

I'm having trouble understanding how to add and remove objects from a lazy loaded child collection. My parent object is Contact and it contains a collection of ContactReason objects.

If I type my collection as IList<ContactReason>, I see that I get an ObjectSet<ContactReason>. An ORMapperException "ObjectSet: Use RemoveKey instead of RemoveAt" is thrown if I attempt to call RemoveAt(0) but there's no public RemoveKey method.

I can call contact.Reasons.Remove(contact.Reasons[0]) on an IList<T>, but not if I type my collection as Collection<T> (I get the same exception as above). If I use Collection<T>, I don't see any way to remove items from the collection. I haven't tried adding items yet.

How should I type my child collections if I'm lazy loading them? What's the best way to add and remove items?

Jamie Ide

BTW, the script for this rich text editor locks up Firefox.

ManyToOne whereClause?

Tue, 24 Jul 2007 16:09:34 GMT

Thanks for your response. I was able to workaround this using a different method. I think I ended up creating and using a stored procedure to do what I needed.

I have to look into the OPath engine one day. I haven't used it yet.

ManyToOne whereClause?

Tue, 24 Jul 2007 14:13:10 GMT

This is possible with Jeff's OPath engine. Check the OPath Docs that came with your OrMapper.

However, it does not support paging. Is it possible to accomplish this same request using another query method? (CompiledQuery, ObjectQuery)? And paging?

Subscriber-only Subversion repository

Tue, 24 Jul 2007 12:32:25 GMT

... and it helps to add a signature:

Brian DeMarzo
brian@demarzo.net

Subscriber-only Subversion repository

Tue, 24 Jul 2007 12:31:53 GMT

For those who don't know already ... Paul and I worked out an arrangement to maintain a subscriber-only source code repository for WORM. This is a private Subversion repository where we can share and add patches and improvements to the product.

What does this mean for you? If you are a subscriber to WORM, you can send me your full name and email address and request access to this private repository. I will confirm your subscription with Paul and grant you access.

The following changes have been incorporated into the aforementioned WORM instance:

Based on the 4.2.2.1 Subscriber Preview.
Unnecessary SELECT COUNT(*) calls removed (see reference post).
Performance using large data sets improved (see reference post).
A few other small changes and tweaks.

The purpose of opening up this Subversion repository to subscribers is to give us all a place to share and contribute to a central copy of WORM that includes all the improvements and patches we maintain individually.

If you want to participate, send me your full name and email address.

Possible LookupMap Bug?

Thu, 05 Jul 2007 16:55:29 GMT

Is this bug been addressed yet? If it has been addressed in the SP release, when can we expect the SP release to incorporate Jeff's OPath stuff?

Travis

Transaction problem

Wed, 04 Jul 2007 03:21:03 GMT

I'm having the same problem in 4.2.2.1. The transaction commits fine in Transaction.Commit(), but the EntityKey constructor throws a NullReferenceException while Transaction.Commit() is looping through the instances and calling CommitChanges. Did anyone ever find a solution for this problem? I'm committing about 20k records in various tables, and this takes a minute or so. I do this all the time and it usually doesn't cause a problem, but it happens every once in a while for whatever reason. I'm running SQL 2005 SP2, .NET 2.0 under Vista.

DB View Mapping Problem

Wed, 27 Jun 2007 20:47:17 GMT

You need to specify keyType="None", not keyMember. Otherwise you are still getting the default keyType="Auto", and its looking for a member named None.

Thanks, Paul Wilson