C# (CSharp) Utilities.SQL.MicroORM Command Beispiele

Beispiel #1

Datei: Command.cs Projekt: yuanlianxi/Craig-s-Utility-Library

 public void Creation()
 {
     Utilities.SQL.MicroORM.Command Object = new Utilities.SQL.MicroORM.Command("SELECT * FROM Table", CommandType.Text, "@", 0, 1, 2, 3);
     Assert.Equal("SELECT * FROM Table", Object.SQLCommand);
     Assert.Equal(CommandType.Text, Object.CommandType);
     Assert.Equal(4, Object.Parameters.Count);
     Assert.Contains(new Parameter <object>("0", (object)0), Object.Parameters);
     Assert.Contains(new Parameter <object>("1", 1), Object.Parameters);
     Assert.Contains(new Parameter <object>("2", 2), Object.Parameters);
     Assert.Contains(new Parameter <object>("3", 3), Object.Parameters);
 }

Beispiel #2

Datei: Command.cs Projekt: rgshare/Craig-s-Utility-Library

 public void Creation()
 {
     Utilities.SQL.MicroORM.Command Object = new Utilities.SQL.MicroORM.Command("SELECT * FROM Table", CommandType.Text, "@", 0, 1, 2, 3);
     Assert.Equal("SELECT * FROM Table", Object.SQLCommand);
     Assert.Equal(CommandType.Text, Object.CommandType);
     Assert.Equal(4, Object.Parameters.Count);
     Assert.Contains(new Parameter<object>("0", (object)0), Object.Parameters);
     Assert.Contains(new Parameter<object>("1", 1), Object.Parameters);
     Assert.Contains(new Parameter<object>("2", 2), Object.Parameters);
     Assert.Contains(new Parameter<object>("3", 3), Object.Parameters);
 }

Beispiel #3

Datei: Command.cs Projekt: yuanlianxi/Craig-s-Utility-Library

 public void Equality()
 {
     Utilities.SQL.MicroORM.Command Object1 = new Utilities.SQL.MicroORM.Command("SELECT * FROM Table", CommandType.Text, "@", 0, 1, 2, 3);
     Utilities.SQL.MicroORM.Command Object2 = new Utilities.SQL.MicroORM.Command("SELECT * FROM Table", CommandType.Text, "@", 0, 1, 2, 3);
     Utilities.SQL.MicroORM.Command Object3 = new Utilities.SQL.MicroORM.Command("SELECT * FROM Table", CommandType.Text, "@", 0, 1, 2);
     Utilities.SQL.MicroORM.Command Object4 = new Utilities.SQL.MicroORM.Command("SELECT * FROM Table", CommandType.Text, "@", 0, 1);
     Utilities.SQL.MicroORM.Command Object5 = new Utilities.SQL.MicroORM.Command("SELECT * FROM Table", CommandType.Text, "@", 0);
     Utilities.SQL.MicroORM.Command Object6 = new Utilities.SQL.MicroORM.Command("SELECT * FROM Table", CommandType.Text);
     Utilities.SQL.MicroORM.Command Object7 = new Utilities.SQL.MicroORM.Command("SELECT * FROM Table", CommandType.StoredProcedure, "@", 0, 1, 2, 3);
     Utilities.SQL.MicroORM.Command Object8 = new Utilities.SQL.MicroORM.Command("SELECT * FROM Table2", CommandType.Text, "@", 0, 1, 2, 3);
     Assert.Equal(Object1, Object2);
     Assert.NotEqual(Object1, Object3);
     Assert.NotEqual(Object1, Object4);
     Assert.NotEqual(Object1, Object5);
     Assert.NotEqual(Object1, Object6);
     Assert.NotEqual(Object1, Object7);
     Assert.NotEqual(Object1, Object8);
 }

Beispiel #4

Datei: Command.cs Projekt: rgshare/Craig-s-Utility-Library

 public void Equality()
 {
     Utilities.SQL.MicroORM.Command Object1 = new Utilities.SQL.MicroORM.Command("SELECT * FROM Table", CommandType.Text, "@", 0, 1, 2, 3);
     Utilities.SQL.MicroORM.Command Object2 = new Utilities.SQL.MicroORM.Command("SELECT * FROM Table", CommandType.Text, "@", 0, 1, 2, 3);
     Utilities.SQL.MicroORM.Command Object3 = new Utilities.SQL.MicroORM.Command("SELECT * FROM Table", CommandType.Text, "@", 0, 1, 2);
     Utilities.SQL.MicroORM.Command Object4 = new Utilities.SQL.MicroORM.Command("SELECT * FROM Table", CommandType.Text, "@", 0, 1);
     Utilities.SQL.MicroORM.Command Object5 = new Utilities.SQL.MicroORM.Command("SELECT * FROM Table", CommandType.Text, "@", 0);
     Utilities.SQL.MicroORM.Command Object6 = new Utilities.SQL.MicroORM.Command("SELECT * FROM Table", CommandType.Text);
     Utilities.SQL.MicroORM.Command Object7 = new Utilities.SQL.MicroORM.Command("SELECT * FROM Table", CommandType.StoredProcedure, "@", 0, 1, 2, 3);
     Utilities.SQL.MicroORM.Command Object8 = new Utilities.SQL.MicroORM.Command("SELECT * FROM Table2", CommandType.Text, "@", 0, 1, 2, 3);
     Assert.Equal(Object1, Object2);
     Assert.NotEqual(Object1, Object3);
     Assert.NotEqual(Object1, Object4);
     Assert.NotEqual(Object1, Object5);
     Assert.NotEqual(Object1, Object6);
     Assert.NotEqual(Object1, Object7);
     Assert.NotEqual(Object1, Object8);
 }

Beispiel #5

Datei: Command.cs Projekt: yuanlianxi/Craig-s-Utility-Library

 public void Equality2()
 {
     Utilities.SQL.MicroORM.Command Object1 = new Utilities.SQL.MicroORM.Command("SELECT * FROM Table", CommandType.Text, "@", 1, 1);
     Utilities.SQL.MicroORM.Command Object2 = new Utilities.SQL.MicroORM.Command("SELECT * FROM Table", CommandType.Text, "@", 1, 2);
     Assert.NotEqual(Object1, Object2);
 }

Beispiel #6

Datei: SQLCommand.cs Projekt: ewin66/VilinCode

 public void SelectTest()
 {
     Utilities.SQL.MicroORM.Command BuiltCommand = Utilities.SQL.SQLCommand.Select("Test").Distinct().Where("Value1=@0", "@", "Test").Build();
     Assert.Equal("SELECT DISTINCT * FROM Test  WHERE Value1=@0", BuiltCommand.SQLCommand);
     Assert.Contains(new StringParameter("0", "Test"), BuiltCommand.Parameters);
 }

Beispiel #7

Datei: Command.cs Projekt: rgshare/Craig-s-Utility-Library

 public void Equality2()
 {
     Utilities.SQL.MicroORM.Command Object1 = new Utilities.SQL.MicroORM.Command("SELECT * FROM Table", CommandType.Text, "@", 1, 1);
     Utilities.SQL.MicroORM.Command Object2 = new Utilities.SQL.MicroORM.Command("SELECT * FROM Table", CommandType.Text, "@", 1, 2);
     Assert.NotEqual(Object1, Object2);
 }