score:2
Accepted answer
i assume you're creating it using the asp.net membership? if so, simply add a uniqueidentifier column inside your profiles table, set as primary key and you're good to go. sql won't allow you to add more than 1 record for that id.
this article provides exactly what you need http://www.asp.net/security/tutorials/storing-additional-user-information-cs
Source: stackoverflow.com
Related Query
- One to one relationship in Sql Server and LINQ
- How to write SQL translateable linq code that groups by one property and returns distinct list
- Is it possible to automatically prefix all table names in SQL Server and in LINQ to SQL?
- Linq with optional Where clauses and Sql Server CE
- Entity Framework: LINQ query generates different SQL between local execution and server execution
- Linq SQL error with one-to-many relationship and orderby complex expression
- linq and parallelism - SQL Server
- SQL Server Express / MS Access LINQ Features, Which One to Use?
- Many to Many relationship using SQL and Linq (entity framework/to entities)
- Pull data from multiple tables in one SQL query using LINQ and Entity Framework (Core)
- What the linq query for SQL like and Soudex for sql server 2008?
- query and create objects with a one to many relationship using LINQ
- Handling very large strings between SQL Server and .NET code +LINQ
- SQL subquery result in LINQ and Entity Framework Code First
- Why is sql server query returning results and linq query is not
- Accessing SQL Server time in code with LINQ
- SQL Server TDE and LINQ
- Error connecting to SQL from WCF Using LINQ - but affects only one server
- How to get the distinct record name and its each record count to bind to gridview in C# using Linq from SQL Server
- C# LINQ to SQL - one to many relationship
- How to group by and calculate sum and select where is less than given amount in SQL Server / C# Linq
- MVC Linq Queries and MS SQL Server
- How to write SQL and LINQ to get the one record from a result with where condition?
- C# linq query from sql server into one table
- Optimise and speed up very slow Linq / SQL code
- Convert a SQL Server Query to C# LINQ having ROW_NUMBER() and OVER
- Implementing LINQ to Entity on many to one and one to many relationship
- Entity Linq - Retrieve record and only the first child record in a one to many relationship
- using linq query with include/then_include vs using sql query with joins and gettng db server error
- how to fetch data from database using linq query for relationship 1:N and N:N (between 3 entity) in asp.net mvc EF code first?
More Query from same tag
- Linq Edit ListView
- Load only some elements of a nested collection efficiently with LINQ
- how to join multiple tables in linq using flag field
- DbLinq generic extension method - string as keyselector?
- Got a value from a list and want to get the id of the item having the list as property
- How to append my list elements
- How to calculate total working time in LINQ?
- A cycle was detected in a LINQ expression Linqkit
- LINQ how to select the newest folder according to creation date
- How to use LINQ to retrieve a list from another entity with a specific number of items
- Return all in List <T> in lambda expression
- LINQ Select distinct on DataTable not working
- DataGrid populating blank rows on TreeView's SelectedItemChanged
- Building a List from another list and other sources in C#
- Remove element from last level of nested list C# LINQ
- Determining a SQL Server Identity Column Name in .NET
- Reuse Linq to SQL code with entityframework
- How can I do this with LINQ?
- Range projection: equivalent of LINQ select in D?
- Efficiently flatten LINQ join results
- linq to sql select as command
- filter datatable using parent id
- Getting a data to display in a DataGridView using a combobox to filter the results of the queries
- Select result of where clause
- Linq Group by relative entites
- LINQ Where Syntax
- left join two tables in same DataContext LinQ in c#
- Not able to compare NAN using Expression
- LINQ - How to insert null DateTime into database column?
- Where in clause using linq
