Create a C# app to replace identifier columns in a MS SQL DB
$30-250 USD
Terminado
Publicado hace casi 14 años
$30-250 USD
Pagado a la entrega
I am a strong advocate of the idea of labor differentiation. So, I'm searching for an individual who can effectively help me with the tasks like this one, all related to MS-SQL-Server-specific functionality.
I would have much preferred to get an example of the candidate's C# source code related to the subject field and possibly some other highly focused information. There is the intention of future collaboration with the winner.
PROJECT DESCRIPTION:
I want to upgrade the structure of the DB used by my .NET application. Specifically, it's about changing a data-type of the key columns. It would be as simple as it sounds if the DB was empty, but it's not. Moreover, there are several databases of the similar type and I need to convert them all.
So I want someone to implement a .NET (C#) method processing a List of TableDefinitions where TableDefinition comprises of a TableName, a PrimaryKeyName and a List of its corresponding FKs. There are no multi-column PKs in the DB.
The columns of new data-type should be created and initialized with a given default value (UDF). Then the new FKs should be filled up with the new PK-values and after that, the old key columns should be replaced with the new ones. The database should remain the same after processing except the key columns.
I've attached a rough example of an input the method could get. Please take a look and let me know what you can do for me.
Thanks,
Paul
I am certificated .NET C# programmer, working with .NET since 2002 and am able to perform this task but in one case only: if your primary keys aren’t IDENTITY columns.
I am ready to do this. Please check my reviews/feedbacks as what my clients says about my knowledge, expertise and profience on .NET Platform.
You will not have to regret on giving your projects in safe hands.