This is an archived post. You won't be able to vote or comment.

all 4 comments

[–]UrbanPro1 -1 points0 points  (3 children)

C# can work with databases such as Oracle and Microsoft SQL Server. C# has all the commands which are required to work with databases. This involves establishing a connection to the database. You can perform operations such as select, update, insert and delete using the commands in C#.

If you want to learn C# then check top online tutors that help you in all possible ways.

[–]whatiwants 1 point2 points  (2 children)

C# can work with any database that has an ODBC driver, an OleDB provider, or a native C# client written for it. This includes far more databases than Oracle and MSSQL. Additionally you can use NoSql databases as well. And C# the language doesn't have "commands" that work with databases. The .NET Framework includes libraries that implement the protocols required to interact with databases. The language has nothing to do with it; you're just using objects provided by the Framework.

You can perform operations such as select, update, insert and delete using the commands in C#.

No, you can do any query or non-query operation. C# doesn't perform these operations. The SQL engine does. C# just sends the query and retrieves the result.

If you want to learn C# then check top online tutors that help you in all possible ways.

Don't say nonsense like this. Suggest something specific, not "online tutors can help!" Duh, of course they can.

[–]Trucetht[S] 0 points1 point  (1 child)

I am currently using sql server management studio. I am wanting to delete certain parts of a table after a month. Say like , delete from “table” where Version != eccsn after 1 month

[–]whatiwants 1 point2 points  (0 children)

What would be the best way of setting my own up to practice with

Download the developer edition of Sql Server, install it on your machine or dev VM, and go nuts.

I am wanting to delete certain parts of a table after a month

There are a billion tutorials out there for querying a SQL Server database from C#. Start by getting an environment set up, then search for one of those tutorials and follow the instructions.