Luis Felipe de Oliveira luisdeol

🎯

Focusing

Senior .NET Developer, Instructor and Consultant, 4x Microsoft MVP, 10x Microsoft Certified, 1x AWS Certified.

luisdeol / Program.cs

Last active July 8, 2020 00:04

4.2: Inserting, Updating and Deleting data.

	using System;
	using System.Data.SqlClient;

	namespace _42_ConsumeData
	{
	class Program
	{
	static void Main(string[] args)
	{
	const string connectionString = "Server=LAPTOP-201QPF8A\\SQLEXPRESS;Database=EcommerceDb;Trusted_Connection=true";

luisdeol / Program.cs

Created July 7, 2020 23:37

4.2: Connecting and Retrieving data from SQL Server.

	using System;
	using System.Data.SqlClient;

	namespace _42_ConsumeData
	{
	class Program
	{
	static void Main(string[] args)
	{
	const string connectionString = "Server=LAPTOP-201QPF8A\\SQLEXPRESS;Database=EcommerceDb;Trusted_Connection=true";

luisdeol / 42_create_insert_scripts.sql

Created July 7, 2020 23:20

42: Creating Product and inserting some seed data.

	CREATE DATABASE EcommerceDb

	USE EcommerceDb
	GO

	CREATE TABLE Product (
	Id INT IDENTITY(1,1) PRIMARY KEY ,
	Description VARCHAR(250),
	Quantity INT,
	Price NUMERIC(5,2)

luisdeol / Program.cs

Created June 24, 2020 00:58

4.1: Async HTTP communication with JsonPlaceholder.

	using System;
	using System.Net.Http;
	using System.Threading.Tasks;

	namespace ImplementDataAccess._41_PerformIoOperations
	{
	class Program
	{
	static async Task Main(string[] args)
	{

luisdeol / Program.cs

Created June 24, 2020 00:49

4.1: Communication over the network

	using System;
	using System.IO;
	using System.Net;

	namespace ImplementDataAccess._41_PerformIoOperations
	{
	class Program
	{
	static void Main(string[] args)
	{

luisdeol / Program.cs

Created June 24, 2020 00:26

4.2: Streams

	using System;
	using System.IO;
	using System.IO.Compression;
	using System.Linq;
	using System.Text;

	namespace ImplementDataAccess._41_PerformIoOperations
	{
	class Program
	{

luisdeol / Program.cs

Created June 23, 2020 22:40

4.1: Writing and read data from a file by using StreamWriter and StreamReader.

	using System;
	using System.IO;

	namespace ImplementDataAccess._41_PerformIoOperations
	{
	class Program
	{
	static void Main(string[] args)
	{
	var myNewFile = @"../../Directory/file_6.txt";

luisdeol / Program.cs

Created June 23, 2020 12:29

4.1: Creating, Retrieving information and deleting a file.

	using System;
	using System.IO;

	namespace ImplementDataAccess._41_PerformIoOperations
	{
	class Program
	{
	static void Main(string[] args)
	{
	var myFile = @"../../Directory/file_5.txt";

luisdeol / Program.cs

Created June 17, 2020 11:14

4.1: Listing directories and using wildcards.

	using System;
	using System.IO;

	namespace ImplementDataAccess._41_PerformIoOperations
	{
	class Program
	{
	static void Main(string[] args)
	{
	var myDirectory = @"../../Directory";

luisdeol / Program.cs

Created June 17, 2020 10:27

4.1: Creating, Moving and Deleting a Directory.

	using System;
	using System.IO;

	namespace ImplementDataAccess._41_PerformIoOperations
	{
	class Program
	{
	static void Main(string[] args)
	{
	var myDirectoryName = "directory";