Cannot manipulate SqlBuilder??

[Gillardo]

Sorry if i am using the code wrong, but i would like to generate a Sql query for inserting data. I have a loop that i use to find the fields that i need to insert into and also the field values, something like this

var builder = SQL
    .INSERT_INTO("myTable");

var entity = new Dictionary<string, string>() {
    { "Name", "Bob" },
    { "Town", "MyTown" },
    { "County", "myCounty" }
};
var fields = new List<string>() { "Name", "Town", "County" };

foreach (var field in fields) {
    builder
        .SetCurrentClause("INSERT INTO", ",")
        .AppendToCurrentClause(field)
        .SetCurrentClause("VALUES", ",")
        .AppendToCurrentClause("{0}", entity[field]);
}

But once i have done this and try to execute the command, my SQL looks something like this

exec sp_executesql N'INSERT INTO myTable(Name
VALUES (@p0),Town,@p1,County,@p2,N'@p0 nvarchar(7),@p1 nvarchar(4000),@p2 nvarchar(7)',@p0=N'Bob'

Do you know why my SQL is not correctly formatted?

[Gillardo]

Do not worry, i have been told that ordering matters in SqlBuilder.