>>>Hi,
>>>
>>>I want to implement a data-driven approach of defining properties of various CursorAdapter objects in my application. So I need to store the values of the column names, types, etc. etc. in meta table(s). I am considering 3 options for meta data:
>>>
>>>1. .DBF files (even though the application work with SQL Server database)
>>>2. XML files
>>>3. Table(s) in SQL Server.
>>>
>>>Which one of the above you (collectively) would use? TIA.
>>
>>If you're using SQL Server, this information is already available to use in various meta-tables (views)
>>
>>Say, you can check Information_Schema.Columns to get information about columns and you can look into extended properties to get descriptions of the fields (if you need to get this information too).
>
>I will look into this approach. Thank you.
Yes, it sounds like it will work nicely. You get the schema for particular table using
select * from Information_Schema.Columns where Table_Name = 'MyTable' and schema_name = 'dbo'
and then you construct your SelectCMD and other commands using that info.
But I bet that's what Mark's class is doing.
If it's not broken, fix it until it is.
My Blog