Exemplos de InsertQuery.Replace em C# (CSharp)

Exemplo n.º 1

        private static async Task CreateInsertTeamsSql()
        {
            const string InsertQuery = @"

INSERT INTO livematches.Teams(Code, Name)
VALUES ({{Code}}, {{Name}});

";

            var path     = "Teams/teams.txt";
            var contents = await File.ReadAllLinesAsync(path);

            var teamCodeLine = 21;
            var teamCodes    = contents[teamCodeLine].Split('\t');

            var builder = new StringBuilder();

            for (var i = 0; i < 20; i++)
            {
                var insert = InsertQuery.Replace("{{Code}}", $"'{teamCodes[i]}'").Replace("{{Name}}", $"'{contents[i]}'");
                builder.AppendLine(insert);
            }

            var sql = builder.ToString();
        }

Exemplo n.º 2

        private static async Task CreateInsertSeasonTeamsSql()
        {
            const string InsertQuery = @"

INSERT INTO livematches.SeasonTeams(SeasonId, TeamId)
VALUES (1, {{TeamId}});

";
            var          builder     = new StringBuilder();

            for (var i = 1; i <= 20; i++)
            {
                var insert = InsertQuery.Replace("{{TeamId}}", $"{i}");
                builder.AppendLine(insert);
            }

            var sql = builder.ToString();
        }