Azavea.Open.DAO.SQL.SqlDaDdlLayer.CreateStoreRoom C# (CSharp) Method

        public virtual void CreateStoreRoom(ClassMapping mapping)
        {
            StringBuilder sb = DbCaches.StringBuilders.Get();
            sb.Append("CREATE TABLE ").Append(mapping.Table).Append("(");
            string separator = "";
            IList<string> extraStatements = new List<string>();
            foreach (string col in mapping.AllDataColsInOrder)
            {
                if (AddColDefinition(sb, col, mapping,
                    separator, extraStatements))
                {
                    separator = ",";
                }
            }
            sb.Append(")");
            SqlConnectionUtilities.XSafeCommand(_connDesc, sb.ToString(), null);
            foreach (string statement in extraStatements)
            {
                SqlConnectionUtilities.XSafeCommand(_connDesc, statement, null);
            }
            DbCaches.StringBuilders.Return(sb);
        }