Avatar of Mashael albarak
Mashael albarak
 asked on

locate sql commands in C# visual studio Project

Hello ,

I have not worked with VS before (Ever) and I really need your help. I have a website project that is opened in VS2015, my question is: If I want to change any database table and Split that table to normalize it to higher normal form, how do I locate the lines of code that needed to be changed and the SQL commands that retrieve, insert or update data in this specific table in order to change them .
For Example : If I split table Customer to two tables in the database Female-Customer and Male-Customer, how do I know or locate the lines of code and the sql commands related to table Customer that needed to be changed ??

Best Regards,
Microsoft Visual StudioC#ASP.NET.NET ProgrammingWeb Development

Avatar of undefined
Last Comment
Mashael albarak

8/22/2022 - Mon
ASKER CERTIFIED SOLUTION
AndyAinscow

THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
See Pricing Options
Start Free Trial
GET A PERSONALIZED SOLUTION
Ask your own question & get feedback from real experts
Find out why thousands trust the EE community with their toughest problems.
Mashael albarak

ASKER
Where exactly should i search in which file ??
Where should i press the Ctrl F
AndyAinscow

When you have the solution opened in VS just press the ctrl key and F simultaneously.  Then search the entire solution.  You will see all instances of what you want to search for filtered by the options you select.
Mashael albarak

ASKER
I forgot to mention that my project is a website , so your solution will locate all the lines of code in classes and methods and procedures that has the Customer table name that I need to change  ??
I started with Experts Exchange in 2004 and it's been a mainstay of my professional computing life since. It helped me launch a career as a programmer / Oracle data analyst
William Peck
AndyAinscow

It will search all files within the solution.
You can modify it for example to search all files within a folder (with subfolders) or a selection of folders....  The search function is very powerful and allows a number of filters.  Just be very careful about a find/replace and performing the replace without user confirmation - that can lead to a big mess if you made a mistake in your criteria.
Mashael albarak

ASKER
thank you very much I will try this