C#

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).

Roger Wright wrote:

interfere with our drinking

Roger Wright wrote:

a working data management program in my free time at home.

Som Shekhar wrote:

Any logic already existing?

Som Shekhar wrote:

Any approaches?

Saksida Bojan wrote:

AFAIK

Dictionary<int, int> objCount;<br />
int num; //This is your number received as input<br />
if (objCount.ContainsKey(num))<br />
{<br />
    objCount[num]++;<br />
}<br />
else<br />
{<br />
    objCount.Add(num, 1);<br />
}

// can count numbers from 0 - 99<br />
int[] myNumberCounter = new int[100]; <br />
<br />
myNumberCounter[12]++;<br />
myNumberCounter[2]++;<br />
myNumberCounter[19]++;<br />
// etc, etc.

var list = new int[] { 1, 2, 7, 8, 3, 5, 8, 8 };
		
var query = from i in list
	    group i by i into grp
	    select new 
            {
                Number = grp.Key,
                Count = grp.Count()
            };
var counts = query.ToDictionary(t => t.Number, t => t.Count);