dirty-data

Is there a clean way of cleaning up duplicate entries in MySQL?

In a table, I have three columns - id, name, and count. A good number of name columns are identical (due to the lack of a UNIQUE early on) and I want to fix this. However, the id column is used by other (4 or 5, I think - I would have to check the docs) tables to look up the name and just removing them would break things. So is there a g...

How can I add an "IsDirty" property to a Linq to Sql entity?

Okay, similar questions exist, but they are all about how to determine this from outside of the entity itself and use the DataContext the entity is attached to. I am binding my entities to an edit form in WPF. Within a DataTemplate, I want to be able to set the background color of the root container within a DataTemplate to show it has...

How to prevent dirty write for web forums?

Hi all, As a apprentice for web development, I have no clue of preventing dirty write for web forums. Is there any food for thought? Thanks in advance! I'm working on ASP.NET MVC and Entity Framework. Okay, sorry for misleading. The dirty write here means overwrite changes of another person in the database. While using a Optimistic Co...

What is meant by the term "dirty object"?

I see the term "dirty" or "dirty objects" a lot in programming. What does this mean? ...

ObjectContext.Refresh() ???

How to update ALL the dirty entities from the data store, and reset their changed values to the original store value? The method ObjectContext.Refresh requires as a parameter the entities to be refreshed. ...

Does ODBC access to external tables potentially result in corruption of data or locks?

I need to get data out of SQL Server2005 tables, and into another system. My vendors says: "We don´t recommend that you go directly in the SQL and collect data, because it can result in corruption of data or you can lock tables while exporting." Is that true? ...