C# (CSharp) Remotion.Linq.SqlBackend.SqlGeneration CommandParameter Examples

Example #1

File: SqlCommandBuilderTest.cs Project: re-motion/Relinq-SqlBackend

    public void GetCommandParameters ()
    {
      _sqlCommandBuilder.CreateParameter ("value");

      var expectedCommandParameter = new CommandParameter ("@1", "value");
      Assert.That (_sqlCommandBuilder.GetCommandParameters (), Is.EqualTo (new[] { expectedCommandParameter }));
    }

Example #2

File: SqlCommandBuilderTest.cs Project: re-motion/Relinq-SqlBackend

    public void GetCommand ()
    {
      _sqlCommandBuilder.Append ("Test");
      _sqlCommandBuilder.CreateParameter ("value");

      var body = Expression.Constant (0);
      _sqlCommandBuilder.SetInMemoryProjectionBody (body);

      var data = _sqlCommandBuilder.GetCommand();

      Assert.That (data.CommandText, Is.EqualTo ("Test"));

      var expectedCommandParameter = new CommandParameter ("@1", "value");
      Assert.That (_sqlCommandBuilder.GetCommandParameters (), Is.EqualTo (new[] { expectedCommandParameter }));

      var expectedInMemoryProjection = Expression.Lambda<Func<IDatabaseResultRow, int>> (body, _sqlCommandBuilder.InMemoryProjectionRowParameter);
      SqlExpressionTreeComparer.CheckAreEqualTrees (expectedInMemoryProjection, data.GetInMemoryProjection<int> ());
    }