Let's create a sample login application for WPF beginners. Making such an application is simple because it is embedded with SQL Server as back-end, with a MahApps integrated application and a few animations.
Prerequisites → PSKSConStr,
Create a table with the columns mentioned below,

UserId → Bigint
UserName → nvarchar
DateCreated → datetime
LastUpdate → datetime
IsActive → bit
IsDisplay → bit
IPAddress → nvarchar
PcName → nvarchar

WPF

Stored procedure
  1. USE[PSKS]
  2. GO
  3. /****** Object: StoredProcedure [dbo].[uspGetUsers] Script Date: 7/16/2017 6:05:12 PM ******/
  4. SET ANSI_NULLS ON
  5. GO
  6. SET QUOTED_IDENTIFIER ON
  7. GO
  8. create procedure[dbo].[uspGetUsers]
  9. (@UserName nvarchar(256), @Password nvarchar(256))
  10. as
  11. begin
  12. select * from tblUser tu
  13. where UserName = @UserName
  14. and Password = @Password
  15. end
  16. --
Solution is zipped and attached.