Untitled
using System; using System.Data; using System.Text.RegularExpressions; using Dapper; using Microsoft.Data.SqlClient; using System.Collections.Generic; using System.Linq; using System.Numerics; using HelloWorld.Models; using HelloWorld.Data; using Microsoft.Extensions.Configuration; using Microsoft.EntityFrameworkCore; namespace HelloWorld{ internal class Program { static void Main(string[] args){ IConfiguration config = new ConfigurationBuilder() .AddJsonFile("appsettings.json") .Build(); DataContextDapper dapper = new DataContextDapper(config); DateTime rightNow = dapper.LoadDataSingle<DateTime>("SELECT GETDATE()"); Console.WriteLine(rightNow); Computer myComputer = new Computer() { Motherboard = "Z691", HasWifi = true, HasLTE = false, ReleaseDate = DateTime.Now, Price = 943.87m, VideoCard = "RTX 2060" }; string sql = @"INSERT INTO TutorialAppSchema.Computer ( Motherboard, HasWifi, HasLTE, ReleaseDate, Price, VideoCard ) VALUES('" + myComputer.Motherboard + "','" + myComputer.HasWifi + "','" + myComputer.HasLTE + "','" + myComputer.ReleaseDate.ToString("yyyy-MM-dd") + "','" + myComputer.Price + "','" + myComputer.VideoCard + "')"; Console.WriteLine(sql); bool result = dapper.ExecuteSql(sql); Console.WriteLine(result); string sqlSelect = @"SELECT Motherboard, Computer.HasWifi, Computer.HasLTE, Computer.ReleaseDate, Computer.Price, Computer.VideoCard FROM TutorialAppSchema.Computer"; IEnumerable<Computer> computers = dapper.LoadData<Computer>(sqlSelect); foreach(Computer singleComputer in computers){ Console.WriteLine("'" + myComputer.Motherboard + "','" + myComputer.HasWifi + "','" + myComputer.HasLTE + "','" + myComputer.ReleaseDate.ToString("yyyy-MM-dd") + "','" + myComputer.Price + "','" + myComputer.VideoCard + "'"); } } } }
Leave a Comment