EasyObjects.NET 1.1 Released!

by Matthew Noonan 12. March 2006 22:11

New features and bug fixes:

  • Complete functionality without generating stored procedures. You no longer have to generate stored procedures for your business objects (although this is still supported). You now have the option. This paves the way for adding support for database platforms that do not support stored procedures (Access, VistaDB, MySql, SqlLite, etc.).
  • Support for Aggregate functions in custom queries, courtesy of David Neal Parsons.
  • Ability to load an EasyObject from a DataTable or a DataSet (specifying the index of the DataTable). This allows for developers to return multiple resultsets from a stored procedure and then load the objecct from the DataSet.
  • Updated the QuickStart to prompt for dynamic connection information, including the server name and user credentials.
  • Fixed a bug where the internal datatable was not removed from the dataset when an exception occurred (reported by daveyjclark).
  • A small set of NUnit tests are now included.
  • Some minor enhancements.

Download it today!
http://www.easyobjects.net/Downloads/tabid/125/Default.aspx

Tags:

EasyObjects

Submit to DotNetKicks...
Permalink | Comments (14)

Comments

3/13/2006 2:00:00 AM #

When should we expect EasyObjects.NET 2.0 released?
1.1 looks great but we are moving to .NET framework 2.0. So really keen to see your new release.

johnmao United States

3/13/2006 2:00:00 AM #

I have a very early alpha version that works with stored procedures only (no dynamic queries), but it is hand-coded and the scripts have not been updated. In other words, it's not very functional yet.

I'm in the process of trying to get the DynamicQuery class working, but the biggest change for .NET 2.0 was to the configuration stuff, and that's where the DQ class lives. So it's slow going. Originally, I had planned to release it by the end of this month, but that seems unrealistic at this point.

All I can say is stay tuned here. I'm as anxious as you all are to get a working 2.0 version out there, but there are only so many hours in the day and unfortunately no one on my team can dedicate 8 hours a day to this (I wish I could, but I have to sleep and pay the bills).

Hang in there, it's coming!

mgnoonan United States

3/13/2006 2:00:00 AM #

Thanks a lot, Matthew!

The Download page still shows the RC1 values:
EasyObjects.NET 1.1  Source  Mar 09 2006  1,820

I guess you may want to update this.

trbcc United States

3/13/2006 2:00:00 AM #

Is this version (1.1) ready for .NET 2.0. and enterprise library 2.0 or is only intended to use with 1.1 version of the framework.

Great job!
Thanks

henrique.cerqueira United States

3/13/2006 2:00:00 AM #

John,

That's an easy one. Smile

See the 2nd item in our FAQ:
www.easyobjects.net/FAQ/tabid/120/Default.aspx" rel="nofollow">www.easyobjects.net/FAQ/tabid/120/Default.aspx">www.easyobjects.net/FAQ/tabid/120/Default.aspx" rel="nofollow">www.easyobjects.net/FAQ/tabid/120/Default.aspx

mgnoonan United States

3/13/2006 2:00:00 AM #

Thank you Matthew for updating.
I am trying to generate code in 1.1 and eventually I got this compliation error:

The best overloaded method match for 'NCI.EasyObjects.SchemaItem.SchemaItem(string, System.Data.DbType, bool, bool, bool, bool, bool, bool)' has some invalid arguments

The reason is generated code use SqlDbType, which is not derived class of DbType. How should I deal with this situation?

Look forward to your answering. Thank you in advance.

johnmao United States

3/13/2006 2:00:00 AM #

This version is still based on the June 2005 release of the Enterprise Library, so it's still 1.1 based. The next version 2.0 will be based on the January 2006 release of the EL and will fully support .NET 2.0.

I have corrected the timestamp and file size on the downloads page. Thanks for the report!

mgnoonan United States

3/14/2006 2:00:00 AM #

Matthew, good job. The FAQ works.

johnmao United States

3/14/2006 2:00:00 AM #

Default values.

Hi, thanx for an superb object!

Did you come up with a solution for the Default value, problem for database values?

Has this been taken care of in this release?

Rgs
Vidar

VidarM United States

3/14/2006 2:00:00 AM #

John, Glad you got it working!

Vidar, there was no solution with defaults that I could generically apply between SQL Server and Oracle. The template code was getting seriously messy and it never even approached something I was happy with. If you send me an email, I can probably work with you towards a custom solution. Thanks.

Matt

mgnoonan United States

3/15/2006 2:00:00 AM #

John,

Create a view OrderDetailView that joins the tables you need and brings in the extra columns you want, then use the Business View template to create an EasyObject based on the view. If you need to save data, you can load (for example) the Orders object from the view by setting the QuerySource. The only rule is that the view must contain all the fields in the Orders table, because the Save is expecting them to be there.

Email me if you have any questions.

Matt

mgnoonan United States

3/15/2006 2:00:00 AM #

Matthew,

I read through Tutorial of Building Queries. I think you didn't cover one scenario. Which is join query of two entities. For example, when I search orders, I want to display the customer name instead of customer ID, then I need join two tables. (Maybe outer join in some cases.)

What is your recommendation on constructing this type of code by using EasyObjects?

Let me know.

Thank you!

johnmao United States

3/16/2006 2:00:00 AM #

Thanx Matt for good follow-up.

I tried to run the 1.1 release on an existing project. I do an easy
xxx.AddNew()
xxx....
xxx.Save();
But I get an error triggered on xxx.Save() saying:
System.ArgumentException: At least one command must be initialized

Does this mean I must generate my code again?

Rgs
Vidar

VidarM United States

3/16/2006 2:00:00 AM #

Got it!

Sorry about the last post...

Found it by searching the forum.

Rgs
Vidar

VidarM United States

Comments are closed