Complete implement Telerik ORM Membership Provider

Thread is closed for posting
6 posts, 0 answers
  1. 9EB6FA97-5BFE-4BC9-AC3D-DEFFE3271AB8
    9EB6FA97-5BFE-4BC9-AC3D-DEFFE3271AB8 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. FC5A01F4-10E4-40AE-99EB-FFA4C67DC0A6
    FC5A01F4-10E4-40AE-99EB-FFA4C67DC0A6 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. 5B893B59-AA43-4633-975C-07F3B2A539CF
    5B893B59-AA43-4633-975C-07F3B2A539CF avatar
    375 posts
    Member since:
    Nov 2016

    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. 5A087EB4-03F0-44D1-A754-D11E4CEF6508
    5A087EB4-03F0-44D1-A754-D11E4CEF6508 avatar
    29 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. 54E5C1F7-01EA-4C5A-BFDF-BFE9D20BE12B
    54E5C1F7-01EA-4C5A-BFDF-BFE9D20BE12B avatar
    498 posts
    Member since:
    Jan 2017

    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. 5A087EB4-03F0-44D1-A754-D11E4CEF6508
    5A087EB4-03F0-44D1-A754-D11E4CEF6508 avatar
    29 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

This Code Library is part of the product documentation and subject to the respective product license agreement.