Question

How to concatenate a string in the middle of other string with C#

Answer 1

using System;

namespace ConsoleApplication_C_Sharp
{
    static class Program
    {
        static void Main()
        {
            string table_prefix = "tp_";
            string sql = "SELECT * FROM " + table_prefix + "table_name";

            Console.WriteLine(sql);
        }
    }
}


/*
run:
  
SELECT * FROM tp_table_name
   
*/

 

70+ SQL courses for beginners and professionals