Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: noodle22
  • Content: Threads
  • Order by date
  1. noodle22

    Do I have to denormalize?

    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 ...
  2. noodle22

    Way to check if row is updated in a trigger?

    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...
  3. noodle22

    Have a change log for tables but need to know about performance hits

    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...
  4. noodle22

    Namespace organization and naming conventions

    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...
  5. noodle22

    Should data objects and database accessors exist in the same class?

    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...
  6. noodle22

    help with some ASP.NET MVC best practices

    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...
  7. noodle22

    MVC - Am I on the right track

    I am trying to set up an MVC based web site but I have very little experience with this pattern and am not sure that I fully understand it. I'm pretty sure that I am not doing this right so am I on the right track here? My Model - A bunch of data objects populated directly from the database...

Part and Inventory Search

Back
Top