×
The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.
Hi Walden,
We also support a GetByExample setup so we can do simple queries:
Customer example = new Customer();
example.State = "NY";
List<Customer> NYCustomers = Customer.GetByExample(example);
That's an interesting idea, but am I correct to assume that this handles
only simply queries, where all of the conditions are either AND'd or OR'd as
a single expression?
The problem I've always found with a DAL is that although it provides great
utility in a simple CRUD scenario, it starts to break down very quickly in
inquiry and reporting scenarios. You end up either creating dozens of
specialized getDataInSomeFormat() methods or creating your own query
language.
LINQ (2 SQL) is the best idea I've seen yet to address a lot of the friction
associated with developing database applications in an OO environment.
Unfortunately, there is no provider for DB2/400, and history suggests that
it will be a long time before we see one.
That brings be to a new question that should probably be its own thread, but
since there only appears to be about 6 people on this list, I doubt it will
a problem. The question is, does anyone else find themselves starting to use
a different database (ie: SQL Server) for new projects due to the lack of MS
tooling support by the DB2/400 group? I'm picking on them specifically
because DB2/LUW is *very* responsive to the MS tools market. It's DB2/400
that is slow to deliver, and usually provides only the bare minimum
functionality.
midrange.com
