10,385 reputation
1728
bio website
location
age
visits member for 1 year, 9 months
seen May 6 at 22:09
stats profile views 575

May
4
comment Complex Mutual Exclusion Validation Logic
The logic you describe is not complex. Please specify the technology you are using so that you could get a precise answer. As a rule always validate on the server, if you are using classes, you could add the validation as a method in the class this would be one way of making the logic shared. You could (and in most cases should) validate on the server, most probably using JavaScript (which won't work if your user shuts down JavaScript).
May
3
comment Representing a parent/child hierarchy in a Relational Database
+1 for correctly suggesting use of FK since the target is RDBMS. It is important to note that in this case, the Account ID (or ID) is the table PK. Before implementing this design one must determine the expected operations on the data. Say what happens if the user decided to remove "Seattle Mission"? While this structure is valid, I don't consider it trivial to list sub accounts of a given ID. Another issue here is that an entry like "Homeless Shelter" may appear as a sub-account of other accounts (say an account with ID 199). So, normalization should be considered.
May
3
comment Custom Alphabetic Sorting of Array in Java
A simple solution could be provided by using a dictionary to store tag names in the desired order. If you are interested, I could provide a C# implementation.
May
2
comment Matching two lists of data with different conventions
You must first define your "match" criteria accurately. I second @Doc Brown in his recommendations.
Mar
10
awarded  Enlightened
Mar
10
awarded  Nice Answer
Mar
6
comment When not to use ORM and prefer stored procedures?
@WyattBarnett, thanks for your comment. Personally, dynamic SQL generation still scares me in large applications for many reasons.
Jan
30
awarded  Nice Answer
Dec
11
comment Why do Core Data sqlite table columns start with 'Z'?
I really have no idea about the reason in this specific case, but it is not uncommon for database tables serving a common purpose to be prefixed with a special prefix for easy reference and to avoid collision of other tables (e.g. user and zUser).
Dec
9
comment Help parsing long (3.5mil lines) text file, line by line and storing data, need a strategy
What database are you using?
Dec
8
comment Design backward and forward button operations of a browser
There are several posts covering this. First, the theory is covered here: stackoverflow.com/questions/1313788/… and implementation suggestions are here:stackoverflow.com/questions/6815797/…
Dec
5
comment SQL RDBMS : one query or multiple calls
You can pass an object around however, in case of a DTO, the DTO does not have to be the same as the Entity. For example, say you are listing customers with their net balance (say you are AMEX!). In this example, you may have 1 customer entity but different other domain entities that you run SQL against to get the balance. The DTO in this case could be the customer and the net balance. This DTO (or a list of) does not resemble a single domain Entity. The DTO does not have to save data in database. I hope this is a bit more clear.
Dec
5
comment SQL RDBMS : one query or multiple calls
I think you did not get the picture. Entities are not always DTOs (in general, they are not). DTO does not have any behavior except for its serialization/de-serialization. Its like a truck that moves data between layers or tiers. This is a key concept I suggest you look at in some detail. Also, for professional applications, it is really hard to come up with a convincing argument against all ORMs.
Dec
5
revised SQL RDBMS : one query or multiple calls
added 2 characters in body
Dec
5
answered SQL RDBMS : one query or multiple calls
Dec
4
comment Should I implement BackBone.js into my ASP.NET WebForms applications?
I see, thanks for the clarification.
Dec
4
comment NoSQL as file meta database
CAP theorem says you can't have Consistency, Availability and Partitioning Tolerance all at the same time.
Dec
4
comment Are there any algorithms for resource scheduling of courses-teachers-classes?
You can program an algorithm to produce some results. However, the challenge is to consider whether there is 1 or more solutions and the criteria to use to select the best solution. The other aspect you need to consider is that you may have certain constraints. For example, a senior teacher may work less hours than a junior one and/or consider the fact that a teacher has certain hours of class room work per day per educational level, and so on. This is not a simple problem. What you may be looking for is "A constraint-driven human resource scheduling method", using variety of "OR" algorithms.
Dec
4
comment Should I implement BackBone.js into my ASP.NET WebForms applications?
Since you already have an application in production, I don't think that it is wise to change the current architecture specially if the application is not trivial. I would suggest that for future implementations, you either utilize VS20xx controls, third party controls and/or HTML5+JavaScript but stay away from manipulating DOM directly in a business application if you could. Also, this may be of value to your case: kendoui.com/blogs/teamblog/posts/12-06-05/…
Dec
3
comment Should I implement BackBone.js into my ASP.NET WebForms applications?
I am curious about your approach. Why bother using ASP.NET as a client technology anyway if you are not using any ASP.NET controls?