C# (CSharp) Utilities.SQL.ParameterTypes AndParameter Examples

Example #1

File: AndParameter.cs Project: rgshare/Craig-s-Utility-Library

 public void Creation()
 {
     Utilities.SQL.ParameterTypes.AndParameter TestObject = new Utilities.SQL.ParameterTypes.AndParameter(new EqualParameter<int>(1, "Left"), new EqualParameter<int>(2, "Right"));
     Assert.Equal("(Left=@Left AND Right=@Right)", TestObject.ToString());
     using (Utilities.SQL.SQLHelper Helper = new Utilities.SQL.SQLHelper("", CommandType.Text, "Data Source=localhost;Integrated Security=SSPI;Pooling=false"))
     {
         Helper.AddParameter(TestObject);
     }
 }

Example #2

File: AndParameter.cs Project: xiaopohou/Craig-s-Utility-Library

 public void Creation()
 {
     Utilities.SQL.ParameterTypes.AndParameter TestObject = new Utilities.SQL.ParameterTypes.AndParameter(new EqualParameter <int>(1, "Left"), new EqualParameter <int>(2, "Right"));
     Assert.Equal("(Left=@Left AND Right=@Right)", TestObject.ToString());
     using (Utilities.SQL.SQLHelper Helper = new Utilities.SQL.SQLHelper("", CommandType.Text, "Data Source=localhost;Integrated Security=SSPI;Pooling=false"))
     {
         Assert.DoesNotThrow(() => Helper.AddParameter(TestObject));
     }
 }