Console.WriteLine("Main method complete. Press enter to finish.");
Create Table TestSort (ID int identity(1,1), Name nvarchar(30), Color nvarchar(15) )
Insert into TestSort (Name,color)
Values ('Adjustable Race',null)
,('Bearing Ball',null)
,('Headset Ball Bearings',null)
,('LL Crankarm','Black')
,('ML Crankarm','Black')
,('Chainring','Black')
,('Front Derailleur Cage','Silver')
,('Front Derailleur Linkage','Silver')
,('Lock Ring','Silver')
,('HL Road Frame - Red, 62','Red')
,('HL Road Frame - Red, 48','Red')
,('LL Road Frame - Red, 44','Red')
,('Full-Finger Gloves, M','RED')
,('Road-550-W Yellow, 38','Yellow')
,('Road-550-W Yellow, 40','Yellow')
,('Road-550-W Yellow, 42','Yellow')
,('Classic Vest, S','Blue')
,('Classic Vest, M','Blue')
,('Classic Vest, L','Blue')
Select t.ID,t.Name,t.Color from TestSort as t order by t.Color
Select t.ID,t.Name,t.Color from TestSort as t Where t.color is not null order by Case t.Color When 'Red' Then Null Else t.color End;
Select * into Simulation from (Select t.ID,t.Name,t.Color, Case t.Color When 'Red' Then Null Else t.color End RedNull from TestSort as t Where t.color is not null) A
Select * from Simulation order by Rednull
Want to automatically generate tests for your JS/TS functions? GitHub CoPilot now does that.
A collection of hash functions, ciphers, tools, libraries, and materials related to cryptography.
Select * from sys.dm_os_buffer_descriptors
select * from sys.dm_os_buffer_pool_extension_configuration
ALTER SERVER CONFIGURATION SET BUFFER POOL EXTENSION ON (FILENAME = 'd:\BufferPoolExt.BPE', SIZE = 1GB);
ALTER SERVER CONFIGURATION SET BUFFER POOL EXTENSION ON (FILENAME = 'd:\BufferPoolExt.BPE', SIZE = 10GB);
Could not change the value of the 'BPoolExtensionPath' property
ALTER SERVER CONFIGURATION SET BUFFER POOL EXTENSION OFF
facid: 9, Name: 'Spa', membercost: 20, guestcost: 30, initialoutlay: 100000, monthlymaintenance: 800.
insert into facilities
(facid, name, membercost, guestcost, initialoutlay, monthlymaintenance)
values (9, 'Spa', 20, 30, 100000, 800);
-- OR
insert into facilities values (9, 'Spa', 20, 30, 100000, 800); context.Facilities.Add(new Facility
{
Name = "Spa",
MemberCost = 20,
GuestCost = 30,
InitialOutlay = 100000,
MonthlyMaintenance = 800
});
context.SaveChanges(); facid: 9, Name: 'Spa', membercost: 20, guestcost: 30, initialoutlay: 100000, monthlymaintenance: 800. facid: 10, Name: 'Squash Court 2', membercost: 3.5, guestcost: 17.5, initialoutlay: 5000, monthlymaintenance: 80.
insert into facilities
(facid, name, membercost, guestcost, initialoutlay, monthlymaintenance)
values
(9, 'Spa', 20, 30, 100000, 800),
(10, 'Squash Court 2', 3.5, 17.5, 5000, 80); context.Facilities.Add(new Facility
{
Name = "Spa",
MemberCost = 20,
GuestCost = 30,
InitialOutlay = 100000,
MonthlyMaintenance = 800
});
context.Facilities.Add(new Facility
{
Name = "Squash Court 2",
MemberCost = 3.5M,
GuestCost = 17.5M,
InitialOutlay = 5000,
MonthlyMaintenance = 80
});
context.SaveChanges(); Name: 'Spa', membercost: 20, guestcost: 30, initialoutlay: 100000, monthlymaintenance: 800.
namespace EFCorePgExercises.Entities
{
public class FacilityConfiguration : IEntityTypeConfiguration<Facility>
{
public void Configure(EntityTypeBuilder<Facility> builder)
{
builder.HasKey(facility => facility.FacId);
builder.Property(facility => facility.FacId).IsRequired().UseIdentityColumn(seed: 0, increment: 1); CREATE TABLE [dbo].[Facilities]( [FacId] [int] IDENTITY(0,1) NOT NULL, --- ... CONSTRAINT [PK_Facilities] PRIMARY KEY CLUSTERED ( [FacId] ASC );
update facilities
set initialoutlay = 10000
where facid = 1; var facility1 = context.Facilities.Find(1); facility1.InitialOutlay = 10000; context.SaveChanges();
update cd.facilities
set
membercost = 6,
guestcost = 30
where facid in (0,1); int[] facIds = { 0, 1 };
var tennisCourts = context.Facilities.Where(x => facIds.Contains(x.FacId)).ToList();
foreach (var tennisCourt in tennisCourts)
{
tennisCourt.MemberCost = 6;
tennisCourt.GuestCost = 30;
}
context.SaveChanges(); update cd.facilities facs
set
membercost = (select membercost * 1.1 from cd.facilities where facid = 0),
guestcost = (select guestcost * 1.1 from cd.facilities where facid = 0)
where facs.facid = 1; var fac0 = context.Facilities.Where(x => x.FacId == 0).First(); var fac1 = context.Facilities.Where(x => x.FacId == 1).First(); fac1.MemberCost = fac0.MemberCost * 1.1M; fac1.GuestCost = fac0.GuestCost * 1.1M; context.SaveChanges();
delete from bookings
context.Bookings.RemoveRange(context.Bookings.ToList()); context.SaveChanges();
delete from members where memid = 37;
var mem37 = context.Members.Where(x => x.MemId == 37).First(); context.Members.Remove(mem37); context.SaveChanges();
var entry = context.Entry(new Member { MemId = 37 });
entry.State = EntityState.Deleted;
context.SaveChanges(); SET NOCOUNT ON; DELETE FROM [Members] WHERE [MemId] = @p0; SELECT @@ROWCOUNT;
delete from members where memid not in (select memid from cd.bookings);
var mems = context.Members.Where(x => !context.Bookings.Select(x => x.MemId).Contains(x.MemId)).ToList(); context.Members.RemoveRange(mems); context.SaveChanges();
In .NET 6 (preview 4), two long-awaited types have been introduced as part of the core library. DateOnly and TimeOnly allow developers to represent either the date or time portion of a DateTime. These two new types are structs (value types) and may be used when your code deals with date or time concepts independently. Both types can be found in the System namespace. Using these new types may align well with how databases allow similar data to be represented. Specifically, these types align well with the SQL Server date and time data types.
