none
Edit, update, delete it - SQL database - concept RRS feed

  • Question

  • Hello!

    Is there a page that shows what I need to install for Visual Studio 2017 C # to access a SQL database?
    I need SQL queries and also StoredProcedure queries.
    Edit, update, delete it.
    Connectionstring with, without password.

    The project starts in 4 weeks, I would like to know the details in advance.
    The customer then gives information about which database it will be.
    For me it would be important, which drivers I have to install in order to create queries.
     Which tools are useful.
     
     Google knows a lot, but not the details. I found this.
    -   MySQL
    I'm looking for a guideline about SQL databases.
    Just try and try what to install is the wrong way.

    Maybe I could define an interface, it does not matter which database the customer chooses.
    Maybe there are software concepts on net?

    Many Greetings Markus

    Wednesday, January 23, 2019 5:34 PM

Answers

  • Hi Markus Freitag,

    Thank you for postinghere.

    For MySQL, you could check the link below.

    https://www.c-sharpcorner.com/UploadFile/9582c9/insert-update-delete-display-data-in-mysql-using-C-Sharp/

    For SQL database, you could download the source file from the code project for refefrence.

    https://www.codeproject.com/Articles/274690/How-to-Add-Delete-Edit-Update-Image-and-Save-to-SQ

    Best Regards,

    Wendy


    MSDN Community Support
    Please remember to click "Mark as Answer" the responses that resolved your issue, and to click "Unmark as Answer" if not. This can be beneficial to other community members reading this thread. If you have any compliments or complaints to MSDN Support, feel free to contact MSDNFSF@microsoft.com.

    Thursday, January 24, 2019 6:32 AM
    Moderator
  • To install SQL-Server, use SQL-Server Express edition.

    To install MySql, see the following page.

    For a basic crash course in general SQL go to the following site. The following is subjective for guide lines, SQL Style Guide. Each database has their own flavor for stored procedures so it will depend on the project type to what is needed and if and when SP's are needed which falls back to your knowledge which four weeks may or may not be enough time to get  acquainted with stored procedures.

    In regards to add, edit, delete there are basics as per above but each database type has their own not nuances.

    Let's pick on SQL-Server via this MSDN code sample. For Oracle, MySql etc. they have a base but the syntax is different in regards to using parameters e.g. Access uses ordinal position via ?, SQL-Server uses named parameters e.g. @FirstName, Oracle :FirstName etc.

    Standard connection strings.

    Other things to consider, using a managed data provider, using Entity Framework (best option), data wizards in Visual Studio (worst option). To learn, manage provider then move to Entity Framework. 

    As DA924x said "there are no silver bullets". You must dig in someplace and start learning rather than evaluating which page to learn from. Each author will have their own unique way of explaining things so keep that in mind, look for a style that works for you.


    Please remember to mark the replies as answers if they help and unmark them if they provide no help, this will help others who are looking for solutions to the same or similar problem. Contact via my Twitter (Karen Payne) or Facebook (Karen Payne) via my MSDN profile but will not answer coding question on either.
    VB Forums - moderator
    profile for Karen Payne on Stack Exchange, a network of free, community-driven Q&A sites

    Thursday, January 24, 2019 12:13 AM
    Moderator
  • For me it would be important, which drivers I have to install in order to create queries.
     Which tools are useful.

    https://blog.bitsrc.io/what-is-an-orm-and-why-you-should-use-it-b2b6f75f5e2a

    https://docs.microsoft.com/en-us/dotnet/framework/data/adonet/ef/overview

    https://www.codeproject.com/Tips/426790/Using-MySQL-with-Entity-Frameworkhttp://www.entityframeworktutorial.net/entityframework6/create-entity-data-model.aspx

    The project starts in 4 weeks, I would like to know the details in advance.
    The customer then gives information about which database it will be.

    No, it is you that gives the advise one which one to use, and you should start on what product you can get professional advise on and support when needed.

    For me, that would be MS or Oracle.  Oracle is the Rolls Royce of relational databases. and MS SQL Server is not too far behind, but it is not Oracle. 

    And you would start by installing the Express version of Oracle or MS SQL Server on a workstation  Windows O/S and start programming against it before moving towards a server version that would be installed a Windows server O/S.

    MySQL wouldn't even be in the picture for an enterprise level solution as far as I am concerned.

    https://social.msdn.microsoft.com/Forums/sqlserver/en-US/home?category=sqlserver

    https://social.msdn.microsoft.com/Forums/sqlserver/en-us/home?forum=sqlexpress

    If somehow, the client chooses MySQL is becuase they are cheap bastards, and they are not going to pay you well. 

    BTW.....

    https://www.advaiya.com/blog/how-to-integrate-entity-framework-with-oracle/

    Thursday, January 24, 2019 8:59 AM

All replies

  • I'm looking for a guideline about SQL databases.

    There are no guidelines, a sliver bullet. You pick one,  and you learn how to program against it and administer it from a software developer's standpoint.


    Wednesday, January 23, 2019 7:30 PM
  • To install SQL-Server, use SQL-Server Express edition.

    To install MySql, see the following page.

    For a basic crash course in general SQL go to the following site. The following is subjective for guide lines, SQL Style Guide. Each database has their own flavor for stored procedures so it will depend on the project type to what is needed and if and when SP's are needed which falls back to your knowledge which four weeks may or may not be enough time to get  acquainted with stored procedures.

    In regards to add, edit, delete there are basics as per above but each database type has their own not nuances.

    Let's pick on SQL-Server via this MSDN code sample. For Oracle, MySql etc. they have a base but the syntax is different in regards to using parameters e.g. Access uses ordinal position via ?, SQL-Server uses named parameters e.g. @FirstName, Oracle :FirstName etc.

    Standard connection strings.

    Other things to consider, using a managed data provider, using Entity Framework (best option), data wizards in Visual Studio (worst option). To learn, manage provider then move to Entity Framework. 

    As DA924x said "there are no silver bullets". You must dig in someplace and start learning rather than evaluating which page to learn from. Each author will have their own unique way of explaining things so keep that in mind, look for a style that works for you.


    Please remember to mark the replies as answers if they help and unmark them if they provide no help, this will help others who are looking for solutions to the same or similar problem. Contact via my Twitter (Karen Payne) or Facebook (Karen Payne) via my MSDN profile but will not answer coding question on either.
    VB Forums - moderator
    profile for Karen Payne on Stack Exchange, a network of free, community-driven Q&A sites

    Thursday, January 24, 2019 12:13 AM
    Moderator
  • Hi Markus Freitag,

    Thank you for postinghere.

    For MySQL, you could check the link below.

    https://www.c-sharpcorner.com/UploadFile/9582c9/insert-update-delete-display-data-in-mysql-using-C-Sharp/

    For SQL database, you could download the source file from the code project for refefrence.

    https://www.codeproject.com/Articles/274690/How-to-Add-Delete-Edit-Update-Image-and-Save-to-SQ

    Best Regards,

    Wendy


    MSDN Community Support
    Please remember to click "Mark as Answer" the responses that resolved your issue, and to click "Unmark as Answer" if not. This can be beneficial to other community members reading this thread. If you have any compliments or complaints to MSDN Support, feel free to contact MSDNFSF@microsoft.com.

    Thursday, January 24, 2019 6:32 AM
    Moderator
  • For me it would be important, which drivers I have to install in order to create queries.
     Which tools are useful.

    https://blog.bitsrc.io/what-is-an-orm-and-why-you-should-use-it-b2b6f75f5e2a

    https://docs.microsoft.com/en-us/dotnet/framework/data/adonet/ef/overview

    https://www.codeproject.com/Tips/426790/Using-MySQL-with-Entity-Frameworkhttp://www.entityframeworktutorial.net/entityframework6/create-entity-data-model.aspx

    The project starts in 4 weeks, I would like to know the details in advance.
    The customer then gives information about which database it will be.

    No, it is you that gives the advise one which one to use, and you should start on what product you can get professional advise on and support when needed.

    For me, that would be MS or Oracle.  Oracle is the Rolls Royce of relational databases. and MS SQL Server is not too far behind, but it is not Oracle. 

    And you would start by installing the Express version of Oracle or MS SQL Server on a workstation  Windows O/S and start programming against it before moving towards a server version that would be installed a Windows server O/S.

    MySQL wouldn't even be in the picture for an enterprise level solution as far as I am concerned.

    https://social.msdn.microsoft.com/Forums/sqlserver/en-US/home?category=sqlserver

    https://social.msdn.microsoft.com/Forums/sqlserver/en-us/home?forum=sqlexpress

    If somehow, the client chooses MySQL is becuase they are cheap bastards, and they are not going to pay you well. 

    BTW.....

    https://www.advaiya.com/blog/how-to-integrate-entity-framework-with-oracle/

    Thursday, January 24, 2019 8:59 AM