❔ ✅ Use Reflection or Generics to specify one or more properties

I'm writing something that will automatically create a table and fill it with data based on the properties of a generic object. It's for unit testing, to be built and blown away when finished, so I don't need a heavy-duty framework like EF Core. Hopefully the code below makes sense, without all the details. I'm just looping through the properties and building Create Table and Insert sql statements.

    public class Table<T> {
        public string GetSql_CreateTable() {
            var sql = new StringBuilder();
            foreach (var prop in typeof(T).GetProperties()) {
                // generate create table sql
            }
            return sql.ToString();
        }

        public string Fill(List<T> rows) {
            var sql = new StringBuilder();
            // generate insert sql
            return sql.ToString();
        }
    }

    public class Table<T> {
        public string GetSql_CreateTable() {
            var sql = new StringBuilder();
            foreach (var prop in typeof(T).GetProperties()) {
                // generate create table sql
            }
            return sql.ToString();
        }

        public string Fill(List<T> rows) {
            var sql = new StringBuilder();
            // generate insert sql
            return sql.ToString();
        }
    }

Where I'm stuck is how to specify one or more properties of the generic object to be part of a primary key. I'm not sure syntatically how to say, "use these properties for primary key". Any help would be appreciated!

    public class Table<T> {
        public string GetSql_CreateTable() {
            var sql = new StringBuilder();
            foreach (var prop in typeof(T).GetProperties()) {
                // generate create table sql
            }
            return sql.ToString();
        }

        public string Fill(List<T> rows) {
            var sql = new StringBuilder();
            // generate insert sql
            return sql.ToString();
        }
    }

    public class Table<T> {
        public string GetSql_CreateTable() {
            var sql = new StringBuilder();
            foreach (var prop in typeof(T).GetProperties()) {
                // generate create table sql
            }
            return sql.ToString();
        }

        public string Fill(List<T> rows) {
            var sql = new StringBuilder();
            // generate insert sql
            return sql.ToString();
        }
    }

❔ ✅ Use Reflection or Generics to specify one or more properties

Similar Threads

❔ ✅ Use Reflection or Generics to specify one or more properties

Similar Threads

Similar Threads

Similar Threads