This question is locked. New answers and comments are not allowed.
After using OpenAccess in the Database-first scenario for a while, I decided to try Code-only for my new project, and faced a lot of trouble just getting started.
One of these problems had to do with the name of the database to be generated. I initially named it with the domain name of the site it'll eventually become, but using a name with periods (Database=sub.somesite.tld) did not go so well. At first, it couldn't generate the database at all, failing with an SQL syntax error. Adding brackets around the name in the connection string (Database=[sub.somesite.tld]) fixed that and allowed the DB to be created, but this conn-string failed when OA tried to log in to the newly created DB, and "schemaHandler.DatabaseExists()" reported false even though the DB was clearly present on the server.
I've got it running by replacing the periods in the name with underscores (Database=sub_somesite_tld) but I'm still interested in knowing if there's some way you can use a database with periods in the name with Telerik Data Access in the Code-only scenario.
We use SQL Express 2012 on dev and SQL Server 2008/2012 Web Edition on the live servers.
One of these problems had to do with the name of the database to be generated. I initially named it with the domain name of the site it'll eventually become, but using a name with periods (Database=sub.somesite.tld) did not go so well. At first, it couldn't generate the database at all, failing with an SQL syntax error. Adding brackets around the name in the connection string (Database=[sub.somesite.tld]) fixed that and allowed the DB to be created, but this conn-string failed when OA tried to log in to the newly created DB, and "schemaHandler.DatabaseExists()" reported false even though the DB was clearly present on the server.
I've got it running by replacing the periods in the name with underscores (Database=sub_somesite_tld) but I'm still interested in knowing if there's some way you can use a database with periods in the name with Telerik Data Access in the Code-only scenario.
We use SQL Express 2012 on dev and SQL Server 2008/2012 Web Edition on the live servers.