Our customers often want applications that create reports from database queries. This may be invoices with customer data, lists and so on. So I decided that the database framework should have a brother named DotNetOdf. This library was inspired by an older open source project I launched several years ago. You can insert data (for example a customers name and address) into your reports with just a few lines of code, and your customer can maintain the reports himself. During the next time I want to add a function to insert lists (the positions of an invoice for example).
The latest version of the NotReallyORM framework supports this library, for the LazyListRow class now can export its data into a dictionary. The DotNetOdf User Documentation will explain this to you more detailed.
After my holidays I started to write a User Documentation for the framework. You can try the examples in it without downloading the whole project, just get the DLL (it’s zipped for security reasons). The documentation is not finished at all, but you get a first overview of the concept and a step-by-step example for simple CRUD operations.
I also decided to downgrade the whole project to .NET Version 3.5. Especially in business environments you still have a lot of older Windows XP installations, sometimes locally, sometimes as remote desktop. With XP SP2 there should be now no problem to use the NotReallyORM framework.
During the last week I had to do with compound primary keys at work. Sometimes I find them more appropriate than my beloved auto-increment integer keys.
Reason enough to test the NotReallyORM framework with them. The framework was already equipped to use compound keys. After the tests I added some fixes. It now works fine with those keys, as far as I can see. In one of the next versions I plan to retrieve those keys automatically from the database. I found a nice SQL expression for SQL Server for this purpose (explanations only in German, sorry).
Download the latest version NotReallyORM_0.52 and try it out.
I made some tests to store data from a form to the database more effectively. The CRUD functions and the transactions seem to work fine now. I am still looking for a more effective way to store data from a form to the database, without too much boilerplate code. And it should work with WinForms. Standard data binding with WinForms (bind a control to a data source) has not convinced me yet. I know WPF has better features for data binding, but I want to be independent from WPF (more on this topic another time).
Download NotReallyORM_0.51, try it out, read the comments in source code. And, yes, you can use the framework for ASP.NET, too (it should be thread safe).