syscomments is deprecated/not available on Azure SQL Database

DatabaseSchemaReader.ProviderSchemaReaders.SqlServerSchemaReader.Triggers() uses syscomments to enumerate the contents of the triggers. syscomments is deprecated (and not supported at all in Azure...

Id #1432 | Release: v1.3.5.0 | Updated: Aug 6 at 1:31 PM by Martinjw | Created: Jul 29 at 10:07 AM by jamesholwell

No data read on Oracle provider

I am attempting to get "insert statments" for oracle tables and get empty data. Just debug the code and found out that the problem is with the paging, when I change the sql and remove the paging ...

Id #1431 | Release: None | Updated: Jul 29 at 2:56 PM by ipappous | Created: Jul 29 at 9:48 AM by ipappous

Multiple tables with same name.

If I have multiple tables with the same name, and use an SqlWriter to generate a Select All-query for one of them, the query will select all columns from both of the tables. Even though they have d...

Id #1429 | Release: v1.3.5.0 | Updated: Aug 6 at 1:32 PM by Martinjw | Created: Jul 27 at 1:38 PM by torbonde

Create View statement duplicated

I found an issue where commented out code that appeared above the Create View statement caused a duplicated Create View statement to be created. I was able to work around it by removing the commen...

Id #1401 | Release: None | Updated: May 14 at 9:02 PM by Twerthi | Created: May 14 at 9:02 PM by Twerthi

SchemaCompare: changing PK is written wrong

Hi, I have a DB table, with a PK "kep" (integer). I have a table in memory, same name, also with integer column "kep", but with another column "kep2" which shall be the primary key (instead of "ke...

Id #1332 | Release: v1.3.1.0 | Updated: Mar 1 at 6:02 PM by Martinjw | Created: Jan 10 at 8:22 AM by mausomaS

Generate SQL INSERT for a DataRow

make public function WriteInsert /// <summary> /// Writes then SQL INSERT of then DataRow /// </summary> /// <param name="row">DataRow</param> /// <returns>SQL INSERT CODE</returns> public string ...

Id #1143 | Release: v1.2.7.0 | Updated: Jun 14, 2013 at 7:10 AM by Martinjw | Created: Mar 1, 2013 at 3:09 PM by rountraore

Non compilating generated Pocos

Revision 24163 Here is the creation script in the database create table vehicule ( regnum varchar(25) primary key, manufacturer varchar(32) , model varchar(32) ); create table car ( ...

Id #1121 | Release: v1.2.7.0 | Updated: Jun 14, 2013 at 7:10 AM by Martinjw | Created: Feb 12, 2013 at 11:47 AM by softisis

Add object filter to schema reader

Enable limit objects reading from database like object start with and end with...

Id #1098 | Release: v1.2.6.0 | Updated: Jun 14, 2013 at 7:10 AM by Martinjw | Created: Nov 18, 2012 at 5:20 AM by thangtx

Add object filter to schema reader

Enable limit objects reading from database like object start with and end with...

Id #1097 | Release: v1.2.6.0 | Updated: Jun 14, 2013 at 7:10 AM by Martinjw | Created: Nov 18, 2012 at 5:16 AM by thangtx

  • 1-9 of 9 Work Items
    • Previous
    • 1
    • Next
    • Showing
    • All
    • Work Items