Search results for query: *

Hi, I have the typical problem of needing to store historical data from a normalized database the problem is I have would be dimensions referencing other dimensions. The worst case is Table:Deficiency sk: surrogateKey for different versions of the same record pk: ID fk: BuildingSKID ...

bborissov, that is a much nicer way of writing the idea of comparing all columns... but it still means we have to compare all columns...might be what I have to do though pwise, thanks for the ideas for UPDATE and UPDATED(), but I believe both of those operate on either the table as a whole or...

That is what I am doing...but the issue is that inserted contains records even if no data has changed. MyTable pk Name 1 'sameasbefore' Now in sql server query window UPDATE myTable SET [Name]='sameasbefore' WHERE pk=1 Now in my trigger if I check the inserted table I find that it...

Hi, I am using an Instead Of trigger for a table and I need a way to determine if a row has been updated. The problem is, if I do something like UPDATE myTable SET [Name]='sameasbefore' Then in the trigger, inserted and deleted both contain records for all the rows in my table even if the...

Ok, so I came up with a way to do it without using dynamic sql but then I started thinking about the use of this implementation. What I am really going to want is to not just compare changes, but compare one version of the row with a previous version (and possible set the previous as the new...

After thinking about this some more, I can do method (b) by not using dynamic SQL and by not having to copy inserted/deleted into temp tables. I would just make a special case of the trigger for each table I am auditing (just hard code the columns rather then get them from the information...

Hi, I've created a change log for when data in a table changes (I'm actually using it for a wiki type app). I have two ways of doing this a) copy all the new data and all the old data into the change log table b) copy only the changes The advantage of (a) is that it doesn't compare anything...

I found Head First Design Patterns to be a really good book as well. It uses these examples that are really basic and has tons of stupid tricks/jokes to make the book fun to read and help you remember when to use stuff. There is also a Head First OO Design book which I would not recommend...

awesome. ok, that makes sense to me. I think I have to work on my naming conventions a bit next time I refactor :)

ok, I think that answers my question. And then your public IEnumerable<ProductDto> SearchStoreForProducts(...) would be contained in some other class somewhere (but not within store). Thanks for the detailed response (again:) Also, DonQuichote, I totally missed your post when I last checked...

sorry that I am not fully getting this but I think I am having trouble asking my question. I can't phrase it right. In the case above, would you have your function that handles the criteria within a method in store? ie Store.Search(searchstring) and then Search would contain the criteria...

I'm using nhibernate as my OR mapper and I used MyGeneration to come up with my initial mappings. It created collections in my objects for the different relationships and I must say, I find them pretty useful. NHibernate handles all the lazy loading for me so I don't have to worry about it too...

What are typical project/namespace organization for a DB project (including accepted names...maybe people don't name things accessors)? I have been doing something like *[project].Core.Entities - contains entity objects. Should this be called Domain or DomainObjects...

Consider this example. Suppose that I have a Store object and a Product object. The properties in each class are Store -String Name -String Location -IList<Product> Products Product -Name -ProductNumber Now I am using some OR mapper to populate these objects. My current method of relating...

Ok, just in case anyone else has been wondering about 2 (controllers) as well for ASP.NET MVC, this article talks about REST design for ASP.NET MVC webapps http://blog.wekeroad.com/2007/12/06/aspnet-mvc-using-restful-architecture/ Basically, it helped me better divide up my controllers so that...

I will check that suggestion out futher. I'm not sure if it would work in my case or not but I may not have much of a choice if I am moving away from the query string. The book part is amusing because I just read Head Frist Design Patterns last fall (although I haven't read Domain Driven...

wow, you always have such useful things to say and response so fast. I am impressed! In regards to point 1, how does routing handle issues where a variable I need may not be present?...ie, MyAction?VarB=5 (4 was not passed in this case)

And here is another one. Sometimes, I pass a variable, ReturnToActionUrl, to my actions (when doing an insert for example). The first action will take place, and then RedirectToAction(ReturnToActionUrl) will be called to go to the action that gets the data ready to display (Index for...

I have two questions about MS MVC for asp.net 1) When linking or submitting a form to a controller, are query strings like MyAction?VarA=4&VarB=5... ok or should I switch to something like MyAction/4/5/. Does it really matter? I prefer to avoid creating all these special routes when I can...

ok, just to follow up here. I have been using MS MVC for about almost a month now. It was pretty easy to transfer what I had done before into the new format. I feel like my code is much better organized now and far simplier to maintain. I am curious how MS MVC compares to MS web client...