Yooper PASS

Next Meeting




June Meeting

  • In-Person @ 2235 Pewabic St. Iron Mountain, Michigan, United States (map)
  • 17:30 - 19:30 Central Daylight Time
  • Language: English

Come join us to hear Jay Robinson speak about exploring the System.Data.SqlClient namespace.

Featured Presentation:

SQL for Developers

Jay Robinson, Senior Systems Engineer Salesforce

Relational databases and the languages that are used to communicate with them require different expertise. Being well-versed in the declarative, set-based algebra of SQL does not imply a good understanding of the procedural, object-oriented languages like C# and Visual Basic that developers use to "talk" to SQL Server databases. Conversely, a "pure" developer's understanding of the .NET Framework can lead to solutions that fall down when faced with databases at scale. This session is a bridge over that gap. Focusing on several of the core elements of the .NET Framework that communicate with SQL Server, we will examine ways to get the most out of both paradigms. Demos will use C#, though the principles can be applied in any of the .NET languages. Selected Topics: - Connection pooling strategies - Nuances of the SqlDataReader class - Proper handling of SQL Server exceptions - Asynchronous calling methods - Effective use of the SqlBulkCopy class Following this session, attendees should be better prepared to develop scalable and reliable solutions that use the .NET Framework to communicate with SQL Server databases.

About Jay:
I write C# and T-SQL code that scales well. I teach others to do it. DBAs like me.



Sponsored By:

Back to Top