· 8 years ago · Mar 07, 2018, 03:24 AM
1 //=========================================
2 this.aq[1] = "What does term 'HTML' mean?";
3 this.aa[1] = "Hypertext Markup Language";
4 this.aq[2] = "What does term 'ASP' mean?";
5 this.aa[2] = "Active Server Pages";
6 this.aq[3] = "What does term '.NET' mean?";
7 this.aa[3] = "Microsoft’s framework for the Special software development";
8 this.aq[4] = "What is the difference between 'ASP.NET' and 'ASP'?";
9 this.aa[4] = "ASP.NET is based on the .NET technology. Moreover, ASP.NET support more programming languages than ASP and has more libraries that can be integrated with the actual code.";
10 this.aq[5] = "What is the Common Language Runtime (CLR) within .NET-technology?";
11 this.aa[5] = "The Common Language Runtime is an 'engine' that compiles, runs, and manages .NET programs.";
12 this.aq[6] = "What is the Intermediate Language (IL) within .NET-technology?";
13 this.aa[6] = "The Intermediate Language is a lower level language into which ASP.NET programs are translated before execution. The advantage of this language is that it allows code compatibility between different languages that are based on it.";
14 this.aq[7] = "What is the object-oriented programming (OOP)?";
15
16 this.aa[7] = "It is a programming paradigm using 'objects' – data structures consisting of data fields and methods together with their interactions – to design applications and computer programs. The advantage of OOP over structural programming is that it allows structural and data abstraction.";
17 this.aq[8] = "What is the encapsulation in OOP?";
18 this.aq[9] = "What is the polymorphism OOP?";
19 this.aq[10] = "What is the inheritance in OOP?";
20 this.aq[11] = "What are the methods in OOP?";
21 this.aq[12] = "What is the properties in OOP?";
22 this.aq[13] = "What is the field in OOP?";
23 this.aq[14] = "What is the client-server programming?";
24 this.aq[15] = "What is the 'rich client'?";
25 this.aq[16] = "What is the 'thin client'?";
26 this.aq[17] = "What is the SQL?";
27 this.aq[18] = "What is the LINQ?";
28 this.aq[19] = "What is the XML (eXtensible Markup Language)?";
29 this.aq[20] = "What is the web-hosting?";
30 this.aq[21] = "What is the DN-service?";
31 this.aq[22] = "What is the network backbone?";
32 this.aq[23] = "What is the Internet-provider?";
33 this.aq[24] = "What is the difference between Internet and Intranet?";
34 this.aq[25] = "What is the World Wide Web Consortium (W3C)?";
35 this.aq[26] = "What is the Visual Studio environment?";
36 this.aq[27] = "What is the Borland Delphi environment?";
37 this.aq[28] = "What is the 4GL?";
38 this.aq[29] = "What is the 3GL?";
39 this.aq[30] = "What is the 5GL?";
40 this.aa[30] = "It is a programming language based around solving problems using constraints given to the program, rather than using an algorithm written by a programmer. In praesenti, it is analogue of the artificial intelligence's programming language. Examples: Prolog, OPS5, and Mercury.";
41 this.aq[31] = "What is the JavaScript?";
42 this.aq[32] = "What is the AJAX within ASP.NET?";
43 this.aq[33] = "What do variable and array mean in programming?";
44 this.aq[34] = "What is the difference between relational and hierarchical databases?";
45 this.aq[35] = "What is the first programming language for .NET technology?";
46 this.aq[36] = "What is the Application Programming Interface (API)?";
47 this.aq[37] = "What is the MVC (Model – View – Control) technology in programming theory?";
48 this.aa[37] = "It is grounded on the separation of the modeling of the domain, the presentation, and the actions based on user input into three separate classes. The model manages the behavior and data of the application domain, responds to requests for information about its state, and responds to instructions to change state. The view manages the display of information. The controller interprets the mouse and keyboard inputs from the user, informing the model and/or the view to change as appropriate.";
49 this.aa[36] = "It is a collection of methods and standards used for interaction between different programs.";
50 this.aa[35] = "C#. In a fact, Microsoft launched the .NET platform and the C# programming language in the summer of 2000.";
51 this.aa[34] = "In the first one, databases, the data is organized in a table-like structure. In the second one, databases, the data is organized hierarchically, in a tree-like structure.";
52 this.aa[33] = "The first one is a field for storing data. The second one is a collection of fields of the same type.";
53 this.aa[32] = "Technology 'Asynchronous JavaScript and XML' is a collection of functions used for sending data to a server and taking data from a server, but without having to reload the webpage.";
54 this.aa[31] = "It is a client-side scripting language used for adding dynamic capabilities to web pages.";
55 this.aa[29] = "It is a refinement of a second-generation programming language. It brought refinements to make the languages more programmer-friendly. This includes features like improved support for aggregate data types, and expressing concepts in a way that favours the programmer, not the computer. Examples: Fortran, C, C++, C#, Java, BASIC, Delphi.";
56 this.aa[28] = "It is a programming language or programming environment designed with a specific purpose in mind, such as the development of commercial business software. Other definition – it is a high-level programming language which is based on the natural and/or visual constructions.";
57 this.aa[27] = "It is IDE for MicrosoftWindows, based on Borland's ObjectPascal.";
58 this.aa[26] = "It is an integrated development environment (IDE) developed by Microsoft, having compilers for languages like C/C++, C#, Visual Basic.";
59 this.aa[25] = "It is an organization that defines standards for the World Wide Web.";
60 this.aa[24] = "The first one is a global computer network that connects computers from all over the world. The second one is a local computer network which connects computers that are part of one organization or corporation, such that only the members of the organization have access to the network.";
61 this.aa[23] = "It is a company that serves users with access to the Internet.";
62 this.aa[22] = "It is a part of computer network infrastructure that interconnects various pieces of network, providing a path for the exchange of information between different LANs or subnetworks.";
63 this.aa[21] = "It is a hierarchical distributed naming system for computers, services, or any resource connected to the Internet or a private network. It associates various information with domain names assigned to each of the participating entities.";
64 this.aa[20] = "It is a service that enables users to make a website live, i.e. that enables end users to access it through the internet.";
65 this.aa[19] = "It is a markup language for storing and transporting data. Users must define their own tags to store actual data.";
66 this.aa[18] = "Language Integrated Query is a Microsoft programming model and methodology that essentially adds formal query capabilities into Microsoft .NET-based programming languages.";
67 this.aa[17] = "Structured Query Language is a language for sending queries to a database.";
68 this.aa[16] = "The client doesn’t have enough functionality to work independently from a server.";
69 this.aa[15] = "The client has enough functionality to be independent from a server.";
70 this.aa[14] = "It is a programming that implements the client-server model in which one program acts as client and another program acts as a server. The client sends a requests to the server which then answers to that request.";
71 this.aa[13] = "Instance of variable or/and attribute. The fields could be simple data types or other objects.";
72 this.aa[12] = "They are containers for primitive values and other objects. In the case when the Type of object is function (as we will see in more detailed below), such properties are called as methods.";
73 this.aa[11] = "They are subroutines that manipulate the data defined by the class and, in many cases, provide access to that data.";
74 this.aa[10] = "It is a way to reuse code of existing objects, establish a subtype from an existing object, or both, depending upon programming language support.";
75 this.aa[9] = "It is the ability to create a variable, a function, or an object that has more than one form.";
76 this.aa[8] = "A language mechanism for restricting access to some of the object's components.";
77
78
79 this.aq[38] = "ASP.NET is based on the...";
80 this.aa[38] = "Server-side programming (in general, but client-side programming is possible too)";
81 this.aq[39] = "Two polar parts of ASP.NET technology are called as";
82 this.aa[39] = "Server and client";
83 this.aq[40] = "Two main ways for the Visual Studio’s free version’s obtaining are ...";
84 this.aa[40] = "MSDN and WebSiteSpark program";
85 this.aq[41] = "Main functions of DNS-service:";
86 this.aa[41] = "To forward URLs around, and to allow to use the specific name servers (in a fact, these are host servers).";
87 this.aq[42] = "The main purpose of the non-profit web-site aspspider.com?";
88 this.aa[42] = "To host educational ASP.NET-applications.";
89 this.aq[43] = "Assembly language is ...";
90 this.aa[43] = "First-generation programming language.";
91 this.aq[44] = "C# is ...";
92 this.aa[44] = "Third-generation programming language.";
93 this.aq[45] = "Prolog is ...";
94 this.aa[45] = "Fifth-generation programming language.";
95 this.aq[46] = "Signature of the ‘All’ operator is ...";
96 this.aa[46] = "public static Boolean All<TSource>(\r\n this IEnumerable<TSource> source,\r\n Func<TSource, Boolean> predicate);";
97 this.aq[47] = "Table-driven (codeless) programming is ...";
98 this.aa[47] = "Is a feature of fourth-generation programming languages.";
99 this.aq[48] = "Report-generator programming and database query languages are ...";
100 this.aa[48] = "They are fourth-generation programming languages.";
101 this.aq[49] = "Signature of the ‘Any’ method with predicate is ...";
102 this.aa[49] = "public static Boolean Any<TSource>(\r\n this IEnumerable<TSource> source,\r\n Func<TSource, Boolean> predicate);";
103 this.aq[50] = "Signature of the ‘Any’ method without predicate is ...";
104 this.aa[50] = "public static Boolean Any<TSource>(\r\n this IEnumerable<TSource> source);";
105 this.aq[51] = "LINQ architecture includes two main parts which are ...";
106 this.aa[51] = "Data sources and language integrated query.";
107 this.aq[52] = "LINQ to Objects";
108 this.aa[52] = "It refers to the use of LINQ queries to access in-memory data structures. We can query any type that supports IEnumerable<T> (C#).";
109 this.aq[53] = "LINQ to SQL";
110 this.aa[53] = "It is used for managing the relational data as objects. It is part of the ADO.NET family of technologies. LINQ to SQL translates the Language Integrated Queries in the object model to SQL and sends them to the database for execution. When the database returns the result, LINQ to SQL translates them back to objects that we can work with. LINQ to SQL also supports stored procedures and user-defined functions in the database.";
111 this.aq[54] = "LINQ to Datasets";
112 this.aa[54] = "It makes it easier to query the data cached in Datasets. A Dataset is disconnected, consolidated data from different data sources.";
113 this.aq[55] = "LINQ to Entities";
114 this.aa[55] = "The Entity Data Model is a conceptual data model that can be used to model the data so that applications can interact with data as entities or objects. Through the Entity Data Model, ADO.NET exposes the entities as objects.";
115 this.aq[56] = "LINQ to XML";
116 this.aa[56] = "It provides the in-memory document modification capabilities of the Document Object Model and supports LINQ queries. Using LINQ to XML, we can query, modify, navigate, and save the changes of an XML document. It enables us to write queries to navigate and retrieve a collection of elements and attributes. It is similar to XPath and XQuery.";
117 this.aq[57] = "XML parser";
118 this.aa[57] = "This is special software for converting an XML document into an XML DOM object.";
119 this.aq[58] = "IEnumerable<T> is ...";
120 this.aa[58] = "It is a strong typed variant of IEnumerable. Interface IEnumerable<T> was realized in such standard classes as typed collections Collection<T>, lists List<T>, unique lists HashSet<T>, dictionaries Dictionary<K,V>, etc.";
121 this.aq[59] = "To iterate over the query is with a simple For…Each statement we will use ...";
122 this.aa[59] = "foreach (var emp in empQuery)\r\n{\r\n Console.WriteLine(emp.Department);\r\n}";
123 this.aq[60] = "Example of the Count method is ...";
124 this.aa[60] = "int cnt = empQuery.Count();";
125 this.aq[61] = "Calling the ToList<T> or ToArray<T> to execute the query and cache the results in a list object or an array is ...";
126 this.aa[61] = "List<Employee> empQuery = (from emp in employees where emp.Department == ''IT Department'' select emp).ToList();";
127 this.aq[62] = "Querying Data with LINQ includes next main steps:";
128 this.aa[62] = "To define a data source. To define a strongly typed query against that data.";
129 this.aq[63] = "The following example shows an array of strings; then the LINQ query is written against this array:";
130 this.aa[63] = "string[] employees = {''Michael'', ''Hank'', ''Benjamin'', ''Gail''};\r\nvar empQuery = from emp in employees where emp.Length>5 select emp;";
131 this.aq[64] = "The following example creates a new List<Employee> collection. The Employee class is simply a custom class that was written to hold a few properties. The code then defines a simple LINQ query against the object.";
132 this.aa[64] = "List<Employee> employees = new List<Employee>()\r\n{\r\n new Employee{\r\n First=''Michael'',\r\n ID=111,\r\n Department=''IT Department'',\r\n City=''Pittsburgh''},\r\n new Employee{\r\n First=''Hank'',\r\n ID=112,\r\n Department=''IT Department'',\r\n City=''Redmond''},\r\n new Employee{\r\n First=''Benjamin'',\r\n ID=113,\r\n Department=''Human Resources'',\r\n City=''Chicago''},\r\n new Employee{\r\n First=''Gail'',\r\n ID=114,\r\n Department=''Marketing'',\r\n City=''Ann Arbor''},\r\n};\r\nIEnumerable<Employee> empQuery = from emp in employees\r\n\t\t where emp.First.Length > 5\r\n\t\t select emp;";
133 this.aq[65] = "Every query starts and ends with next clauses accordingly.";
134 this.aa[65] = "‘from’, ‘select’ or group clauses.";
135 this.aq[66] = "Full query syntax is ...";
136 this.aa[66] = "query-expression ::= from-clause query-body\r\nquery-body ::=\r\njoin-clause*\r\n(from-clause join-clause* | let-clause | where-clause)*\r\norderby-clause?\r\n(select-clause | groupby-clause)\r\n\tquery-continuation?\r\nfrom-clause ::= from itemName in srcExpr\r\nselect-clause ::= select selExpr\r\ngroupby-clause ::= group selExpr by keyExpr";
137 this.aq[67] = "What result will be calculated after next query\r\nDeveloper[] developers = new Developer[] {\r\n new Developer {Name = ''Paolo'', Language = ''C#'', Age = 23},\r\n new Developer {Name = ''Marco'', Language = ''C#'', Age = 24},\r\n new Developer {Name = ''Frank'', Language = ''VB.NET'', Age = 78}};\r\nvar developersUsingCSharp =\r\n from d in developers\r\n where d.Language == ''C#''\r\n select d.Name + '' '' + d.Age;";
138 this.aa[67] = "Paolo 23; Marco 24";
139 this.aq[68] = "The main function of the query’s ‘from’ clause is ...";
140 this.aa[68] = "It defines the data source of a query or subquery and a range variable that defines each single element to query from the data source.";
141 this.aq[69] = "What kind of interfaces can implement data source in the query’s ‘from’ clause?";
142 this.aa[69] = "IEnumerable, IEnumerable<T>, or IQueryable<T>";
143 this.aq[70] = "The main function of the query’s ‘where’ clause is ...";
144 this.aa[70] = "It specifies a filtering condition to apply to the data source.";
145 this.aq[71] = "The main function of the query’s ‘select’ clause is ...";
146 this.aa[71] = "It specifies the shape of the query output. It is based on a projection that determines what to select from the result of the evaluation of all the clauses and expressions that precede it.";
147 this.aq[72] = "The main function of the query’s ‘group’ clause is ...";
148 this.aa[72] = "It can be used to project a result grouped by a key. It can be used as an alternative to the ‘from’ clause and allows to use single-value keys as well as multiple-value keys.";
149 this.aq[73] = "The main function of the query’s ‘into’ clause is ...";
150 this.aa[73] = "It is useful in conjunction with the group keyword, even if using it is not mandatory. Also, it is used for storing the results of a select, group, or join statement in a temporary variable. It is possible to use this construction when it is necessary to execute additional queries over the results.";
151 this.aq[74] = "The main function of the query’s ‘join’ clause is ...";
152 this.aa[74] = "It allows to associate different data sources on the basis of a member that can be compared for equivalency.";
153 this.aq[75] = "The main function of the query’s group join is ...";
154 this.aa[75] = "It defines a join that produces a hierarchical result set, grouping the inner sequence elements with their corresponding outer sequence elements. In cases in which an outer sequence element is missing its corresponding inner sequence elements, the outer element will be joined with an empty array.";
155 this.aq[76] = "Example of the composite key’s usage ...";
156 this.aa[76] = "join p in products on new { c.IdCategory, c.Year } equals new { p.IdCategory, p.Year }";
157 this.aq[77] = "The main function of the query’s ‘let’ clause is ...";
158 this.aa[77] = "It allows to store the result of a subexpression in a variable that can be used somewhere else in the query. This clause is useful when you need to reuse the same expression many times in the same query, and you do not want to define it every single time to use it. Using this clause, it possible to define a new range variable for that expression and subsequently reference it within the query. Once assigned, a range variable defined by this clause cannot be changed.";
159 this.aq[78] = "A query expression is evaluated when ...";
160 this.aa[78] = "It is used. I.e., it is not actually executed until it is used, and it will be executed again and again every time the program runs it.";
161 this.aq[79] = "Example of the extension method resolution’s concepts of LINQ.";
162 this.aa[79] = "In this code, a custom list of type Developer (named Developers) and a class, DevelopersExtension, that provides an extension method named Where that applies specifically to instances of the Developers type (the only special action the custom Where extension methods take is to write some output to the console, indicating that they have executed; after that, the methods pass the request to the Where extension methods defined for any standard instance of type IEnumerable<T>, converting the source with a method called AsEnumerable) are defined.";
163 this.aq[80] = "Example of the exception handling in queries";
164 this.aa[80] = "var query =\r\n from d in developers\r\n let SomethingResult = DoSomething(d)\r\n select new { d.Name, SomethingResult };\r\ntry{\r\n foreach (var item in query)\r\n Console.WriteLine(item);\r\n}\r\ncatch (ArgumentOutOfRangeException e){\r\n Console.WriteLine(e.Message);\r\n}";
165 this.aq[81] = "Example of the query which one simply iterates over the data source";
166 this.aa[81] = "Developer[] developers = new Developer[] {\r\n ...\r\n};\r\nvar query =\r\n from d in developers\r\n select d;\r\nforeach (var developer in query) {\r\n Console.WriteLine(developer.Name);\r\n}";
167 this.aq[82] = "Example of the query which one is oriented to list the names and cities of customers from Italy";
168 this.aa[82] = "var expr =\r\n from c in customers\r\n where c.Country == Countries.Italy\r\n select new { c.Name, c.City };";
169 this.aq[83] = "Signature of the ‘where’ operator without an additional parameter of type Int32 for the predicate";
170 this.aa[83] = "public static IEnumerable<TSource> Where<TSource>(\r\n this IEnumerable<TSource> source,\r\n Func<TSource, Boolean> predicate);";
171 this.aq[84] = "Signature of the ‘where’ operator with an additional parameter of type Int32 for the predicate";
172 this.aa[84] = "public static IEnumerable<TSource> Where<TSource>(\r\n this IEnumerable<TSource> source,\r\n Func<TSource, Int32, Boolean> predicate);";
173 this.aq[85] = "The query’s example of the extraction of the data’s specific page from a large sequence of items with the ‘where’ clause usage";
174 this.aa[85] = "var expr1 = customers\r\n .Where((c, index) => ((index >= start) && (index < end)))\r\n .Select(c => c.Name);";
175 this.aq[86] = "Query’s lambda expression is ...";
176 this.aa[86] = "It is an anonymous function that can contain expressions and statements, and can be used to create delegates or expression tree types.";
177 this.aq[87] = "Query’s lambda operator is ...";
178 this.aa[87] = "It is ‘=>’, which is read as 'goes to'. The left side specifies the input parameters (if any) and the right side holds the expression or statement block.";
179 this.aq[88] = "Projection operators include ...";
180 this.aa[88] = "Select and SelectMany operators";
181 this.aq[89] = "Signature of the ‘Select’ operator without an additional parameter of type Int32";
182 this.aa[89] = "public static IEnumerable<TResult> Select<TSource, TResult>(\r\n this IEnumerable<TSource> source,\r\n Func<TSource, TResult> selector);";
183 this.aq[90] = "Signature of the ‘Select’ operator with an additional parameter of type Int32";
184 this.aa[90] = "public static IEnumerable<TResult> Select<TSource, TResult>(\r\n this IEnumerable<TSource> source,\r\n Func<TSource, Int32, TResult> selector);";
185 this.aq[91] = "The main function of the query’s ‘SelectMany’ operator is ...";
186 this.aa[91] = "It enumerates the source sequence and merges the resulting items, providing them as a single enumerable sequence.";
187 this.aq[92] = "Signature of the ‘SelectMany’ operator without an additional parameter of type Int32, without collectionSelector projection";
188 this.aa[92] = "public static IEnumerable<TResult> SelectMany<TSource, TResult>(\r\n this IEnumerable<TSource> source,\r\n Func<TSource, IEnumerable<TResult>> selector);";
189 this.aq[93] = "Signature of the ‘SelectMany’ operator with an additional parameter of type Int32, without collectionSelector projection";
190 this.aa[93] = "public static IEnumerable<TResult> SelectMany<TSource, TResult>(\r\n this IEnumerable<TSource> source,\r\n Func<TSource, Int32, IEnumerable<TResult>> selector);";
191 this.aq[94] = "Signature of the ‘SelectMany’ operator without an additional parameter of type Int32, with collectionSelector projection";
192 this.aa[94] = "public static IEnumerable<TResult> SelectMany<TSource, TCollection, TResult>(\r\n this IEnumerable<TSource> source,\r\n Func<TSource, IEnumerable<TCollection>> collectionSelector,\r\n Func<TSource, TCollection, TResult> resultSelector);";
193 this.aq[95] = "Signature of the ‘SelectMany’ operator with an additional parameter of type Int32, with collectionSelector projection";
194 this.aa[95] = "public static IEnumerable<TResult> SelectMany<TSource, TCollection, TResult>(\r\n this IEnumerable<TSource> source,\r\n Func<TSource, Int32, IEnumerable<TCollection>> collectionSelector,\r\n Func<TSource, TCollection, TResult> resultSelector);";
195 this.aq[96] = "The main reason to use ‘SelectMany’ operator (comparing to ‘Select’ operator)";
196 this.aa[96] = "Because of the behavior of the Select operator, the resulting type of the query is IEnumerable<Order[]>, where each item in the resulting sequence represents the array.";
197 this.aq[97] = "Ordering operators include ...";
198 this.aa[97] = "OrderBy, OrderByDescending, ThenBy, ThenByDescending, Reverse";
199 this.aq[98] = "The main function of the ordering operators is ...";
200 this.aa[98] = "They determine the ordering and direction of elements in output sequences.";
201 this.aq[99] = "Signature of the ‘OrderBy’ operator without comparer";
202 this.aa[99] = "public static IOrderedEnumerable<TSource> OrderBy<TSource, TKey>(\r\n this IEnumerable<TSource> source,\r\n Func<TSource, TKey> keySelector);";
203 this.aq[100] = "Signature of the ‘OrderBy’ operator without comparer";
204 this.aa[100] = "public static IOrderedEnumerable<TSource> OrderBy<TSource, TKey>(\r\n this IEnumerable<TSource> source,\r\n Func<TSource, TKey> keySelector,\r\n IComparer<TKey> comparer);";
205 this.aq[101] = "Signature of the ‘OrderByDescending’ operator without comparer";
206 this.aa[101] = "public static IOrderedEnumerable<TSource> OrderByDescending<TSource, TKey>(\r\n this IEnumerable<TSource> source,\r\n Func<TSource, TKey> keySelector);";
207 this.aq[102] = "Signature of the ‘OrderByDescending’ operator with comparer";
208 this.aa[102] = "public static IOrderedEnumerable<TSource> OrderByDescending<TSource, TKey>(\r\n this IEnumerable<TSource> source,\r\n Func<TSource, TKey> keySelector,\r\n IComparer<TKey> comparer);";
209 this.aq[103] = "What is main reason to use the MonthComparer?";
210 this.aa[103] = "It might be useful when the items in the source sequence need to be ordered using custom logic.";
211 this.aq[104] = "Signature of the ‘ThenBy’ operator without comparer";
212 this.aa[104] = "public static IOrderedEnumerable<TSource> ThenBy<TSource, TKey>(\r\n this IOrderedEnumerable<TSource> source,\r\n Func<TSource, TKey> keySelector);";
213 this.aq[105] = "Signature of the ‘ThenBy’ operator with comparer";
214 this.aa[105] = "public static IOrderedEnumerable<TSource> ThenBy<TSource, TKey>(\r\n this IOrderedEnumerable<TSource> source,\r\n Func<TSource, TKey> keySelector,\r\n IComparer<TKey> comparer);";
215 this.aq[106] = "Signature of the ‘ThenByDescending’ operator without comparer";
216 this.aa[106] = "public static IOrderedEnumerable<TSource> ThenByDescending<TSource, TKey>(\r\n this IOrderedEnumerable<TSource> source,\r\n Func<TSource, TKey> keySelector);";
217 this.aq[107] = "Signature of the ‘ThenByDescending’ operator with comparer";
218 this.aa[107] = "public static IOrderedEnumerable<TSource> ThenByDescending<TSource, TKey>(\r\n this IOrderedEnumerable<TSource> source,\r\n Func<TSource, TKey> keySelector,\r\n IComparer<TKey> comparer);";
219 this.aq[108] = "It possible to apply ThenBy or ThenByDescending operators only after ...";
220 this.aa[108] = "It necessary to apply OrderBy or OrderByDescending firstly.";
221 this.aq[109] = "Reverse operator uses in the cases when ...";
222 this.aa[109] = "It is necessary to list the last item in the result first.";
223 this.aq[110] = "Signature of the ‘Reverse’ operator is ...";
224 this.aa[110] = "public static IEnumerable<TSource> Reverse<TSource>(this IEnumerable<TSource> source);";
225 this.aq[111] = "Grouping operators include ...";
226 this.aa[111] = "GroupBy operator.";
227 this.aq[112] = "What is the main function of the keySelector predicate within the GroupBy operator?";
228 this.aa[112] = "It is oriented to extract the Key value from each item to group results based on the different Key values.";
229 this.aq[113] = "What is the main function of the elementSelector argument within the GroupBy operator?";
230 this.aa[113] = "It defines a function that maps the source element within the source sequence to the destination element of the resulting sequence.";
231 this.aq[114] = "What is the main function of the resultSelector argument within the GroupBy operator?";
232 this.aa[114] = "It defines a projection for the parent operation, which lets us return an IEnumerable<TResult>.";
233 this.aq[115] = "What is the main function of the custom comparer within the GroupBy operator?";
234 this.aa[115] = "We use it when we need to compare key values and define group membership.";
235 this.aq[116] = "Join Operators include ...";
236 this.aa[116] = "Join and GroupJoin operators.";
237 this.aq[117] = "Signature of the ‘Join’ operator without comparer";
238 this.aa[117] = "public static IEnumerable<TResult> Join<TOuter, TInner, TKey, TResult>(\r\n this IEnumerable<TOuter> outer,\r\n IEnumerable<TInner> inner,\r\n Func<TOuter, TKey> outerKeySelector,\r\n Func<TInner, TKey> innerKeySelector,\r\n Func<TOuter, TInner, TResult> resultSelector);";
239 this.aq[118] = "Signature of the ‘Join’ operator with comparer";
240 this.aa[118] = "public static IEnumerable<TResult> Join<TOuter, TInner, TKey, TResult>(\r\n this IEnumerable<TOuter> outer,\r\n IEnumerable<TInner> inner,\r\n Func<TOuter, TKey> outerKeySelector,\r\n Func<TInner, TKey> innerKeySelector,\r\n Func<TOuter, TInner, TResult> resultSelector,\r\n IEqualityComparer<TKey> comparer);";
241 this.aq[119] = "What is the main function of the TOuter type within the ‘Join’ operator?";
242 this.aa[119] = "It represents the type of the outer source sequence.";
243 this.aq[120] = "What is the main function of the TInner type in the ‘Join’ operator?";
244 this.aa[120] = "It describes the type of the inner source sequence.";
245 this.aq[121] = "What is the main function of the predicates outerKeySelector and innerKeySelector within the ‘Join’ operator?";
246 this.aa[121] = "They define how to extract the identifying keys from the outer and inner source sequence items, respectively. These keys are both of type TKey, and their equivalence defines the join condition.";
247 this.aq[122] = "What is the main function of the resultSelector predicate within the ‘Join’ operator?";
248 this.aa[122] = "It defines what to project into the result sequence, which will be an implementation of IEnumerable<TResult>.";
249 this.aq[123] = "What is the main function of the TResult type in the ‘Join’ operator?";
250 this.aa[123] = "It defines the type of each single item in the join result sequence.";
251 this.aq[124] = "Example – ‘Join’ operator is used to map orders with products";
252 this.aa[124] = "var expr =\r\n customers\r\n .SelectMany(c => c.Orders)\r\n .Join( products,\r\n o => o.IdProduct,\r\n p => p.IdProduct,\r\n (o, p) => new {o.Month, o.Shipped, p.IdProduct, p.Price } );";
253 this.aq[125] = "In this query:\r\nvar expr =\r\n customers\r\n .SelectMany(c => c.Orders)\r\n .Join( products,\r\n o => o.IdProduct,\r\n p => p.IdProduct,\r\n (o, p) => new {o.Month, o.Shipped, p.IdProduct, p.Price } );";
254 this.aa[125] = "orders represents the outer sequence and products is the inner sequence. The o and p used in lambda expressions are of type Order and Product, respectively. Internally, the operator collects the elements of the inner sequence into a hash table, using their keys extracted with innerKeySelector. It then enumerates the outer sequence and maps its elements, based on the Key value extracted with outerKeySelector, to the hash table of items. Because of its implementation, the Join operator result sequence keeps the order of the outer sequence first, and then uses the order of the inner sequence for each outer sequence element. ";
255 this.aq[126] = "What is the main function of the ‘GroupingJoin’ operator?";
256 this.aa[126] = "It correlates the elements of two sequences based on key equality, and groups the results.";
257 this.aq[127] = "In a query expression, the ‘GroupJoin’ operator is defined as ...";
258 this.aa[127] = "join ... into ... clause";
259 this.aq[128] = "Set operators includes ...";
260 this.aa[128] = "Distinct, Union, Intersect, Except, and Zip operators.";
261 this.aq[129] = "What is the main function of the ‘Distinct’ operator?";
262 this.aa[129] = "It returns distinct elements from a sequence by using the default equality comparer to compare values. For example, we can extract all products that are mapped to orders, avoiding duplicates.";
263 this.aq[130] = "Signature of the ‘Distinct’ operator without comparer is ...";
264 this.aa[130] = "public static IEnumerable<TSource> Distinct<TSource>(\r\n this IEnumerable<TSource> source);";
265 this.aq[131] = "Signature of the ‘Distinct’ operator with comparer is ...";
266 this.aa[131] = "public static IEnumerable<TSource> Distinct<TSource>(\r\n this IEnumerable<TSource> source,\r\n IEqualityComparer<TSource> comparer);";
267 this.aq[132] = "What is the main function of the ‘Union’ operator?";
268 this.aa[132] = "It enumerates the first sequence and the second sequence in that order and yields each element that has not already been yielded.";
269 this.aq[133] = "What is the result of next query:\r\nInt32[] setOne = { 1, 5, 6, 9 };\r\nInt32[] setTwo = { 4, 5, 7, 11 };\r\nvar union = setOne.Union(setTwo);";
270 this.aa[133] = "1, 5, 6, 9, 4, 7, 11";
271 this.aq[134] = "What is the main function of the ‘Intersect’ operator?";
272 this.aa[134] = "It yields only the elements that occur in both sequences.";
273 this.aq[135] = "What is the main function of the ‘Except’ operator?";
274 this.aa[135] = "It yields all the elements in the first sequence that are not present in the second sequence.";
275 this.aq[136] = "What is the main function of the ‘Zip’ operator?";
276 this.aa[136] = "It merges each element of the first sequence with the corresponding element with the same index in the second sequence.";
277 this.aq[137] = "Signature of the ‘Zip’ operator with resultSelector is ...";
278 this.aa[137] = "public static IEnumerable<TResult> Zip<TFirst, TSecond, TResult>(\r\n this IEnumerable<TFirst> first,\r\n IEnumerable<TSecond> second,\r\n Func<TFirst, TSecond, TResult> resultSelector);";
279 this.aq[138] = "What is the result of the query:\r\nInt32[] numbers = { 1, 2, 3, 4, 5, 6, 7, 8, 9, 10 };\r\nDayOfWeek[] weekDays = {\r\n DayOfWeek.Sunday,\r\n DayOfWeek.Monday,\r\n DayOfWeek.Tuesday,\r\n DayOfWeek.Wednesday,\r\n DayOfWeek.Thursday,\r\n DayOfWeek.Friday,\r\n DayOfWeek.Saturday};\r\nvar weekDaysNumbers = numbers.Zip(weekDays,\r\n (first, second) => first + '' - '' + second);";
280 this.aa[138] = "1 - Sunday\r\n2 - Monday\r\n3 - Tuesday\r\n4 - Wednesday\r\n5 - Thursday\r\n6 - Friday\r\n7 - Saturday";
281 this.aq[139] = "Aggregate operators include ...";
282 this.aa[139] = "Count, LongCount, Sum, Min, Max, Average, Aggregate operators";
283 this.aq[140] = "The main function of aggregate operators are ...";
284 this.aa[140] = "They are aggregate sequences to make calculations on source items.";
285 this.aq[141] = "What does Enumerable class provide?";
286 this.aa[141] = "A set of static methods for querying objects that implement IEnumerable(Of T). T - the type of objects to enumerate. This type parameter is covariant.";
287 this.aq[142] = "What is the main function of the ‘Count’ operator?";
288 this.aa[142] = "It calculates items in the source sequence.";
289 this.aq[143] = "What is the difference between ‘Count’ ‘LongCount’ operators?";
290 this.aa[143] = "The second one returns a long instead of an integer.";
291 this.aq[144] = "What is the main function of the ‘Sum’ operator?";
292 this.aa[144] = "It computes the sum of numeric values in a sequence.";
293 this.aq[145] = "What are the Nullable types?";
294 this.aa[145] = "They are instances of the System.Nullable struct. This type can represent the normal range of values for its underlying value type, plus an additional null value.";
295 this.aq[146] = "What are the main functions of ‘Min’ and ‘Max’ operators?";
296 this.aa[146] = "They calculate the minimum and maximum values of the source sequence.";
297 this.aq[147] = "What is the main function of ‘Average’ operator?";
298 this.aa[147] = "It calculates the middle value of a set of values, extracted from a source sequence.";
299 this.aq[148] = "Generation operators include ...";
300 this.aa[148] = "Range, Repeat, Empty.";
301 this.aq[149] = "What is the main function of ‘generation’ operators?";
302 this.aa[149] = "To iterate over numbers or item collections.";
303 this.aq[150] = "What is the main function of ‘Range’ operator?";
304 this.aa[150] = "It yields a set of Integer numbers, selected within a specified limitations of values.";
305 this.aq[151] = "What is the main function of ‘Repeat’ operator?";
306 this.aa[151] = "It returns a set of count occurrences of element. When the element is an instance of a reference type, each recital returns a reference to the same instance, not a copy of it.";
307 this.aq[152] = "What is the main function of ‘Empty’ operator?";
308 this.aa[152] = "It is used to create an enumeration without data of a particular type TResult.";
309 this.aq[153] = "The operation ‘IEnumerable<Customer> customers = Enumerable.Empty<Customer>();’ define ...";
310 this.aa[153] = "An enumeration without data.";
311 this.aq[154] = "Quantifier operators are ...";
312 this.aa[154] = "Any, All, and Contains.";
313 this.aq[155] = "What is the main function of the ‘quantifier’ operators?";
314 this.aa[155] = "They are specifically designed to check for existence conditions over sequences.";
315 this.aq[156] = "What is the main function of ‘Any’ operator?";
316 this.aa[156] = "It returns true when at least one element in the source sequence exists or false if the source sequence is empty.";
317 this.aq[157] = "What is the main function of ‘All’ operator?";
318 this.aa[157] = "It returns a true result only if the condition is verified by all the elements in the source sequence.";
319 this.aq[158] = "What is the main function of ‘Contains’ operator?";
320 this.aa[158] = "It determines whether a source sequence contains a specific item value.";
321 this.aq[159] = "BPwin is ...";
322 this.aa[159] = "Fourth generation environment.";