StudioSharp Docs

Sql Sharp DataTypes


Sql Sharp DataTypes.

There are two type datatypes in sql sharp:

Simple:- int ,string ,Decimal,Float ,bit ,DateTime

Special:- string Email ,string Phone Number ,string Website Url ,string File Upload,string Text Editor ,Datetime Calendar ,string TextArea , Current Datetime ,Current User ,string Video Url

 

Simple Datatypes:- Simple datatypes are that which you regular use in sql server.

  • string is a nvarchar
    • If you give a size to string then it will burn nvarchar(your size)  ie: nvarchar(100)
    • If you not enter any size then it wil burn ntext

Special Datatypes:- Special Datatypes

  • string Email is nvarchar

Advantage

  • Automatic Add regular Expression In your model class
  • Validate email expression on submit time


  • string Phone Number
    • It is nvarchar

Advantage

  • Add Phone Number Input mask on your View.

  • string Website Url
  • It is nvarchar

Advantage

  • In your view automatic add Url Regular expression like


  • string File Upload
  • It ia nvarchar

Advantage

  • In View Automatic add File Uploader

  • Automatic add Image in Detail view and Your Grid

  • Automatic Create Code On Image Upload


  • string Text Editor
  • It is nvarchar or if you don't add any size then it will be ntext

Advantage

  • Automatic Add Ck Editor in your Insert and Edit view


 

  • Datetime Calendar
  • It is Datetime Datatype

Advantage

  • Add Calendar Automatic with your textbox


  • string TextArea
  • It is nvarchar or if you don't add any size then it will be ntext
  • Automatic add textarea on your insert or edit page

  • Current DateTime
  • It is Datetime datatype

About:- Auto Insert Mean you have no need to write code and add calendar in view controller and view , it will automatic handle while your data will insert.


  • Current User
  • It is Int datatype

About:- Logined user which perform any action in your application Like insert update data ,then it will automatic insert logined user Id in table.


  • string Video Url
  • It is nvarchar

Advantage

  • In your view automatic add Url Regular expression like


 

Related Articles