public void Create() { Folder = new TempFolder(); Db = new PetaPoco.Database(ConnectionString, "SqlServer"); var columns = new List <string>(); foreach (var property in typeof(T).GetProperties()) { var dbType = ""; var type = property.PropertyType; if (type == typeof(int)) { dbType = "INT NOT NULL"; } else if (type == typeof(string)) { dbType = "NVARCHAR(MAX) NULL"; } columns.Add($"{property.Name} {dbType}"); } Db.Execute($"CREATE TABLE [{typeof(T).Name}]({string.Join(", ", columns)})"); }
public TempFile(TempFolder folder) { File = Guid.NewGuid().ToString(); }