Article Category: Stored Procedures | CODE Magazine

Create Your Own SQL Compare Utility Using GetSchema()

By: Paul D. Sheriff

Last updated: Friday, February 24, 2023

Published in: CODE Magazine: 2023 - March/April

Learn how to use the GetSchema() method on the DbConnection class to retrieve tables, views, columns, index, stored procedures, and more from any database system. Create an instance of the SqlConnection or OracleConnection, or your own provider's implementation of the DbConnection class, and pass a valid connection string to the constructor to use the GetSchema() method.
The Rich Set of Data Annotation and Validation Attributes in .NET

By: Paul D. Sheriff

Last updated: Wednesday, January 18, 2023

Published in: CODE Magazine: 2023 - January/February

Paul teachs how to use many of the data annotations available in .NET; likely the ones you will use most often. Plus he shows you how to build custom validation attributes using the [CustomValidation] attribute. Finally, learn to localize error messages using resource files.
Calling Stored Procedures with the Entity Framework in .NET 5

By: Paul D. Sheriff

Last updated: Wednesday, August 31, 2022

Published in: CODE Magazine: 2021 - January/February

Paul shows you how to avoid the frustration of having to determine a stored procedure’s function before you call it by using Entity Framework in .NET 5. Learn how to make calls to stored procedures using Entity Framework in .NET 5.x.