I need a console application based on c#, which generates sql select statements. The information about which tables are in the database is stored in a table as well as which columns and foreign key relationships exists in the tables. This tables' structure will be provided.
The following functions are needed:
1. Based on the given tablename the function should return all possible columns for this tables, along with the ones, which can be reached via a foreign key
2. Given a list of the columns (some might be via foreign key relationship) generate an sql select statement with the left joins based on the foreign keys.
29 freelancere byder i gennemsnit €40 timen for dette job
Hello, As an experienced C# developer and expert in SQL, I am very much interested to develop the required console program. I need a bit more clarifications, let's discuss. Thanks
I am Microsoft certified C# and SQL developer, I will be happy to provide you my certifications before accepting the bid. Awaiting for your message!
Hi, I am experienced with .NET and T-SQL I have done many projects that are relatively familiar with your one. I would love to discuss about this task with you. Thanks in advance.