using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
//Erforderliche Class hinzufügen
using System.Data;
using System.Data.SqlClient;

namespace ConsoleApp2
{
    class Program
    {
        static void Main(string[] args)
        {
            //Variablen deklarieren
            string connectionDetails;
            SqlConnection connection;

            //Verbindungsstring setzen
            connectionDetails = @"Data Source=localhost;Initial Catalog=testdb;User ID=sa;Password=testpw";

            //Verbindung zuweisen
            connection = new SqlConnection(connectionDetails);

            //Verbindung öffnen
            connection.Open();
            Console.WriteLine("Connection open");

            //Variablen deklarieren
            SqlCommand command;
            SqlDataReader dataReader;
            String sql, Output = "";

            //SQL-Befehl definieren
            sql = "SELECT * FROM Geraet;";

            //Befehl erzeugen
            command = new SqlCommand(sql, connection);

            //DataReader initialisieren
            dataReader = command.ExecuteReader();

            //Werte der Tabellen auslesen
            while (dataReader.Read())
            {
                Output = Output + dataReader.GetValue(0) + " " + dataReader.GetValue(1) + "\n";
            }

            //Ausgabe schreiben
            Console.WriteLine(Output);

            //Befehl ausführen
            SqlCommand command2;
            SqlDataAdapter adapter = new SqlDataAdapter();

            String geraetID = "345";
            String geraetName = "Drucker";

            //Gerät aus Strings in Tabelle Geraet einfügen
            String sql2="INSERT into Geraet (geraetID,typ) VALUES ('" + geraetID + "', '" + geraetName +"');";

            command2 = new SqlCommand(sql2, connection);

            adapter.InsertCommand = new SqlCommand(sql, connection);
            adapter.InsertCommand.ExecuteNonQuery();

            command2.Dispose();

            //Verbindung schließen
            connection.Close();

            Console.ReadLine();
        }
    }
}