I am a little new to this concept so bear with me.1) I need to query atleast 35 tables using linq to sql(SQL server database) . I am not able to add all the database entities in Linq to sql classes?
2)(View Model issue) When I use List<Reportcollection> and also List<Receipt> to convert the result then its giving an error that "Cannot convert list<anonymous> to list<string>"
Is there a way to select data from multiple tables other than the UNION ALL statement. Addtionally I need to select data from a different database.
My current statement is as follows (there are alot more fields but I have shortened it ):
SELECT server.dbo.SRFILE.SR_GROUP, server.dbo.SRFILE.SROWNERSHIP, server.dbo.SRFILE.SRCONMAE, BSFLBWF_1.Incidentx,
BSFLBWF_1.Severityx FROM server.dbo.SRFILE INNER JOIN
BSFLBWF AS BSFLBWF_1 ON BSFLBWF_1.Incidentx = server.dbo.SRFILE.SRONUMBER
WHERE (BSFLBWF_1.Closex IS NULL).........
As the title sugests, I am missing a (basic?) concept as I teach myself asp.net, linq, and C#. It has been awhile since I've done anything object oriented, so I don't know how much that is impacting this gap in my understanding. Anyhow, here is what I am trying to do. I have three SQL Server tables: PERSON, POSITION, AREA. There is a 1 to many relationship between PERSON and POSITION, and a 1 to 1 relationship between POSITION and AREA. Given the following code I verify who the person is who has logged into the browser:
[Code]....
I want to be able to return all of the AREAs the person is able to access, based on the position they currently hold. I am able to easily do this in a SQL Server query, and I am sure I can do this with a SQL stored procedure once I pass the EMPLOYEE_ID to the procedure. However, I would rather do this in the page_load event, and load the returned results into gridview1 for the viewer. The issue I am running into is in building the LINQ query. When I try to build it, I can only get access to two of the three tables, depending on which table I select with db. Is it possible to access all three tables in the same query?
I want to do execute a LINQ query, and I have the name of the table to query stored in a variable:
string tableName = "SomeTable";
DataContext db = new DataContext();
var vResult = from t in db.tableName where t.Id = ....
how can I display a linq query in a gridview that has data from multiple tables AND allow the user to edit some of the fields or delete the data from a single table?
I'd like to do this with either a linqdatasource or a linq query. I'm aware I can set the e.Result to the query on the selecting event. I've also been able to build a custom databound control for displaying the linq relations (parent.child).
However, I'm not sure how I can make this work with delete? I'm thinking I may need to handle the delete event with custom code.
can get two tables in only one query with LINQ to Entities
Code for example:
[Code]....
i am developing a web site in Asp.Net using Visual Studio 2008.i want to know that how can i search a keyword that will be entered by the user, i want the key word should be searched in complete database(all the tables)using a single query.I am using sql database. how can the keyword be searched using like parameter...
View 1 RepliesHere I'm using three tables given below. As u can see in the below three tables, 3 columns(P_Id,PdtName,PdtImgUrl) are same. Now can any body tell me how can I retreive values of 3 columns(P_Id,PdtName,PdtImgUrl) without repeatition.
Coming_Products(C_ID,P_Id,PdtName,PdtImgUrl,PdtRetPrice,Startdate),
Live_Products(L_ID,P_Id,PdtName,PdtImgUrl,PdtRetPrice,PdtCurPrice,UName),
Ended_Products(E_ID,P_Id,PdtName,PdtImgUrl,WinPrice,SavingPrice,UName,Endeddate)
I'm looking to translate an SQL query into linq
INNER JOIN Usrs ON
SAQ.UserId =
Usrs.UserId AND Scan.UserId =
Users.UserId
I'm not sure how to include the "AND" in the LINQ statement.
Validate a checkbox list using server side validation, to make sure atleast one value is selected?
asp:CheckBoxList ID="CheckBoxList1" runat="server" RepeatColumns="3">
<asp:ListItem>1st</asp:ListItem>
<asp:ListItem>2nd</asp:ListItem>
<asp:ListItem>3rd</asp:ListItem>
</asp:CheckBoxList>
<asp:Button ID="Button1" runat="server" Text="Submit" />
One of my peer wrote a query based on multiple tables using joins. One of the table is in a different database The query was taking much time
1. Create an SP
2. Create a temp table and copy all records from the external db
3. Avoid using Left Join as much as possible and use Inner Join
4. Create and use indexes
5. Remove tables/columns that are not necessary
In this scenario, I would like to suggest to use Covering Index, but how can it be created for multiple tables and a temp table?
By right clicking on my database i created a query in server explorer. But where are this query stored can't find them back. I should aspect that their is a folder query's like there is a folder tables but this isn't the case.
View 10 RepliesI'm really not a database person, so forgive me if this question. I'm using visual studio 2008 and i am trying to view tables on another server database. Example
I have my aspnetdb.mdf database, and my anaylsis.mdf database. What i am trying to do within visual studio is read table colunms that are inside aspnetdb.mdf from anaylsis.mdf.
IDE: MS Visual Studio 2008 / SQL Server 2005 Express / SQL Server Management Studio Express 2005
Skills: BeginnerI was trying to delete a table from my database ASPNETDB.MDF ,that DB was previously used for User login information i made it by using asp.net built in login support by opening ASP.NET configuration ,but now i want to built my own simple login control...so i want to remove all the tables made by ASP.NET configuration.I got this error when deleting one of the table"Could not drop object 'dbo.aspnet_Applications' because it is referenced by a FORIEGN KEY constraint"
A follow up question concerning the DAL layer part .. The first question about dealing with large objectsI have one table (PlacesTable) that is connected by like 6 other tables (1:Many and Many:Many relations)
In my DAL should I put a big query that join the 6 tables + the m:m reference tables (btw it produces multiple data that I don't need Please refer to my old question) and place all the data in it's specific object property or, should I use a single query for each table and create an object for each fetched table .. and finally send those to the UI ?If I wasn't clear enough please let me know what I further information do you need to know!
I want to retrieve the name and phone columns from all the tables in my database not in systables.
Ok this works but i dont want to get it from just the test table I want to get it from all the tables that I create
"USE mrpoteat SELECT name, phone FROM mrpoteat.dbo.test where name = name and phone = phone"
What would you all suggest a database with less number of tables and more number of columns or more number of tables with less number of columns. I am developing a web application using Visual stuio 2005 and Sql Server 2005
View 2 RepliesI want to add custom columns to some tables created by ASP.NET. For example; I need to add two fields such as FirstName and LastName to the aspnet_Membership table.
I can add this directly by editing the table but;
Is this the right thing to do (I mean; extending the table directly) OR should I create a separate table and hold the extra user data, there?How can I see these custom database fields as properties in code completion? example: membershipuser.FirstName;
i have one database named as sampleDB its having more than 100 tables. this database running on production. here we have one requirement need to add companyid feild all the tables in our sampleDb. is it possible to write query to alter all the table.
View 3 RepliesI have a Table in SQL Server DataBase with 200 + Rows
OriginDest(OID, DID)
I want to Copy all the row from OriginDest Table, DataBase1. To OrginDest, DataBase2 with Same Name
I am developing the Home page of a Client. Apart from various things on this home page I have a text box and search button. Having said that, I have a database in which I have almost 12 tables with varying number of columns. Now my question is,Is there anyway to search a word typed by a user in the textbox to search it in all the tables(all columns) of the database.
View 2 RepliesI'm working on a new asp.net 4.0 resume web site. I'm starting off with SQL Server Express 2005 and using the standard security and login features given with ASPNETDB.mdf. My site will be hosted on GoDaddy.com.
Quesiton. Should the tables that will contain the information that users will be putting in like resumes, contact information and such go into ASPNETDB.mdf or should it go into a separate database.
I used to work in the IT field, but because of an accident and meds I have lost a bunch of my memory. So, I'm in need of relational database help..I've got a web site I want to put up that will sell books. I'll be using SQL server 2008. I'll be using Pay Pal's Cart, etc, so I just have to put up some buttons on the web site, but I need to track, display, etc, the books and properties about the books such as Authors, Paper back or hard cover, first edition, or something else, etc,..I have a table for books obviously, but I'm wondering if I should break out the Authors out of that table? I mean I don't see why except that if I end up with some books that have the same author then there names will be stored more than once, but I will be doing a lot more queries than inserts. I've got Customers, Book Types which is if the book is a hard cover, softcover, first edition, etc,. I will relate the Books to the Book Types of course, but again, should I have an authors table? Hope this makes sense.. I am using Visual Studio 2008 Pro, and want to do my relations there, so I thought I'd do so in the IDE if possible? I can't remember, but I thought it was possible?
View 6 RepliesI am working on a multi-lingual application Assume the following:
Database has 50 tables and application has to support 5 languages
Which is the best way to design the database:
1. Include a langugae column for each table. Repeat the values for each language. Say i have a country table which has 100 countries in it. Then my design will contain 500 rows (100 for each langugae)
2. Create a separate table which will contain the translations for all the 50 tables in with a foreign key to the parent table.
Which is more efficient out of the above two.
I want to use "if statement" in Linq query. How can I do this situation?
For example:
if txtAge.Text=="", I will not use that in Linq Query.
else txtAge.Text!="", I will use that in Linq Query.