you can use
Date[
^] column type. then you can insert directly
Date
from your .net application ( use default date like 1st day of month) and when you display the year/month from database you can use format strings like
datefromDb.ToString("MMMM yyyy")