Creating table in Oracle using visual studio c#

Question

I have been searching and i could not find it still. Can i know is there any reference that show on how to create a table using c# in visual studio for oracle databse. This means that using visual studio c# to create the table for Oracle insted doing it in the sqldeveloper using SQL statement.

mybirthname · Accepted Answer · 2016-02-12 17:34:23Z

4

using (OracleConnection con = new OracleConnection("user id=You;password=Pass;data source=DB"))
{
    con.Open();
    using (OracleCommand cmd = new OracleCommand("create table YourTableName(ID number)", con))
    {
        cmd.ExecuteNonQuery();
    }
}

Something like this.

answered Feb 12, 2016 at 17:34

mybirthname

18.2k3 gold badges35 silver badges59 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Jayam Koko Over a year ago

sir, you are great, i just it and working. Edi the table name and other things i think i can do already as i got this idea. Sir thanks again. Thanks so much sir.

Collectives™ on Stack Overflow

Creating table in Oracle using visual studio c#

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related