I love Orchard and I have high hopes for using it within my organization. However, I may be up against a hard stop to using it.
I have a small Orchard site we developed in which the performance needed improvement. I had read on a couple of posts that there was a performance boost when migrating the database from sdf to sql server. I also was concerned with PCI compliance if
we were to develop more robust applications with Orchard that required (at least) a full sql server database behind a firewall.
I was able to migrate to SQLEXPRESS successfully. I actually had run into some problems doing another migration with an Orchard site that contained the Featured Item Slider (but I digress). I then imported all the tables from the EXPRESS
database into a full Sql Server database on a server behind our firewall. The Orchard site loaded like a charm and the performance improvement was immediately noticable. However, when we tried to submit a custom registration page using a submit
button, it failed with the following error:
"OOPS. Something went wrong sorry. An unhandled exception has occurred..." It had to do with an insert into the "[OurSite].dbo.Orchard_Framework_ContentItemRecord". The error was "Cannot insert the value NULL into the
column "Id". It also mentioned "select SCOPE_IDENT" in the message.
This had worked successfully with the both the sdf and SQLEXPRESS versions. I also generated this error running against full Sql Server locally. Did I not migrate from express to full sql server properly? If we cannot use a full sql server database,
it will be a show stopper for us and Orchard CMS.