AdvancedHMI Software

General Category => Application Showcase => Topic started by: EduardoBan on September 04, 2016, 11:24:00 PM

Title: MSSql Server example
Post by: EduardoBan 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,...

Title: Re: MSSql Server example
Post by: Archie 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

Title: Re: MSSql Server example
Post by: Noe on September 05, 2016, 11:48:10 AM

Archie, could you explain a little about the entity framework?

Title: Re: MSSql Server example
Post by: Archie 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

Title: Re: MSSql Server example
Post by: Noe on September 08, 2016, 11:21:37 AM

Thanks Archie, I will read more about it.
... Just when I was starting to understand ADO  :-\

Title: Re: MSSql Server example
Post by: Mikefly95 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.