How to use CellRetrieverByName method of NBi.Core.ResultSet.Lookup.CellRetrieverByName class

Best NBi code snippet using NBi.Core.ResultSet.Lookup.CellRetrieverByName.CellRetrieverByName

CellsRetrieverByNameTest.cs

Source:CellsRetrieverByNameTest.cs

...37            var columns = new List<IColumnDefinition>()38            {39                new Column() { Identifier = new ColumnNameIdentifier("zero"), Type=ColumnType.Text}40            };41            var keyRetriever = new CellRetrieverByName(columns);42            Assert.That(keyRetriever.GetColumns(table.Rows[0]).Members, Is.EqualTo(new[] { "Key0" }));43            Assert.That(keyRetriever.GetColumns(table.Rows[1]).Members, Is.EqualTo(new[] { "Key1" }));44            Assert.That(keyRetriever.GetColumns(table.Rows[2]).Members, Is.EqualTo(new[] { "Key0" }));45        }46        [Test]47        public void GetKeys_UniqueCellNumeric_CorrectCell()48        {49            var table = BuildDataTable(new[] { "Key0", "Key1", "Key0" }, new[] { "Foo", "Bar", "Foo" }, new object[] { 0, 1, 0 });50            var columns = new List<IColumnDefinition>()51            {52                new Column() { Identifier = new ColumnNameIdentifier("two"), Type=ColumnType.Numeric}53            };54            var keyRetriever = new CellRetrieverByName(columns);55            Assert.That(keyRetriever.GetColumns(table.Rows[0]).Members, Is.EqualTo(new[] { 0 }));56            Assert.That(keyRetriever.GetColumns(table.Rows[1]).Members, Is.EqualTo(new[] { 1 }));57            Assert.That(keyRetriever.GetColumns(table.Rows[2]).Members, Is.EqualTo(new[] { 0 }));58        }59        [Test]60        public void GetKeys_UniqueCellNumericCasting_CorrectCell()61        {62            var table = BuildDataTable(new[] { "Key0", "Key1", "Key0" }, new[] { "Foo", "Bar", "Foo" }, new object[] { "0", "1.0", "0.00" });63            var columns = new List<IColumnDefinition>()64            {65                new Column() { Identifier = new ColumnNameIdentifier("two"), Type=ColumnType.Numeric}66            };67            var keyRetriever = new CellRetrieverByName(columns);68            Assert.That(keyRetriever.GetColumns(table.Rows[0]).Members, Is.EqualTo(new[] { 0 }));69            Assert.That(keyRetriever.GetColumns(table.Rows[1]).Members, Is.EqualTo(new[] { 1 }));70            Assert.That(keyRetriever.GetColumns(table.Rows[2]).Members, Is.EqualTo(new[] { 0 }));71        }72        [Test]73        public void GetKeys_TwoCells_CorrectCells()74        {75            var table = BuildDataTable(new[] { "Key0", "Key1", "Key0" }, new[] { "Foo", "Bar", "Foo" }, new object[] { 0, 1, 0 });76            var columns = new List<IColumnDefinition>()77            {78                new Column() { Identifier = new ColumnNameIdentifier("zero"), Type=ColumnType.Text},79                new Column() { Identifier = new ColumnNameIdentifier("one"), Type=ColumnType.Text}80            };81            var keyRetriever = new CellRetrieverByName(columns);82            Assert.That(keyRetriever.GetColumns(table.Rows[0]).Members, Is.EqualTo(new[] { "Key0", "Foo" }));83            Assert.That(keyRetriever.GetColumns(table.Rows[1]).Members, Is.EqualTo(new[] { "Key1", "Bar" }));84            Assert.That(keyRetriever.GetColumns(table.Rows[2]).Members, Is.EqualTo(new[] { "Key0", "Foo" }));85        }86        [Test]87        public void GetKeys_TwoCellsDifferentTypes_CorrectCells()88        {89            var table = BuildDataTable(new[] { "Key0", "Key1", "Key0" }, new[] { "Foo", "Bar", "Foo" }, new object[] { 0, 1, 0 });90            var columns = new List<IColumnDefinition>()91            {92                new Column() { Identifier = new ColumnNameIdentifier("zero"), Type=ColumnType.Text},93                new Column() { Identifier = new ColumnNameIdentifier("two"), Type=ColumnType.Numeric}94            };95            var keyRetriever = new CellRetrieverByName(columns);96            Assert.That(keyRetriever.GetColumns(table.Rows[0]).Members, Is.EqualTo(new object[] { "Key0", 0 }));97            Assert.That(keyRetriever.GetColumns(table.Rows[1]).Members, Is.EqualTo(new object[] { "Key1", 1 }));98            Assert.That(keyRetriever.GetColumns(table.Rows[2]).Members, Is.EqualTo(new object[] { "Key0", 0 }));99        }100        [Test]101        public void GetKeys_TwoCellsReverseOrder_CorrectCells()102        {103            var table = BuildDataTable(new[] { "Key0", "Key1", "Key0" }, new[] { "Foo", "Bar", "Foo" }, new object[] { 0, 1, 0 });104            var columns = new List<IColumnDefinition>()105            {106                new Column() { Identifier = new ColumnNameIdentifier("one"), Type=ColumnType.Text},107                new Column() { Identifier = new ColumnNameIdentifier("zero"), Type=ColumnType.Text}108            };109            var keyRetriever = new CellRetrieverByName(columns);110            Assert.That(keyRetriever.GetColumns(table.Rows[0]).Members, Is.EqualTo(new[] { "Foo", "Key0" }));111            Assert.That(keyRetriever.GetColumns(table.Rows[1]).Members, Is.EqualTo(new[] { "Bar", "Key1" }));112            Assert.That(keyRetriever.GetColumns(table.Rows[2]).Members, Is.EqualTo(new[] { "Foo", "Key0" }));113        }114        [Test]115        public void GetKeys_NonExistingCell_CorrectMessage()116        {117            var table = BuildDataTable(new[] { "Key0", "Key1", "Key0" }, new[] { "Foo", "Bar", "Foo" }, new object[] { 0, 1, 0 });118            var columns = new List<IColumnDefinition>()119            {120                new Column() { Identifier = new ColumnNameIdentifier("notExisting"), Type=ColumnType.Text},121                new Column() { Identifier = new ColumnNameIdentifier("zero"), Type=ColumnType.Text}122            };123            var keyRetriever = new CellRetrieverByName(columns);124            var ex = Assert.Throws<NBiException>(() => keyRetriever.GetColumns(table.Rows[0]));125            Assert.That(ex.Message, Does.Contain(": 'zero', 'one', 'two'."));126        }127    }128}...

LookupExistsAnalyzer.cs

Source:LookupExistsAnalyzer.cs

...48            }49            if (columns.Any(x => target(x) is ColumnOrdinalIdentifier))50                return new CellRetrieverByOrdinal(defColumns);51            else52                return new CellRetrieverByName(defColumns);53        }54        protected IEnumerable<KeyCollection> BuildReferenceIndex(DataTable table, CellRetriever keyRetriever)55        {56            var references = new HashSet<KeyCollection>();57            foreach (DataRow row in table.Rows)58            {59                var keys = keyRetriever.GetColumns(row);60                if (!references.Contains(keys))61                    references.Add(keys);62            }63            return references;64        }65        protected virtual LookupViolationCollection ExtractLookupViolation(DataTable table, CellRetriever keyRetriever, IEnumerable<KeyCollection> references)66        {...

CellRetrieverByName.cs

Source:CellRetrieverByName.cs

...6using System.Globalization;7using System.Linq;8namespace NBi.Core.ResultSet.Lookup9{10    class CellRetrieverByName : CellRetriever11    {12        public CellRetrieverByName(IEnumerable<IColumnDefinition> settings)13            : base(settings)14        { }15        public override KeyCollection GetColumns(DataRow row)16        {17            var keys = new List<object>();18            foreach (var setting in Settings)19            {20                var name = (setting.Identifier as ColumnNameIdentifier).Name;21                try22                {23                    var value = FormatValue(setting.Type, row[name]);24                    keys.Add(value);25                }26                catch (ArgumentException ex)...

CellRetrieverByName

Using AI Code Generation

1using System;2using System.Collections.Generic;3using System.Linq;4using System.Text;5using System.Threading.Tasks;6using NBi.Core.ResultSet.Lookup;7{8    {9        static void Main(string[] args)10        {11            var cellRetriever = new CellRetrieverByName();12            var rs = new ResultSet();13            rs.Columns.Add(new Column("col1", new ColumnType(DbType.Int32)));14            rs.Columns.Add(new Column("col2", new ColumnType(DbType.Int32)));15            var row = new Row();16            row.Cells.Add(new Cell(1));17            row.Cells.Add(new Cell(2));18            rs.Rows.Add(row);19            var cell = cellRetriever.Execute(rs, "col2");20            Console.WriteLine(cell.Value);21            Console.ReadLine();22        }23    }24}25using System;26using System.Collections.Generic;27using System.Linq;28using System.Text;29using System.Threading.Tasks;30using NBi.Core.ResultSet.Lookup;31{32    {33        static void Main(string[] args)34        {35            var cellRetriever = new CellRetrieverByName();36            var rs = new ResultSet();37            rs.Columns.Add(new Column("col1", new ColumnType(DbType.Int32)));38            rs.Columns.Add(new Column("col2", new ColumnType(DbType.Int32)));39            var row = new Row();40            row.Cells.Add(new Cell(1));41            row.Cells.Add(new Cell(2));42            rs.Rows.Add(row);43            var cell = cellRetriever.Execute(rs, "col3");44            Console.WriteLine(cell.Value);45            Console.ReadLine();46        }47    }48}

CellRetrieverByName

Using AI Code Generation

1using System;2using System.Collections.Generic;3using System.Linq;4using System.Text;5using System.Threading.Tasks;6using NBi.Core.ResultSet.Lookup;7using NUnit.Framework;8{9    {10        public void TestMethod1()11        {12            var cellRetriever = new CellRetrieverByName();13            var row = new Row(new object[] { "a", "b", "c" });14            Assert.AreEqual("a", cellRetriever.Get(row, "Column0"));15            Assert.AreEqual("b", cellRetriever.Get(row, "Column1"));16            Assert.AreEqual("c", cellRetriever.Get(row, "Column2"));17        }18    }19}20using System;21using System.Collections.Generic;22using System.Linq;23using System.Text;24using System.Threading.Tasks;25using NBi.Core.ResultSet.Lookup;26using NUnit.Framework;27{28    {29        public void TestMethod2()30        {31            var cellRetriever = new CellRetrieverByName();32            var row = new Row(new object[] { "a", "b", "c" });33            Assert.AreEqual("a", cellRetriever.Get(row, "Column0"));34            Assert.AreEqual("b", cellRetriever.Get(row, "Column1"));35            Assert.AreEqual("c", cellRetriever.Get(row, "Column2"));36        }37    }38}39using System;40using System.Collections.Generic;41using System.Linq;42using System.Text;43using System.Threading.Tasks;44using NBi.Core.ResultSet.Lookup;45using NUnit.Framework;46{47    {48        public void TestMethod3()49        {50            var cellRetriever = new CellRetrieverByName();51            var row = new Row(new object[] { "a", "b", "c" });52            Assert.AreEqual("a", cellRetriever.Get(row, "Column0"));53            Assert.AreEqual("b", cellRetriever.Get(row, "Column1"));

CellRetrieverByName

Using AI Code Generation

1using System;2using System.Collections.Generic;3using System.Linq;4using System.Text;5using System.Threading.Tasks;6using NBi.Core.ResultSet.Lookup;7using NBi.Core.ResultSet;8using NBi.Core.Calculation;9{10    {11        static void Main(string[] args)12        {13            var rs = new ResultSet();14            rs.Load(ResultSet.Read(@"C:\temp\test.csv"), false);15            var cr = new CellRetrieverByName(rs, "Name");16            var result = cr.GetCell(0);17            Console.WriteLine(result);18            Console.ReadLine();19        }20    }21}22using System;23using System.Collections.Generic;24using System.Linq;25using System.Text;26using System.Threading.Tasks;27using NBi.Core.ResultSet.Lookup;28using NBi.Core.ResultSet;29using NBi.Core.Calculation;30{31    {32        static void Main(string[] args)33        {34            var rs = new ResultSet();35            rs.Load(ResultSet.Read(@"C:\temp\test.csv"), false);36            var cr = new CellRetrieverByOrdinal(rs, 0);37            var result = cr.GetCell(0);38            Console.WriteLine(result);39            Console.ReadLine();40        }41    }42}43using System;44using System.Collections.Generic;45using System.Linq;46using System.Text;47using System.Threading.Tasks;48using NBi.Core.ResultSet.Lookup;49using NBi.Core.ResultSet;50using NBi.Core.Calculation;51{52    {53        static void Main(string[] args)54        {55            var rs = new ResultSet();56            rs.Load(ResultSet.Read(@"C:\temp\test.csv"), false);57            var cr = new CellRetrieverByOrdinal(rs, 0);58            var result = cr.GetCell("Name");59            Console.WriteLine(result);60            Console.ReadLine();61        }62    }63}

CellRetrieverByName

Using AI Code Generation

1using System;2using System.Data;3using System.IO;4using NBi.Core.Query;5using NBi.Core.ResultSet;6using NBi.Core.ResultSet.Lookup;7using NBi.Core.Calculation;8using NBi.Core.Calculation.Predicate;9{10    {11        static void Main(string[] args)12        {13            var dt = new DataTable();14            dt.Columns.Add("Name");15            dt.Columns.Add("Age");16            dt.Rows.Add("John", 25);17            dt.Rows.Add("Mary", 30);18            dt.Rows.Add("George", 28);19            var rs = new ResultSet.ResultSet(dt);20            var retriever = new CellRetrieverByName(rs, "Name");21            var value = retriever.GetValue(1);22            Console.WriteLine("Name of the second row is: " + value);23        }24    }25}26using System;27using System.Data;28using System.IO;29using NBi.Core.Query;30using NBi.Core.ResultSet;31using NBi.Core.ResultSet.Lookup;32using NBi.Core.Calculation;33using NBi.Core.Calculation.Predicate;34{35    {36        static void Main(string[] args)37        {38            var dt = new DataTable();39            dt.Columns.Add("Name");40            dt.Columns.Add("Age");41            dt.Rows.Add("John", 25);42            dt.Rows.Add("Mary", 30);43            dt.Rows.Add("George", 28);44            var rs = new ResultSet.ResultSet(dt);45            var retriever = new CellRetrieverByOrdinal(rs, 1);46            var value = retriever.GetValue(1);47            Console.WriteLine("Age of the second row is: " + value);48        }49    }50}

CellRetrieverByName

Using AI Code Generation

1using NBi.Core.ResultSet.Lookup;2using NBi.Core.ResultSet;3using System.Data;4using System;5using System.Linq;6using System.Collections.Generic;7using System.Text;8using System.Threading.Tasks;9{10    {11        static void Main(string[] args)12        {13            DataTable dt = new DataTable();14            dt.Columns.Add("ID", typeof(int));15            dt.Columns.Add("Name", typeof(string));16            dt.Columns.Add("Age", typeof(int));17            dt.Columns.Add("Salary", typeof(int));18            dt.Rows.Add(1, "A", 10, 100);19            dt.Rows.Add(2, "B", 20, 200);20            dt.Rows.Add(3, "C", 30, 300);21            dt.Rows.Add(4, "D", 40, 400);22            dt.Rows.Add(5, "E", 50, 500);23            dt.Rows.Add(6, "F", 60, 600);24            dt.Rows.Add(7, "G", 70, 700);25            dt.Rows.Add(8, "H", 80, 800);26            dt.Rows.Add(9, "I", 90, 900);27            dt.Rows.Add(10, "J", 100, 1000);28            ResultSet rs = new ResultSet(dt);29            CellRetrieverByName cr = new CellRetrieverByName(rs);30            var cell = cr.Execute("ID", 3);31            Console.WriteLine(cell);32            Console.ReadLine();33        }34    }35}36using NBi.Core.ResultSet.Lookup;37using NBi.Core.ResultSet;38using System.Data;39using System;40using System.Linq;41using System.Collections.Generic;42using System.Text;43using System.Threading.Tasks;44{45    {46        static void Main(string[] args)47        {48            DataTable dt = new DataTable();49            dt.Columns.Add("ID", typeof(int));50            dt.Columns.Add("Name", typeof(string));51            dt.Columns.Add("Age", typeof(int));52            dt.Columns.Add("Salary", typeof(int));53            dt.Rows.Add(1, "A", 10, 100);54            dt.Rows.Add(2, "B", 20, 200);55            dt.Rows.Add(3, "C56using System.Linq;57using System.Text;58using System.Threading.Tasks;59using NBi.Core.ResultSet.Lookup;60using NBi.Core.ResultSet;61using NBi.Core.Calculation;62{63    {64        static void Main(string[] args)65        {66            var rs = new ResultSet();67            rs.Load(ResultSet.Read(@"C:\temp\test.csv"), false);68            var cr = new CellRetrieverByName(rs, "Name");69            var result = cr.GetCell(0);70            Console.WriteLine(result);71            Console.ReadLine();72        }73    }74}75using System;76using System.Collections.Generic;77using System.Linq;78using System.Text;79using System.Threading.Tasks;80using NBi.Core.ResultSet.Lookup;81using NBi.Core.ResultSet;82using NBi.Core.Calculation;83{84    {85        static void Main(string[] args)86        {87            var rs = new ResultSet();88            rs.Load(ResultSet.Read(@"C:\temp\test.csv"), false);89            var cr = new CellRetrieverByOrdinal(rs, 0);90            var result = cr.GetCell(0);91            Console.WriteLine(result);92            Console.ReadLine();93        }94    }95}96using System;97using System.Collections.Generic;98using System.Linq;99using System.Text;100using System.Threading.Tasks;101using NBi.Core.ResultSet.Lookup;102using NBi.Core.ResultSet;103using NBi.Core.Calculation;104{105    {106        static void Main(string[] args)107        {108            var rs = new ResultSet();109            rs.Load(ResultSet.Read(@"C:\temp\test.csv"), false);110            var cr = new CellRetrieverByOrdinal(rs, 0);111            var result = cr.GetCell("Name");112            Console.WriteLine(result);113            Console.ReadLine();114        }115    }116}

CellRetrieverByName

Using AI Code Generation

1using System;2using System.Data;3using System.IO;4using NBi.Core.Query;5using NBi.Core.ResultSet;6using NBi.Core.ResultSet.Lookup;7using NBi.Core.Calculation;8using NBi.Core.Calculation.Predicate;9{10    {11        static void Main(string[] args)12        {13            var dt = new DataTable();14            dt.Columns.Add("Name");15            dt.Columns.Add("Age");16            dt.Rows.Add("John", 25);17            dt.Rows.Add("Mary", 30);18            dt.Rows.Add("George", 28);19            var rs = new ResultSet.ResultSet(dt);20            var retriever = new CellRetrieverByName(rs, "Name");21            var value = retriever.GetValue(1);22            Console.WriteLine("Name of the second row is: " + value);23        }24    }25}26using System;27using System.Data;28using System.IO;29using NBi.Core.Query;30using NBi.Core.ResultSet;31using NBi.Core.ResultSet.Lookup;32using NBi.Core.Calculation;33using NBi.Core.Calculation.Predicate;34{35    {36        static void Main(string[] args)37        {38            var dt = new DataTable();39            dt.Columns.Add("Name");40            dt.Columns.Add("Age");41            dt.Rows.Add("John", 25);42            dt.Rows.Add("Mary", 30);43            dt.Rows.Add("George", 28);44            var rs = new ResultSet.ResultSet(dt);45            var retriever = new CellRetrieverByOrdinal(rs, 1);46            var value = retriever.GetValue(1);47            Console.WriteLine("Age of the second row is: " + value);48        }49    }50}

Automation Testing Tutorials

Learn to execute automation testing from scratch with LambdaTest Learning Hub. Right from setting up the prerequisites to run your first automation test, to following best practices and diving deeper into advanced test scenarios. LambdaTest Learning Hubs compile a list of step-by-step guides to help you be proficient with different test automation frameworks i.e. Selenium, Cypress, TestNG etc.