C#

Bruce Coward wrote:

Can anyone point this comparative newbie in the right direction with a simple example based on the data in my first email please?

Bruce Coward wrote:

My problem is lifting the data up into a structure or class

namespace ConsoleApplication7
{
    class Program
    {
        class csFPRec
        {
            public UInt32 uiPGN;
            public UInt32 uiFrameCtr;
        }
        
        static void Main(string[] args)
        {
            // Instantiate Class
            csFPRec FPRec = new csFPRec();
            Hashtable HT = new Hashtable();
 
            Console.WriteLine("Writing Initial Records");
            
            Console.WriteLine("Writing 0x1234");
            FPRec.uiPGN = 0x1234;
            FPRec.uiFrameCtr = 0x01;
            HT.Add(FPRec.uiPGN, FPRec);
            
            Console.WriteLine("Writing 0x5678");
            FPRec.uiPGN = 0x5678;
            FPRec.uiFrameCtr = 0x02;
            HT.Add(FPRec.uiPGN, FPRec);
            
            Console.WriteLine();
            Console.WriteLine("Reading Records");

            // Get record back from Hashtable
            object pgnobj = new object();
            pgnobj = HT[0x1234];


            Console.ReadLine();
        }
    }
}

....
FPRec = new csFPRec();
FPRec.uiPGN = 0x5678;
FPRec.uiFrameCtr = 0x02;
...

...
pgnobj = HT[(UInt32)0x1234];
...

public DeviceData(int Type, object Device)

if (device is Recloser)
    dev = (Recloser)Device;

Saksida Bojan wrote:

Where is return Type? This is function and if you do not want to have return type, use void

OSDev

case 5:
    LTC dev = new LTC();
    dev = (LTC)Device;
    break;

case 5:
{
    LTC dev = new LTC();
    dev = (LTC)Device;
    break;
}

Roger Wright wrote:

public int GetDevice(dev)

OSDev

Recloser dev = new Recloser();
dev = (Recloser)Device;

Recloser dev = (Recloser)Device;

public DeviceData(Recloser device)
{
    dev = device;
}

• Relations between tables e.g. delete from table A, but this breaks a FK constraint to table B, or you have an property that is itself a of a type you persit: you need to persist in the correct order and make sure that the owner object has a PK /FK relationship to the child object, and the OK of the child object must be defined.
• Null handling
• Default Value handling
• Defining primary keys on tables
• Conversion from object property type to DB cloumn types and exceptional cases were the standard conversion is insufficient
• Inheritence Problems (how do you represent an inheritance hierearchy in the DB, Table per sublcass, table per hierarchy etc).