public ISelectStatement CreateSelect()
        {
            var select = new BasicSelectStatement();

            foreach (string field in this.setup.SelectedFields)
            {
                select.AddField(field);
            }

            return select;
        }
예제 #2
0
 /// <summary>
 /// Select a list of field names from the table or view
 /// </summary>
 /// <param name="tableName">The table/view that contains the data</param>
 /// <param name="fields">The list of field names containing the data to select</param>
 public SimpleSQLFactory(string tableName, List<string> fields)
 {
     this.tableName = tableName;
     this.fields = fields;
     this.select = new BasicSelectStatement();
 }
예제 #3
0
 /// <summary>
 /// Specify a select all (*) query from the specified table/view
 /// </summary>
 /// <param name="tableName">The table/view that contains the data</param>
 public SimpleSQLFactory(string tableName)
 {
     this.tableName = tableName;
     this.fields = new List<string>() { "*" };
     this.select = new BasicSelectStatement();
 }
 public ISelectStatement CreateSelect()
 {
     var select = new BasicSelectStatement();
     select.AddField(NAME_FIELD);
     return select;
 }
 public ISelectStatement CreateSelect()
 {
     var select = new BasicSelectStatement();
     select.AddField(FIELDS_ONLY);
     return select;
 }
예제 #6
0
        public void TestSimpleSelectOneSpecifiedField()
        {
            string expected = "Select emp";

            var select = new BasicSelectStatement();
            select.AddField("emp");

            Assert.AreEqual(expected.ToLower(), select.ToString().ToLower());
        }