Rahul,

In that case you can make use of petapoco which is the data layer umbraco uses. More information about peta poco here and to use in umbraco you can do things like:

Database Db = ApplicationContext.Current.DatabaseContext.Database;

public bool InsertRecordInDb(int questionId, int nodeId, bool answer, Guid recordId) {
var surveyEntry = new SurveyAnswer { ContourId = recordId, NodeId = nodeId, Answer = answer, QuestionId = questionId, DateOfAnswer = DateTime.Now }; try { Db.Insert(surveyEntry);

            return true;

        }
        catch (Exception ex)
        {
            LogHelper.Error<Exception>("Error inserting record " + surveyEntry.ToString(), ex);
        }
        return false;

    }

and my class surveyanswer looks like:

    [TableName("SurveyAnswer")]
[PrimaryKey("Id", autoIncrement = true)]
[ExplicitColumns]
public class SurveyAnswer
{   
    [Column]
    public int Id { get; set; }

    [Column]
    public Guid ContourId { get; set; }

    [Column]
    public int QuestionId { get; set; }

    [Column]
    public int NodeId { get; set; }

    [Column]
    public bool Answer { get; set; }

    [Column]
    public DateTime DateOfAnswer { get; set; }

    public override string ToString()
    {
        return string.Format("Id: {0}, ContourId: {1}, QuestionId: {2}, NodeId: {3}, Answer: {4},DateOfAnswer:{5}", Id, ContourId, QuestionId, NodeId, Answer,DateOfAnswer);
    }
}

So my surveyclass maps to survey table in database.

Regards

Ismail