Search Unity

  1. Good news ✨ We have more Unite Now videos available for you to watch on-demand! Come check them out and ask our experts any questions!
    Dismiss Notice

Access data from Microsoft SQL server into Unity3d

Discussion in 'Getting Started' started by swapsshah, Jan 31, 2020.

  1. swapsshah

    swapsshah

    Joined:
    Jan 31, 2020
    Posts:
    1
    Dear Community,

    We have spent more than a couple of days on this have gone though almost all available threads online but nothing has worked so far.

    We are using Unity Version 2019.2.1 and using Visual Studio 2019 Community Edition.

    We have already tried the following-
    1. We have tried using Entity Framework Model using both ObjectContext and DataContext and in both ways the App.Config file and edmx file is lost when we reload the solution.
    2. We have also tried using legacy SqlConnection using System.Data and System.Data.SqlClient namespaces by copying the dlls into Plugins folder.

    We have checked and double checked all SQL server Configurations, ports, authentication, etc. and use SQL server on day to day basis for our other projects.

    Can someone please point to any working sample/ example/ video/ article on how to Access data from Microsoft SQL server into Unity3d?

    Thanks in Advance!

    Regards,
    Swapneel Shah
     
  2. Schneider21

    Schneider21

    Joined:
    Feb 6, 2014
    Posts:
    2,960
  3. crannnabethadh

    crannnabethadh

    Joined:
    Oct 19, 2019
    Posts:
    7
    Solution number 2 should work. Are you creating a class library for .NET Framework 4.X? And importing the dll's to Unity project by just dragging them to Assets subfolder, right?
     
unityunity