Author Topic: MSSql Server example  (Read 4852 times)

EduardoBan

  • Newbie
  • *
  • Posts: 6
    • View Profile
MSSql Server example
« on: September 04, 2016, 11:24:00 PM »
Good morning
I'm starting with AdvancedHMI, Need Help to an application that takes values in Modbus and serious in a MSSQL server, you send me some small example,...

Archie

  • Administrator
  • Hero Member
  • *****
  • Posts: 5322
    • View Profile
    • AdvancedHMI
Re: MSSql Server example
« Reply #1 on: September 04, 2016, 11:35:09 PM »
There are 2 primary methods of doing database work.... ADO.NET and Entity Framework

You can see an example of ADO.NET using the Visual Studio Tools near the end of this video:

https://www.youtube.com/watch?v=bk9oSONpDC4

Noe

  • Full Member
  • ***
  • Posts: 205
    • View Profile
Re: MSSql Server example
« Reply #2 on: September 05, 2016, 11:48:10 AM »
Archie, could you explain a little about the entity framework?

Archie

  • Administrator
  • Hero Member
  • *****
  • Posts: 5322
    • View Profile
    • AdvancedHMI
Re: MSSql Server example
« Reply #3 on: September 05, 2016, 07:34:48 PM »
The Entity framework is the newer model that Microsoft recommends for new application. It is very object oriented and a little more abstract which in my opinion makes it a little more difficult to understand, This video may help explain a bit more about it:

https://msdn.microsoft.com/en-us/data/jj590134

I have started creating a wiki page to give a walk-through, but I still have a bit more to go:

http://advancedhmi.com/documentation/index.php?title=Databases_Using_Entity_Framework

Noe

  • Full Member
  • ***
  • Posts: 205
    • View Profile
Re: MSSql Server example
« Reply #4 on: September 08, 2016, 11:21:37 AM »
Thanks Archie, I will read more about it.
... Just when I was starting to understand ADO  :-\

Mikefly95

  • Jr. Member
  • **
  • Posts: 80
    • View Profile
Re: MSSql Server example
« Reply #5 on: September 09, 2016, 08:18:07 AM »
I personally do not use either but this is the guy I use when learning new stuff.

https://www.youtube.com/watch?v=Z7713GBhi4k

He is a very good at breaking everything down into learnable bits.