you can find a good explanation with working example here http://csharpalley.com/create-sql-se...ed-properties/