WilsonDotNet Forums : Data Related

Paul: paid but cannot download - URGENT

Tue, 14 Aug 2007 01:04:42 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

Paul: paid but cannot download - URGENT

Mon, 13 Aug 2007 22:14:22 GMT

It looks like I need to fix something -- sorry about that. I'll try to get it this evening, in the meantime you can mail me: Paul at WilsonDotNet.com.

Thanks, Paul Wilson

Paul: paid but cannot download - URGENT

Mon, 13 Aug 2007 09:35:36 GMT

I go to subscriber downloads and try to download WilsonORMapperProd.zip, but I get redirected to:
http://www.wilsondotnet.com/?aspxerrorpath=/Downloads/WilsonORMapperProd.aspx

This is really important for us, because we ship the new version in two days and we already ported the backend to ORMapper.. We're stuck...

Thank you!

Wilson ORMapper VS Linq to SQL

Fri, 27 Jul 2007 11:03:30 GMT

I have been looking into using Linq to SQL, but find it very hard to fit this technology into a conventional n-tier application, with a Business Logic Layer etc. Hence, until I can crack that, I'm using the trusty Wilson ORMapper. My temptation is to carry on using the ORMapper until Linq to Entities comes out in 2008. Has anyone got any suggestions on how to plan ahead, making applications future proof, to transition between the mappers, and keep a layered design to apps?

Cheer, Andy

Disconnect

Tue, 31 Oct 2006 14:49:40 GMT

The ORMapper does not require much from your classes -- i.e. you can use a base class or not, you can use properties or fields, you can use the IObjectHelper or not, etc. That means that you can create your classes and mappings in just about any way -- i.e. manually by hand, with my ORHelper app, or with some of the CodeSmith templates others have created. I don't use the CodeSmith templates -- I use my ORHelper to get a quick start and then tweak things by hand, thus you won't see my examples looking the same as the CodeSmith generated files you may create. I think its mostly a question of style which method you use -- in other words, I would not include the CodeSmith templates if they did not seem to be good enough, and certainly many do use them with success, but they are not my personal style so I don't use them myself. And by the way, subscribing gets you the production dlls and the source code, but don't expect any more documentation. :)

Thanks, Paul Wilson

Disconnect

Tue, 31 Oct 2006 14:37:46 GMT

I am trying to evaluate your product and I don't understand the disconnect between your examples and the files generated by the WORMFramework cst files.

Can you please explain what their relationship is.

It appears to me that the demo's entity classes are all hand coded instead of generated by the mapper. Am I missing something?

My generated code against my database has many more files than your example.

It hase base classes for the entities, it has base objects for the collections. None of these appear in your demo or documentation.

If I purchase your product will I be getting more detailed information about these things?

Using store procedures.

Tue, 26 Sep 2006 09:04:59 GMT

I'm going to assume you are asking about the ORMapper -- note that it has its own forums at http://www.ORMapper.net/Forums. Anyhow, this scenario is supported by the ORMapper. The select from a view is the easiest part, as the mapper doesn't much care if the "table" is a view. As for the inserts, updates, and deletes, the mapping file has optional settings for insertSP, updateSP, and deleteSP, and you can specify the parameter for the attributes. See the wiki for the mapping file syntax, and there is a very minimal example here.

Thanks, Paul Wilson

Using store procedures.

Tue, 26 Sep 2006 08:49:23 GMT

Supose I had a situation where I wanted to use a view to select, a procedure to delete and another procedure to create and update, how would I do it?

The reason I am looking into this is for cases where we have some embeded logic in the procedure which does some business logic validation before performing the final insert or update. Does the mapping file allow me to map members to procedure parameters?

Working with Sql Server 2005 XML Type

Thu, 24 Aug 2006 11:07:33 GMT

Not currently, but its certainly something I'll consider once I find the time to finish what I do have planned -- and finding time is by far the big problem right now.

Thanks, Paul Wilson

Working with Sql Server 2005 XML Type

Wed, 23 Aug 2006 21:58:47 GMT

Any plans to support reading in a xml type directly into a SqlXml property as opposed to a string property as it does currently?

Thanks in advance!

Marty Hope

Oracle CLOB and BLOB types

Thu, 27 Apr 2006 11:31:13 GMT

Hi,

This post is just to share some knowledge, since, I have spend some time with this data types in Oracle.

I am using VS2005 and

For CLOBs all you have to do is to denote in the mapping file that the datatype of your field/property is System.String

For BLOB the type is System.Object but be careful that this property within your created data objects should store byte arrays.

Both types seems to work perfectly with the O/R mapper

Converting from NHibernate to ORMapper to ObjectSpaces

Thu, 06 Apr 2006 22:19:39 GMT

Hmmm, well in that case, I would need more information about what this would involve, including where to find more information since I'm obviously unfamiliar with this. I would especially need to obtain information about how to handle the cases where I do have the contributions of others. My honest guess is that there is still going to be far too much cost on my end, whether it be financial or documentation, but I'm certainly willing to look at it a little closer if I can get more information.

Thanks, Paul Wilson

Converting from NHibernate to ORMapper to ObjectSpaces

Thu, 06 Apr 2006 22:12:44 GMT

They would probably pay. strongpoint.spam@comcast.net

Converting from NHibernate to ORMapper to ObjectSpaces

Thu, 06 Apr 2006 16:55:30 GMT

There's no way I could issue a legally binding indemnification like that for a couple of reasons. First and foremost, that type of statement would require some significant insurance to protect me from any legal actions that were raised by someone unscrupulous enough to make counter-claims. And that has nothing to do with whether or not the code actually is mine or not -- its all about money, insurance, and legal crap that I want no part of since I only make a little extra money by selling things for $50. Another problem is that there are parts of my ORMapper that are other people's code -- the only significant place this occurs is the OPath engine that has been donated by Jeff Lanning, but there are other smaller pieces contributed by others also. That shouldn't be a problem for most people, and its no different than most other products, especially open source ones, but it would be nonetheless a tricky twist that would make it more difficult, and financially more expensive, to providing such a statement. While I certainly hate to hear that this might prevent you from using my ORMapper, there's simply no way I can justify the costs that would be required to give you what you are asking for, regardless of whether or not I feel like such a statement would be true in fact.

Thanks, Paul Wilson

Converting from NHibernate to ORMapper to ObjectSpaces

Thu, 06 Apr 2006 16:43:51 GMT

I knew I'd learn something here! Thanks for the info on ObjectSpaces. I have a contractural question for you. For considering using ORMapper long term, my client would need a statement indemnifying them against the use of ORMapper code. For instance, protection against someone saying that some piece of ORMapper code is theirs.

Any chance of this. Feel free to send me an email on this.

strongpoint.spam@comcast.net

Converting from NHibernate to ORMapper to ObjectSpaces

Thu, 06 Apr 2006 11:58:09 GMT

I've haven't heard of many having legal concerns with the pretty standard open source licenses that the big projects, like Hibernate (and NHibernate) use, but I suppose some lawyers are going to be concerned about anything. So if they have a concern about standard licenses, then I would bet they would have a concern over mine too, since its totally devoid of any legalese at all, instead basically just being a simple English gentlemen's agreement. :) Finally, you're more then a little behind if you're still thinking there will ever be an ObjectSpaces from Microsoft -- its been officially killed and replaced by DLinq for some time now, which is maybe coming in 2007. That means that my original strategy of trying to align to ObjectSpaces is now not very useful, although I believe OPath is still part of WinFS -- but DLinq itself is so far in the previews very much different (and ugly if you ask me).

Thanks, Paul Wilson

Converting from NHibernate to ORMapper to ObjectSpaces

Thu, 06 Apr 2006 11:50:42 GMT

Hi Paul,

I recently recommended NHibernate for a client who sells their software. Their lawyers recently vetoed NHibernate due to some scary ambiguities in the license agreement.

Long story short, we have a substantial amount of code that uses NHibernate that we would like to salvage. I’m currently thinking that we could semi-easily convert our stuff over to your ORMapper, and possibly convert over to ObjectSpaces when (if) it is ready.

Do you have any thoughts on this strategy?

Stupic Newbie ConnectionString Question

Thu, 23 Feb 2006 05:26:53 GMT

If the connection string itself doesn't help, then you'll need to send me the code, mappings, and db/script in a zip via email since the stack trace in this case seems to point to your code.

Thanks, Paul Wilson

Stupic Newbie ConnectionString Question

Thu, 23 Feb 2006 05:23:49 GMT

Something like this:

Server=TWIN\SQLEXPRESS;DataBase=NTA;Integrated Security=SSPI;

Thanks, Paul Wilson

Stupic Newbie ConnectionString Question

Wed, 22 Feb 2006 20:14:44 GMT

Paul,

Here's the exception detail from VB 2005 Express Edition:

System.TypeInitializationException was unhandled
Message="The type initializer for 'vbripper.DataManager' threw an exception."
Source="vbripper"
TypeName="vbripper.DataManager"
StackTrace:
at vbripper.GenresWORM.RetrieveQuery(ObjectQuery query) in C:\Software Updates\Ripper\Small Coder\Fourth Try\vbripper\vbripper\GenresWORM.vb:line 260
at vbripper.GenresWORM.RetrieveAll(String sortClause) in C:\Software Updates\Ripper\Small Coder\Fourth Try\vbripper\vbripper\GenresWORM.vb:line 65
at vbripper.GenresWORM.RetrieveAll() in C:\Software Updates\Ripper\Small Coder\Fourth Try\vbripper\vbripper\GenresWORM.vb:line 58
at vbripper.CDRead.CreateAudioDiscFolder(CDDrive& current_drive, Boolean& bOver) in C:\Software Updates\Ripper\Small Coder\Fourth Try\vbripper\vbripper\CDRead.vb:line 116
at vbripper.CDRead.ReadAudioCD(CDDrive& current_drive) in C:\Software Updates\Ripper\Small Coder\Fourth Try\vbripper\vbripper\CDRead.vb:line 432
at vbripper.CDRead.ReadCDDisc(CDDrive& current_drive) in C:\Software Updates\Ripper\Small Coder\Fourth Try\vbripper\vbripper\CDRead.vb:line 189
at vbripper.FormDevChange.ReadCD(Object stateInfo) in C:\Software Updates\Ripper\Small Coder\Fourth Try\vbripper\vbripper\FormDevChange.vb:line 187
at System.Threading._ThreadPoolWaitCallback.WaitCallback_Context(Object state)
at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state)
at System.Threading._ThreadPoolWaitCallback.PerformWaitCallback(Object state)

Stupic Newbie ConnectionString Question

Wed, 22 Feb 2006 20:10:34 GMT

Paul,

Thanks. I'll give that a shot. If I wanted to do it with a trusted connection and without changing the registry settings, what would the connection string look like?

Michael

Stupic Newbie ConnectionString Question

Wed, 22 Feb 2006 18:51:30 GMT

Hi Michael:

Without seeing the exact exception and stack trace, I can only guess. My understanding is that SqlExpress defaults to trusted connections only and will not allow you to specify a username. Jacob Carpenter suggested modifying the following registry key from 1 to 2 in order to enable sql users:

HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\MSSQL.1\MSSQLServer\LoginMode

(http://jacobcarpenter.com/mLog/ViewEntry.aspx?ID=60)

Thanks, Paul Wilson

Stupic Newbie ConnectionString Question

Wed, 22 Feb 2006 18:30:00 GMT

HI,

I'm trying to add database connectivity to a VB app that someone else wrote. I'm hoping to use WORM to help build out the basis for what I want to do. Unfortunately, I can't even seem to do the simple stuff: connect to the database.

The app has an app.config file and I tried added the following lines based on what I found in the doco and forum posts:

<add key="WORM.ConnectionString" value="Server=TWIN\SQLEXPRESS;DataBase=NTA;UID=NTA_Admin;PWD=xxxxxx" />
<add key="WORM.MappingFilePath" value="" />
<add key="WORM.ProviderType" value="MsSql" />
<add key="WORM.ApplicationType" value="Win" />

I'm running SQL Server 2005 Express and have created a database called NTA with a user of NTA_Admin. But I just can't connect. I keep getting: {"The type initializer for 'vbripper.DataManager' threw an exception."} Reading through the other lines I'm pretty sure it's choking on the connection string.

Any ideas what I'm doing wrong?

Any help would be greatly appreciated!!!

Michael

Migrate asp.net site to other provider

Tue, 07 Feb 2006 17:09:58 GMT

Did you recompile the project with that change and deploy the updated dll? If that doesn't help, then you'll need to give more details -- or maybe pay someone like myself. :)

Thanks, Paul Wilson

Migrate asp.net site to other provider

Tue, 07 Feb 2006 15:31:24 GMT

Hi, i have a portal developed by some company with the source code, and Im changing hosts but I need to change all of the database connection information, I checked the web.config file and it doesnt have any connection string information, but on the source code there is a file called config.cs, I modified the file in Visual Studio with the correct info, but I just cannot find a way to make it work, could you help me out. Could you help me out. Thanks in advance

GridView

Thu, 19 Jan 2006 05:50:09 GMT

I wish I had time for creating examples of everything, but honestly I'm not even keeping up with all the questions very well lately. Also in this case, what you're looking for is not really anything specific to O/R Mappers -- it is instead just OO design. So assuming you have the one-to-many case for now, then first make sure the Address object contains an instance of the associated Contact object (using many-to-one relationship in the ORMapepr). It might be sufficient at that point to simply expose the Contact as a property and have the Contact class override the ToString method to return a nicely formatted summary of the Contact. Then when you get your collection of Addresses (not Contacts) and bind them to your grid, that summary of the Contact will automatically show. If you need more sophistication then you can setup you bindings to have columns associated with Contact.Property for the relevant properties. Finally, you can even add properties in your Address class to expose the various Contact properties instead of just exposing the Contact as a whole.

Now for the GetXXX<type> methods -- these are .NET v2.0 generics, which you need to get familiar with before they will make sense. Basically think of them as being the same thing as the GetXXX(typeof(type)) methods, except the resulting collection is a strongly typed collection. But otherwise the usage of the generic versions are identical to the usage of the other methods -- so yes, the type does need to be defined in the mapping file.

Thanks, Paul Wilson

GridView

Thu, 19 Jan 2006 04:52:58 GMT

could you give examples of how to do both of these?

Also when you use GetCollection<someObject> or GetObjectSet<someObject> does the "someObject" need to be defined in the mapping file?

GridView

Wed, 18 Jan 2006 22:11:24 GMT

I have a similar issue.
I have a Person object with a collection of Address's.
In the mapping file Address a many-to-one relation to Person, and Person has a One-to-many to Address.

In my datagridview I want to show :

First Situation:
Person.Name, Person.Surname, AddressCollection[0].Street
(the name and surname of the person plua the street of their first address.)

Second Situation:
Person.Name, Person.Surname, AddressCollection[i].Street
(the name and surname and street of ALL the address's for that person - yes name and surname will be repeated if there is more than 1 address.)

How can I do the above?

GridView

Wed, 18 Jan 2006 17:21:44 GMT

Well either you have a situation where each contact can have multiple addresses (one-to-many) or you have a situation where each contact has at most one address (and maybe exactly one depending on your design implementation).

If you have the one-to-many case, and you want to see every address without drilling down into a master-detail, then you should be binding to the addresses and not the contacts. As long as you have a contact property in the address class (a many-to-one "parent" relationship in the mapper) then you will also be able to see the address' contact in that same row. Of course that means that you will see each contact possibly more than once, but that's simply because you've chosen to see each address and is therefore a matter of your design choices (which only you can decide if thats good or bad).

On the other hand, if you do have only one address, then you should simply have an address property in the contact class and not a collection of addresses. Internally you may need to have a collection of addresses depending on how you've implemented it, but even in that case you should expose the 0th index address instead of the whole collection. And of course if there may be no address then make sure you check for that situation since otherwise the 0th index will result in an error.

Thanks, Paul Wilson

GridView

Wed, 18 Jan 2006 07:29:05 GMT

Hi,
I am using the ORMAPPER but im running into an issue when i try to bind my gridview control, it contains information about a contact and address information, i would like to be able to show both on the same row. im getting to a point where i can get the contact information alone but im not sure how to reference my address information for each contact in my markup.. if i specify addresses[0].address1 that works if i have only one contact in the grid. but i know there must be a way to do that dynamically so it would know the index by it self.
Thanks.

SQL connectionString

Thu, 10 Nov 2005 04:12:43 GMT

I've had the same problem with getting the error: "The root element must match the name of the section referencing the file, 'appSettings'" and finally found out why it was happening in my case.

I'd copied my app.config into the bin\debug folder and renamed it to development.config. I then added it to my project to edit it, but when I used the Add Existing Item operation, I clicked on Open instead of using the drop down to choose Link File.

The result was that another version of the file was created in the project folder and I ended up editing this one instead of the one in bin\debug. When running the project, it was using the unedited version in bin\debug which still had all the superfluous stuff from the app.config file that caused the error.

SQL connectionString

Thu, 20 Oct 2005 02:55:59 GMT

Without seeing more its hard to say, but keep in mind that web.config is xml and therefore case-sensitive.

Thanks, Paul Wilson

SQL connectionString

Wed, 19 Oct 2005 22:15:48 GMT

tell me how to join ur forum
I have put the connection string into the web.config
file
and on the aspx.vb page i have declared the connection
the code i have written on the aspx,vb page is
dim conn as new sqlcoonection(configurationSettings.appSettings("connectionString")
i have made one function openconnection()
the code is
openConnection()
if conn.state = connectionState.Closed then conn.open()

at the time of execution of the statement
conn.open
it gives error
connectionString Property is not initialized properly

join two tables

Tue, 26 Jul 2005 12:17:18 GMT

Hi Bob:

Is this a schema you are forced to work with from someone else, or do you control it? I ask because unless there are other details you haven't given here, this structure has no rationale. Instead, price_amt and description should be part of the Books table, and there should be no price_id. Now having a separate Prices table might make a lot of sense if there can be multiple prices for the same book, but in that case you still won't have a price_id field in the Books table since that implies a single price, instead book_id would be in the Prices table.

If you must have this schema anyhow, then note that an instance of Price must be the parent object, and that an instance of Book will be the child object -- you can of course also enforce that there is only one child object in this case, although the schema itself from what I see doesn't dictate that most likely business fact.

Thanks, Paul Wilson

join two tables

Thu, 21 Jul 2005 23:47:53 GMT

Hi,

I have two tables as shown following:

1. Books:
a. book_id(pk)
b. book_name
c. author_name
d. price_id(fk)

2. Price:
a. price_id
b. price_amt
c. description

I want to write query for oRMapper so that i can update, insert, and delete the values of the both tables by single where string.

Tanks
Bob

Performance Issue.

Thu, 24 Mar 2005 07:23:44 GMT

Paul,

However using parameterized queries gets rid of the ugliness of dealing with dates and booleans which by default Oracle and SQL Server treat differently (when sending a string representation of the values with the SQL) making code harder to make database independent.

Thanks for the great code,
DJ

Oracle Issues

Wed, 23 Mar 2005 10:15:24 GMT

Thanks, I'll get it in the next update.

Oracle Issues

Wed, 23 Mar 2005 08:46:57 GMT

Paul,

I modified the GetObjectCount method in Context.cs and it now supports both Oracle and SQL Server.

// Includes GetObjectCount by Ken Muse (http://www.MomentsFromImpact.com)
public int GetObjectCount(ObjectQuery objectQuery) {
Commands commands = this.Mappings.Commands(objectQuery.ObjectType.ToString());
object val = this.Connection.GetScalarValue(commands.RecordCount(objectQuery.WhereClause));
return Convert.ToInt32(val);
}

I just changed what was the cast to int to use Convert.ToInt32(). It works now with both Oracle and MS SQL. The c# type for the return when using oracle is decimal so this converts that case to integer.

Thanks for great software,
DJ

Oracle Issues

Tue, 22 Mar 2005 19:15:11 GMT

There's probably some type of settings you can make to change the delimiters that Oracle uses, but I've personally never seen anything other than double-quotes used with Oracle. Anyhow, there is certainly nothing wrong with empty strings as long as your table and field names don't contain spaces or other characters that would require delimiters.

As for GetObjectCount, that quite probably does not work with Oracle -- it was such a simple method that I don't think I ever tested it with Oracle -- but Oracle return sets/values are very different than most any other database -- oops. You may need to use something simpler, like GetDataSet with a manual sql string.

Thanks, Paul Wilson

Oracle Issues

Mon, 21 Mar 2005 10:28:50 GMT

I'm having some trouble getting the ORMapper to work with my Oracle database server (9i). Everything seems to work fine when I'm communicating with my Microsoft SQL server however.

First, I can't seem to get my Oracle server to accept double quotes around table names. I've modified commands.cs so that the oracle provider uses empty strings as the delimiters and now I can select records using the mapper. Am I doing this correctly, or is there a way to specify that you want to use ANSI mode when connecting to Oracle.

Second, I get an invalid cast exception when using the GetObjectCount method of an ObjectSpace as it can't cast the result of the RecordCount query into an integer.

I would greatly appreciate any tips you could give me.

Thanks,
DJ

Reading and Checking TimeStamp values in SQL

Fri, 03 Dec 2004 07:05:04 GMT

MS SQL TimeStamps actually have nothing to do with dates or times -- they are simply binary values that are automatically updated on each persistence and guaranteed to be unique in order to make optimsitic concurrency easily doable. They currently appear to be implemented as an incremented number, but I don't think there's any docs on that or guarantees that it will remain that way.

If you want to get records that match a date, then you'll need to store and update that date yourself, possibly using a trigger to make it automatic.

Thanks, Paul Wilson

Reading and Checking TimeStamp values in SQL

Fri, 03 Dec 2004 06:17:17 GMT

I was searching for reading TimeStamp values (stored as binary) in SQL Database table and comparing it with current date (actually need to get recordset that matches a set of records based on date entered in the table). I came across a couple of examples on the internet but it did not work for me. Can you give me an example of the usage? I am using SQL Server 2000, .NET 1.0/1.1, VB.NET

SQL connectionString

Sun, 06 Jun 2004 05:09:15 GMT

You would need to post some code if you want some help.

Thanks, Paul Wilson

SQL connectionString

Fri, 04 Jun 2004 10:13:26 GMT

Hi All,

I'm getting the following error when trying to open a OLEDB connection to a FoxPro database through C#.

"The ConnectionString property has not been initialized"

The funny thing is, this doesn't happen if I hardcode the connection string at the time of creating the connection. But when I read it from a property of a class it throws this exception. I've checked and double checked a zillion times to verify that the correct connection string is set to the property.

Can someone help me trouleshoot this?

Thanks

Performance Issue.

Tue, 25 May 2004 04:16:02 GMT

Parameterized sql can be just as performant as stored procs, no doubt about that, although that assumes that things really do get reused. I don't think I would call this "huge" however, since most of these theoretical gains are pretty minimal, especially compared with good design.

But this really wasn't the subject of this post -- this post was about using stored procs without declaring all of the parameters explicitly. This technically requires a little more parsing from the SQL engine, but I think its so minimal to not really matter in most cases.

Thanks, Paul Wilson

Performance Issue.

Mon, 24 May 2004 20:42:09 GMT

I was under the impression that there's the possibilty of a huge performance gain using the parameterized SQL -- sql server realizes it's the "same" query and can re-use execution plans.

How do I model multiple user types in database?

Mon, 12 Apr 2004 09:28:03 GMT

Hi David:

See: http://www.wilsondotnet.com/Tips/ViewPosts.aspx?thread=352

Thanks, Paul Wilson

SQL connectionString

Wed, 07 Apr 2004 08:36:48 GMT

Try it and see. :) By the way, it continues to work, surprisingly.

Thanks, Paul Wilson

SQL connectionString

Tue, 06 Apr 2004 16:30:37 GMT

So what happens if the file referenced in the web.config appsettings tag doesn't exist?

How do I model multiple user types in database?

Thu, 01 Apr 2004 19:55:05 GMT

Hi there,

I was wondering if you could tell me the best way to implement the following scenario in a database.

I have two distinct "types" of users of my system - Employers and Workers. An Employer is an organization and and a Worker is a single person. The only thing they have in common is that they both will have a username and password (and thus a "user-id"). There is no way that an Employer can be a worker or vice-versa.

I am thinking of having a "Users" table that just contains the basic log-in credentials and the UserID. Then I will have a table for Employers (with a UserID foreign key) and a table for Workers (again, with a UserID foreign key).

So really it's a typical inheritance scheme. Now I am wondering if the Users table should have any knowledge of it being a Employer or Worker?

What do you think of this?

Thanks,
David