Site Sections
Posts
400
Comments
213
Trackbacks
0
June 2010 Entries
Constructor via Reflection kopieren

Kann man vielleicht mal wieder brauchen: Constructor via Reflection kopieren

//copy constructor

public ClassName(Testclass testclass)

{

FieldInfo[] lFields = this.GetType().GetFields(BindingFlags.NonPublic

            | BindingFlags.Public | BindingFlags.Instance);

 

foreach (FieldInfo fi in lFields)

            fi.SetValue(this, fi.GetValue(testclass));

}

posted @ Wednesday, June 23, 2010 6:53 AM | Feedback (0)
Fun mit SQL: herausfinden welche foreign keys auf eine Tabelle verweisen

Per SQL anzeigen von welchen anderen Tabellen ein FK-Constraint auf eine gegebene Tabelle weist:

DECLARE @tabelle nvarchar(100)
set @tabelle = "TabellennName"

select object_name(fkeyid) Child_Table, object_name(constid) FKey_Name, c1.name FKey_Col,object_name(rkeyid) Parent_Table, c2.name Ref_KeyCol
from sysforeignkeys s
inner join syscolumns c1 on ( s.fkeyid = c1.id and s.fkey = c1.colid )
inner join syscolumns c2 on ( s.rkeyid = c2.id and s.rkey = c2.colid )
where object_name(rkeyid)='TabellenName'
order by 1,2,4

posted @ Wednesday, June 16, 2010 8:34 PM | Feedback (0)
Archives
Post Categories
test