...What is it called? More elaborate: For my application I created a nice business model to work with as in-memory objects. It's storage and view agnostic. Now, for the storage layer, there's a database: I'll construct SQL queries (the fewer the better) that selects/joins etc. all data I need from the relevant tables. A kind of "middle ...
Hello, I have this relation: Customer - Order - Product each mapped to its own sql table. When I want to eager load now the Customers with its Orders and the Orders with its Products How do I have to iterate the 3 sqldatareader to get in the end a IEnumerable just as I would use an ORM. What I do not want to do is to pass the Sql...
I have four different Business objects and each calls its corresponding FillBusinessObject method to fill all the individual object properties one by one. Now I wish to create a common method which should be able to fill each type of business object. I've created a base class from which all business objects inherit but I am not able to f...
This probably isn't as complicated as it should be, but Business Objects seems to be very, very strict in how types are used versus SQL Developer. Here's the piece of the statement in question: ship_date between '01' || '-' || w_current_ora_month || '-' || to_char(to_date(w_last_day, 'DD-MON-RR HH:MI:SS AM'), 'yy') and to_char(to_date(w...
Need to implement custom business/authorization rules for the product that is based on the well-known CSLA framework. Examples: The logged-in principal or admin can update her details, not anyone else. The last user in the system can't be deleted. Currently I know that rules can be applied during setup phase: BusinessRules.AddRule...
I have the necessity for a client application to "lock" (aka "check-out" certain business entities store in the database. The workflow is such that: The user navigates to a page for some business object. The user hits "edit". This locks the item from being edited by anyone else. Other users on other workstations will see a little "loc...
Hello fellows, Good day. I am in a situation where I have to perform a transaction master detail record (Drop prev details, insert new details, Update Master status) Master Business Object has 20 fields Details Business Object has 4 fields only Now I have to update only 1 field in master table and 4 fields in details table for i...
Hi , I am writting a website using .net in some of my pages I need to use datagrid for showing some datas and for binding my data to datagrid I use object datasource something like below : //this is public class userData { private long userid = 0; private string username = null; private long amounts = 0; private DateTi...
I am a big fan of NTiers for my development choices, of course it doesnt fit every scenario. I am currently working on a new project and I am trying to have a play with the way I normally work, and trying to see if I can clean it up. As I have been a very bad boy and have been putting too much code in the presentation layer. My normal ...
A simple linq to SQL query Might return a product object. Obiously I could pass this object to my business layer, then read and update the data, directly against that object. I've seen a bunch of implementations where following the execution of the linq query the resulting object is mapped (via automapper or manually) to a custom busin...
I can add a stored procedure to a dataset and handle the data manipulation. Wanted to know if there are any other ways through which on the basis of stored procedure result sets, I can handle data in the BAL, like dynamically generating business objects or something else? ...
Hello fellows, Good day. I am having a Form where Table SelectedItems Table AvailableItems RecordID CheckBoxID CheckBoxID Description 1 1 1 'Tomatoes' 1 2 2 'Potatoes' 1 4 ...
Hello fellows, I have checkbox list bind to a Business Object Collection of List<>. When an item is checked in my checkbox list, I want to mark the selected business object as dirty. How can I fetch the current business object on row click and change its property? Also, how would this shape in a multi-user environment? ...
Hello fellows, I am trying hard to update a business object inside a List<>. I am using a checkbox list When a checkbox list item is clicked I check if it exists, if yes I mark it as Dirty (means the user unchecks an item) If not, I add a new item to the list (means the user clicks a new item) and store it in view state How do I up...
I have got myself saddled with an existing application - which attempts do do a lot of things by itself and does most of it badly! This application is an ASP.net 3.5 Web application having the typical UI -> Business --> DAL kind of pattern. The problem i am faced with is the fact that when multiple users are requesting the same informa...
Can/Should my POCO's encompass multiple Databases if applicable? The reason I ask is that I am in the process of refactoring a legacy Enterprise App that was built in stages. Unfortunately, each stage had it's own separate DB (at least they are all on the same SQL instance). Because of this I can easily see where a typical Business ...
Hi, What would be the best data format (XML, Database, etc.) for large business data when we want to efficiently and easily load all of it (import) into business objects in .NET ? I want to load all the data in one go and create all business objects. The data must have a kind of a "schema" to enable other people to create it. Also n...
Hello, Quick question, is it possible to bind a combobox to a list of objects, but have the selectedvalue property point to the object, not a property of the object. I only ask because we have some Business Objects which have references to other objects - such as a 'Year' object. That year object may need to be switched out for another...
There is a class named "Foo" which normally contains more than 100 fields. It's a domain object and I have to customize it for each client because the fields' specification are almost totally different from one client to another (no more than 10 fields are same). Some clients have more than 200 fields. Currently, I have to update the c...
The SQL that Business Objects generates seems to be stuck in a bygone era for SQL joins -- it insists on using the old Sybase outer-join syntax (*=, etc.), which is illegal in SQL Server 2005 when running at level 90. Is there an option somewhere to make it use modern join syntax (i.e., joining using the JOIN keyword rather than using co...