Page 1 of 1
How to define tablespaces via Code-First?
Posted: Wed 11 Feb 2015 13:55
by nurhat.uca
Thankfully, Devart supports defining tablespaces for both tables and indexes via customizing scaffolded migration scripts with using the following way;
Code: Select all
CreateTable(
"dbo.table",
c => new
{
...,
anonymousArguments: new CreateTableConfiguration()
{
Tablespace = "MY_TABLE_SPACE"
})
But, customizing auto generated script is not the best approach(at least for my case) , I want to know whether it is possible to define such configurations with using code first approach or not?
Regards,
Re: How to define tablespaces via Code-First?
Posted: Fri 13 Feb 2015 14:02
by Shalex
There is no way to specify a tablespace using Code-First Approach at the moment. We will investigate the question and notify you about the result.
Please specify the name of the dotConnect product you are working with.
Re: How to define tablespaces via Code-First?
Posted: Thu 05 Mar 2015 14:19
by Shalex
The config.DatabaseScript.Table.Tablespace configuration option is added to specify the tablespace for tables created via the Code-First approach. We will notify you when the corresponding build of dotConnect for Oracle is available for download.
Re: How to define tablespaces via Code-First?
Posted: Thu 26 Mar 2015 17:12
by Shalex
New build of dotConnect for Oracle 8.4.379 is available for download!
It can be downloaded from
http://www.devart.com/dotconnect/oracle/download.html (trial version) or from Registered Users' Area (for users with active subscription only).
For more information, please refer to
http://forums.devart.com/viewtopic.php?f=1&t=31498.
Re: How to define tablespaces via Code-First?
Posted: Tue 31 Mar 2015 13:20
by nurhat.uca
Appreciated for the quick implementation of that feature. I just downloaded and tried the solution, it works like a charm. Additionally, I think it will be better if you provide tablespace configurations also for index & long column types(CLOB,BLOB, etc) as you already implemented it for DB2( see the link below).
https://www.devart.com/dotconnect/db2/d ... ation.html
TableTablespace - set the name of the tablespace for the created tables.
IndexTablespace - set the name of the tablespace for the created indexes.
LongTablespace - set the name of the tablespace for the long columns. They include the columns with LOB data types, XML type, distinct types with any of these as source types, or any columns defined with user-defined structured types whose values cannot be stored inline.
Best Regards,
Nurhat
Re: How to define tablespaces via Code-First?
Posted: Wed 01 Apr 2015 14:24
by Shalex
Thank you for your suggestion. We will invetigate the question and notify you about the result.
Re: How to define tablespaces via Code-First?
Posted: Tue 05 May 2015 07:05
by Shalex
The config.DatabaseScript.Index.Tablespace configuration option is added to specify the tablespace for indexes created via the Code-First approach. We will notify you when the corresponding build of dotConnect for Oracle is available for download.
Re: How to define tablespaces via Code-First?
Posted: Thu 07 May 2015 13:11
by Shalex
The new build of dotConnect for Oracle 8.4.407 is available for download now:
http://forums.devart.com/viewtopic.php?f=1&t=31743. Please try it and notify us about the result.