Skip to content
  • Categories
  • Recent
  • Tags
  • Popular
  • World
  • Users
  • Groups
Skins
  • Light
  • Cerulean
  • Cosmo
  • Flatly
  • Journal
  • Litera
  • Lumen
  • Lux
  • Materia
  • Minty
  • Morph
  • Pulse
  • Sandstone
  • Simplex
  • Sketchy
  • Spacelab
  • United
  • Yeti
  • Zephyr
  • Dark
  • Cyborg
  • Darkly
  • Quartz
  • Slate
  • Solar
  • Superhero
  • Vapor

  • Default (No Skin)
  • No Skin
Collapse
Code Project
  1. Home
  2. General Programming
  3. LINQ
  4. Declare TimeStamp in dbml

Declare TimeStamp in dbml

Scheduled Pinned Locked Moved LINQ
csharphelpsharepointdatabaselinq
1 Posts 1 Posters 1 Views 1 Watching
  • Oldest to Newest
  • Newest to Oldest
  • Most Votes
Reply
  • Reply as topic
Log in to reply
This topic has been deleted. Only users with topic management privileges can see it.
  • S Offline
    S Offline
    siva455
    wrote on last edited by
    #1

    I have an Sp which takes a userdefinedtabletype as one of the parameter,and now i need to call this Sp from my c# code. I created a dbml file and i created a class which simulates my userdefinedtabletype in DB. Now the issue is there is a column named **version** which of type TMESTAMP is present in the Udtt in SP And the structure of udtt in DB is as follows. CREATE TYPE dbo.sampletype as ID INT NULL, Name String NULL, Version TIMESTAMP So when i created a class i created VERSION column as below.. global::System.Data.Linq.Mapping.ColumnAttribute(Storage="_Version", DbType="rowversion NOT NULL")] public System.Data.Linq.Binary Version { get { return this._Version; } set { if ((this._Version != value)) { this._Version = value; } } } Now when i call SP using classic ADO.net(using cmdparameters,SqlExecuteReader) im getting the below error.. The type of column 'Version' is not supported. The type is 'Binary' Please help me regarding the same.

    1 Reply Last reply
    0
    Reply
    • Reply as topic
    Log in to reply
    • Oldest to Newest
    • Newest to Oldest
    • Most Votes


    • Login

    • Don't have an account? Register

    • Login or register to search.
    • First post
      Last post
    0
    • Categories
    • Recent
    • Tags
    • Popular
    • World
    • Users
    • Groups