Is there a way to use Sql parameters in queries?

[Gillardo]

For example, i have 2 insert statements that i need to execute and the second one needs to use the SCOPE_IDENTITY() created from the first insert.

Can you do this using SqlBuilder?

Something like this

var firstBuilder = new SqlBuilder()
    .Append("DECLARE @Id    BIGINT")
    .INSERT_INTO("test (name)")
    .VALUES("my name")
    .SELECT("@Id = SCOPE_IDENTITY())
    .AppendLine()
    .INSERT_INTO("dependent (previousId, something)")
    .VALUES("@Id", "my value");

[maxtoroq]

I don't know, did you try it?

[Gillardo]

Tried it but a parameter is created with that value rather than using that
parameter
On 20 Aug 2015 4:58 pm, "Max Toro" notifications@github.com wrote:

I don't know, did you try it?

—
Reply to this email directly or view it on GitHub
#42 (comment)
.

[maxtoroq]

I don't follow, you are not using parameter values in your SqlBuilder, the resulting command should only contain text, what happens beyond that is out of the scope of this library.

[maxtoroq]

Now I see the problem, don't use the VALUES method, everything you pass will be treated as parameter values. Use Append or AppendClause.

[Gillardo]

Thanks. Working perfectly
On 20 Aug 2015 6:50 pm, "Max Toro" notifications@github.com wrote:

Now I see the problem, don't use the VALUES method, everything you pass
will be treated as parameter values. Use Append or AppendClause.

—
Reply to this email directly or view it on GitHub
#42 (comment)
.