Complete implement Telerik ORM Membership Provider

6 posts, 0 answers
  1. ericguo
    ericguo avatar
    2 posts
    Member since:
    Nov 2006

    Posted 22 Apr 2009 Link to this post

    Requirements

    RadControls version

    not require
    .NET version 2.0 or 3.5
    Visual Studio version   Visual Web Developer 2008 Express Edition
    programming language

    CSharp
    browser support

    all browsers supported by RadControls


    How Do I Creae a Custom Membership Provider Sample in Telerik ORM

    You need to create the ORMMembershipProvider DB manually and run CreateDB.bat to let Telerik ORM create db schema for you.

    If you are not using MS SQLExpress DB, change app.config ORMDBConnection according to the Telerik ORM document.

    The first step should be to create a user (CreateUser.aspx) and then you will be able to login to the Default.aspx page.

    original version is in SQL Server Express available at:
    http://www.asp.net/learn/videos/video-189.aspx
  2. Daniel
    Daniel avatar
    1 posts
    Member since:
    Sep 2010

    Posted 12 Oct 2010 Link to this post

    Hi, Im starting used Telerik especifically ORM, when use "Complete implement Telerik ORM Membership Provider" example, i have problems, i checked all instructions and debugging succesfully but not run this example.

     

    Server Error in '/' Application.

    Configuration Error

    Description: An error occurred during the processing of a configuration file required to service this request. Please review the specific error details below and modify your configuration file appropriately.

    Parser Error Message: Telerik.OpenAccess.RT.sql.SQLException: Invalid object name 'voa_keygen'.
      at Telerik.OpenAccess.RT.Adonet2Generic.Impl.StatementImp.executeQuery(String sql)
      at OpenAccessRuntime.Relational.sql.HighLowRelationalKeyGenerator.IsCached(Connection con, RelationalKeyGeneratorInfoCache infoCache, String tab, String kCol, String vCol, String key, Boolean& ret)
      at OpenAccessRuntime.Relational.sql.HighLowRelationalKeyGenerator.init(String className, RelationalTable theClassTable, Connection con, RelationalKeyGeneratorInfoCache relationalKeyGeneratorInfoCache)
      at OpenAccessRuntime.Relational.RelationalStorageManagerFactory.init(Boolean full)

    Source Error:

    Line 64: 			<providers>
    Line 65: 				<clear/>
    Line 66: <add name="ORMMembershipProvider" type="UO_Service.ORMMembershipProvider" enablePasswordRetrieval="true" enablePasswordReset="true" requiresQuestionAndAnswer="true" writeExceptionsToEventLog="false"/>Line 67: 			</providers>
    Line 68: 		</membership>

    Source File: C:\Pruebas\orm_member\WebSiteCSharp\web.config    Line: 66



    Anything suggestions ???
  3. Serge
    Admin
    Serge avatar
    375 posts

    Posted 14 Oct 2010 Link to this post

    Hello Daniel,

    There seems to be a missing table in you database, the 'voa_keygen' table is used by the HighLow key generator for types that have internal identity, such as  the one generated here. When the .bat file is run, it should produce (and execute) a script that creates an employee table and a voa keygen one. 

    -- UO_Model.Physical.Employee
     
    CREATE TABLE [Employee] (
        [description] VARCHAR(255) NULL,        -- UO_Model.Base.NamedObject.description
        [name] VARCHAR(30) NULL,                -- UO_Model.Base.NamedObject.name
        [creation_date] DATETIME NOT NULL,      -- creationDate
        [email] VARCHAR(255) NULL,              -- email
        [employee_id] INT NOT NULL,             -- employee_id
        [failed_pwd_ans_attempt_count] INT NOT NULL, -- failedPwdAnsAttemptCount
        [fld_pwd_ns_ttempt_window_start] DATETIME NOT NULL, -- failedPwdAnsAttemptWindowStart
        [failed_pwd_attempt_count] INT NOT NULL, -- failedPwdAttemptCount
        [filed_pwd_attempt_window_start] DATETIME NOT NULL, -- failedPwdAttemptWindowStart
        [full_name] VARCHAR(50) NULL,           -- fullName
        [is_approved] tinyint NOT NULL,         -- isApproved
        [is_locked_out] tinyint NOT NULL,       -- isLockedOut
        [is_on_line] tinyint NOT NULL,          -- isOnLine
        [last_activity_date] DATETIME NOT NULL, -- lastActivityDate
        [last_locked_out_date] DATETIME NOT NULL, -- lastLockedOutDate
        [last_login_date] DATETIME NOT NULL,    -- lastLoginDate
        [last_password_changed_date] DATETIME NOT NULL, -- lastPasswordChangedDate
        [passwd] VARCHAR(255) NULL,             -- password
        [password_answer] VARCHAR(255) NULL,    -- passwordAnswer
        [password_question] VARCHAR(255) NULL-- passwordQuestion
        [voa_version] SMALLINT NOT NULL,        -- <internal-version>
        CONSTRAINT [pk_Employee] PRIMARY KEY ([employee_id])
    )
    go
     
    -- OpenAccessRuntime.Relational.sql.HighLowRelationalKeyGenerator
    CREATE TABLE [voa_keygen] (
        [table_name] VARCHAR(64) NOT NULL,
        [last_used_id] INT NOT NULL,
        CONSTRAINT [pk_voa_keygen] PRIMARY KEY ([table_name])
    )
    go
     
    CREATE UNIQUE INDEX [idx_Employee_name] ON [Employee]([name])
    go

    This is the code I got from the .bat file, can you please verify that you have both object in the database? 

    I hope this was helpful.

    Sincerely yours,
    Serge
    the Telerik team
    Do you want to have your say when we set our development plans? Do you want to know when a feature you care about is added or when a bug fixed? Explore the Telerik Public Issue Tracking system and vote to affect the priority of the items
  4. Nuno
    Nuno avatar
    28 posts
    Member since:
    Sep 2013

    Posted 15 Oct 2013 Link to this post

    Hello!

    Is there a version with the "modern" Open Access? 

    Thanks!
  5. Doroteya
    Admin
    Doroteya avatar
    502 posts

    Posted 18 Oct 2013 Link to this post

    Hello Nuno,

    Currently, we do not distribute a version of Telerik ORM Membership Provider implemented for our modern API. The request, however, is in our backlog. As a workaround, I would suggest to you to take the ideas from this code library  and implement them on your side. The general approach would be the same and the context in the modern API is a wrapper around the IObjectScope used in the sample.

    Excuse us for any inconvenience caused. If you have additional questions, do not hesitate to get back to us.


    Regards,
    Doroteya
    Telerik
    OpenAccess ORM Q3 2013 Beta is available for immediate download in your account. Get it now and play with the latest bits. See what's new >>
  6. Nuno
    Nuno avatar
    28 posts
    Member since:
    Sep 2013

    Posted 18 Oct 2013 Link to this post

    Hello Doroteya,

    Thanks on the info. I'll go into that in my project if I manage to put time on it.:)

    Best wishes,
    Nuno
Back to Top