/// <summary> /// Adds a new parameter with the specified name and value. The name will be /// parsed to extract table and keyspace information (if any). The parameter type /// will be guessed from the object value. /// </summary> /// <param name="name">The name.</param> /// <param name="value">The value.</param> /// <returns>The created <see cref="CqlParameter"/>.</returns> public CqlParameter Add(string name, object value) { var parameter = new CqlParameter(name, value); Add(parameter); return(parameter); }
public void TestCqlParameter() { var name = "p1"; var value = 1; var target = new CqlParameter(name, value); // test ParameterName var formattedName = ":p1"; var name2 = ":p2"; Assert.AreEqual(formattedName, target.ParameterName); target.ParameterName = name2; Assert.AreEqual(name2, target.ParameterName); // test IsNullable & SourceColumnNullMapping Assert.IsTrue(target.IsNullable); Assert.IsTrue(target.SourceColumnNullMapping); target.IsNullable = false; Assert.IsFalse(target.IsNullable); Assert.IsFalse(target.SourceColumnNullMapping); // test Direction, only Input is supported Assert.AreEqual(ParameterDirection.Input, target.Direction); Exception ex = null; try { target.Direction = ParameterDirection.Output; } catch (Exception e) { ex = e; } Assert.IsNotNull(ex); // test Value Assert.AreEqual(value, target.Value); var value2 = "2"; target.Value = value2; Assert.AreEqual(value2, target.Value); // test Size, it should always return 0 Assert.AreEqual(0, target.Size); target.Size = 1; Assert.AreEqual(0, target.Size); }
private void SetParameter(int index, CqlParameter value) { _parameters[index] = value; }
private void SetParameter(string parameterName, CqlParameter value) { int index = GetIndex(parameterName); _parameters[index] = value; }
/// <summary> /// Adds the specified parameter. /// </summary> /// <param name="parameter">The parameter.</param> /// <returns> </returns> public int Add(CqlParameter parameter) { _parameters.Add(parameter); return(_parameters.Count - 1); }
private void SetParameter(int index, CqlParameter value) { _parameters[index] = value; }
private void SetParameter(string parameterName, CqlParameter value) { int index = GetIndex(parameterName); _parameters[index] = value; }
/// <summary> /// Adds a new parameter with the specified name and value. The name will be /// parsed to extract table and keyspace information (if any). The parameter type /// will be guessed from the object value. /// </summary> /// <param name="name">The name.</param> /// <param name="value">The value.</param> /// <returns>The created <see cref="CqlParameter"/>.</returns> public CqlParameter Add(string name, object value) { var parameter = new CqlParameter(name, value); Add(parameter); return parameter; }
/// <summary> /// Adds the specified parameter. /// </summary> /// <param name="parameter">The parameter.</param> /// <returns> </returns> public int Add(CqlParameter parameter) { _parameters.Add(parameter); return _parameters.Count - 1; }
public void TestCqlParameterCollection() { var target = new CqlParameterCollection(); // test Count NUnit.Framework.Assert.AreEqual(0, target.Count); var p1 = target.Add("p1", 1); Assert.AreEqual(1, target.Count); // test SyncRoot Assert.IsNotNull(target.SyncRoot); Assert.AreEqual(target.SyncRoot, target.SyncRoot); // test IsFixedSize Assert.IsFalse(target.IsFixedSize); // test IsReadOnly Assert.IsFalse(target.IsReadOnly); // test IsSynchronized Assert.IsFalse(target.IsSynchronized); // test Add() var p2Index = target.Add(new CqlParameter("p2")); Assert.AreEqual(2, target.Count); Assert.AreEqual(1, p2Index); // test Contains() var p3 = new CqlParameter("p3"); Assert.IsTrue(target.Contains(p1)); Assert.IsFalse(target.Contains(p3)); // test IndexOf() Assert.AreEqual(0, target.IndexOf(p1)); // test Insert(); target.Insert(0, p3); Assert.AreEqual(0, target.IndexOf(p3)); Assert.AreEqual(1, target.IndexOf(p1)); // test Remove() var toBeRemove = new CqlParameter("toberemoved"); target.Add(toBeRemove); Assert.IsTrue(target.Contains(toBeRemove)); target.Remove(toBeRemove); Assert.IsFalse(target.Contains(toBeRemove)); // test RemoveAt() target.RemoveAt(0); Assert.AreEqual(2, target.Count); target.RemoveAt("p2"); Assert.IsFalse(target.Contains("p2")); // test CopyTo() var arr = new CqlParameter[1]; target.CopyTo(arr, 0); Assert.AreEqual(arr[0], target[0]); // test AddRange() var p4p5 = new[] { new CqlParameter("p4"), new CqlParameter("p5") }; target.AddRange(p4p5); Assert.AreEqual(3, target.Count); Assert.IsTrue(target.Contains(p4p5[0])); Assert.IsTrue(target.Contains(p4p5[1])); // test Clear() target.Clear(); Assert.AreEqual(0, target.Count); }