Calculate Days from BirthDate and Current Date difference in SQL Server C# and VB.Net

Please refer below

SQL

DECLARE @Temp AS TABLE(Id INT,DOB DATETIME)

INSERT INTO @Temp VALUES(1,'2015-02-02')
INSERT INTO @Temp VALUES(2,'2015-04-02')
INSERT INTO @Temp VALUES(3,'2015-08-02')

SELECT Id,DATEDIFF(DAY,DOB,GETDATE()) NoOfDays  FROM @Temp 

C#

DateTime dob = DateTime.Parse("2015-12-02");
DateTime today = DateTime.Now;
int totalDays = today.Subtract(dob).Days;

VB

Dim dob As DateTime = DateTime.Parse("2015-12-02")
Dim today As DateTime = DateTime.Now
Dim totalDays As Integer = today.Subtract(dob).Days

I hope this will help you out.