DIR Return Create A Forum - Home
       ---------------------------------------------------------
       MARii
  HTML https://marii.createaforum.com
       ---------------------------------------------------------
       *****************************************************
   DIR Return to: General Discussion
       *****************************************************
       #Post#: 18--------------------------------------------------
        Implementing on Memory Collections Programming 
       By: asim roy Date: September 14, 2023, 5:54 am
       ---------------------------------------------------------
       In , the operator is used to get data from two or more tables
       based on a common column. In , this concept is further extended
       to collections in addition to database tables. Languages Top
       Course The join operator can be used with two or more
       collections that implement an or interface. These collections
       can be simple arrays, general lists, dictionaries, or hash
       tables. By default, the query performs an inner join on the two
       collections. In the following example, there are two classes and
       . For example, in a clinic or hospital, a patient can have many
       test reports.
       The structure of these two classes is as follows Patient class
       public public string first name public string last name public
       integer age public patient, string, string, age the age test
       report Phone Number List
  HTML https://b2bphonelist.com/
       class public public string test type
       public string remark public patient string test string remark
       this test remark the patient type and the relationship between
       the types are specified by the type's fields. Suppose there are
       two arrays of type and , and these arrays hold multiple
       instances of these types, as follows patients patient new
       patient new patient  , james, milner, , new patient, chris,
       foster , new patient , mikkel, obi, new patient  , tania, gray,
       , new new test report  , blood, fit, , new test report  , ray,
       Suitable for, , Urine is not suitable for the new test report ,
       AIDS, Health,  The patient array contains four patients and the
       test report array contains four test reports.
       [img]
  HTML https://github.com/mdsakib0012/image/blob/main/phone%20number.png?raw=true[/img]
  HTML https://b2bphonelist.com/
       Now, to get records from both collections at the same time, you
       can use operator. For example, to get the names of all patients
       who have any test report, as well as the name of the test type
       and the doctor's comments, you can use the following query
       select new from patients will be added to the test report equal
       to this query represents, from Of all the patient types in the
       patients collection, join those types in the collection where
       the fields of type are equal to the fields of type.
       *****************************************************