MVC :: Finding Books And Links For Mvc And Learning Linq Queries
Nov 10, 2010i want to get masterized....in MVC
finding books and links for mvc..and learning linq queries
i want to get masterized....in MVC
finding books and links for mvc..and learning linq queries
I wish to learn to develop web sites with asp.net 3.5 Does anyone know of any good books or website tutorials that could teach me how to develop creative web sites? When I mean creative, i mean master page examples and use of tables etc etc.
View 3 Repliesi decided that asp.net is the one for me. But i dont know any of .net languages. My teacher recommended c# but i dont nedd to learn c# completely but only basics with asp.net. Is there any book or website that teaches c# specifically for asp.net
View 1 RepliesI am trying to get the hotfile's downloadable file links in html source in
C#.Net.
Ex Html Source:
<A class="l" onmousedown="return clk(this.href,'','','','6','','0CDgQFjAF')"href="http://tinypaste.com/f4472e">
<EM>http://hotfile.com/dl</EM>/31214236/e3ad3a3/dora_ve_unicorn.avi.html<B>
.</B></A></H3><DIV class="s"><EM>http://hotfile.com/dl</EM>/31214236/e3ad3a
3/dora_ve_unicorn.avi.html <EM>http</EM><B>...</B><BR><SPAN class="f">
<CITE>tinypaste.com/f4472e</CITE>....
i just want to get "http://hotfile.com/dl</EM>/31214236/e3ad3a3/dora_ve_
unicorn.avi.html"link and that kind links from the whole Html source.
I tried to use Regex but couldnt find the correct exp.
When i see MVC Music store. They have used ADO.NET entity data model and used LINQ language to perform operation in DB.. Is there any way to use normal sql queries?
View 3 RepliesHow to convert SQL Queries to Linq.is their any tool available to convert SQL Queries to Linq
View 2 RepliesI use LINQ-SQL as my DAL, I then have a project called DB which acts as my BLL. Various applications then access the BLL to read / write data from the SQL Database.
I have these methods in my BLL for one particular table:
public IEnumerable<SystemSalesTaxList> Get_SystemSalesTaxList()
{
return from s in db.SystemSalesTaxLists
select s;
}
public SystemSalesTaxList Get_SystemSalesTaxList(string strSalesTaxID)
{
return Get_SystemSalesTaxList().Where(s => s.SalesTaxID == strSalesTaxID).FirstOrDefault();
[Code].....
Is it possible to combine these 2 linq queries ?
[Code]....
I'm trying to do something that on the face of it is very simple.
If I have 5 text boxes, and 1 of them is blank, I want to exclude that textbox from the query, rather than searching for where a field is blank.
I've tried to do a bit of research into dynamic linq queries, but have come up empty handed, or what I've found doesn't seem to quite answer my question.
I have my Linq query in which i need to find time difference(not days difference).
The field in database is datetime.
Dim ldtToday
As DateTime = TimeOfDay
Dim SR_RM_InnerJoin =
From SR
In lcntxRT60Entities.RtSReports _
Join RM
In lcntxRT60Entities.RtRMaster
On SR.RtRMaster.ReportID
Equals RM.ReportID _
Select SR, RM _
Where SR.TID = 1 _
And --(Check) SR.ReportDeliveryTime.Value.AddDays(1) < ldtToday
How can i check if the time field of the record is less than current time??
I want to unit test my asp.net web application using NUnit.
For this I have downloaded and installed NUnit from internet.
But since I am new to this tool , I am looking for documentation about this tool.
How can I use this tool for testing web applications? give me links to documentation?
Also is it possible to integrate NUnit with visual studio, if yes, how?
send me some tutorial links to develop a module based website and admin can enable disable any modules.
View 2 RepliesA sample linq query from MSDN: var expensiveInStockProducts = from p in products where p.UnitsInStock > 0 && p.UnitPrice > 3.00M select p; Does this query select EVERY column from the database table immediately, or does it return some sort of pointer that retieves the actual column data on demand? ie. If there are 50 columns in my table and I only use a single p.UnitsInStock in my actual code, then am I retrieving 50 times more data than I expected?
View 2 RepliesI am creating entries in a contract table using linq to sql.
One column needs to conditionally be assigned an application number from a range of values.
I'd like to simply increment the max existing value, however it is a multi-user application and I'm concerned about multiple contracts receiving the same app number if they happen too close together.
Is there a way to either force the entire thing to use the same transaction, or to execute both during the same submit?
how to improve the application performance while writing LINQ Queries ?Like the optimization techniques.
View 2 RepliesI've got the following LINQ query to my IQueryable service
Dim eventcount = EventService.QueryEvents().Count
Dim eventlist = EventService.QueryEvents().Skip((page - 1) * 5).Take(5).ToList
But I'm wondering if there's a way to do this without making two calls to the database?
Is there a way to cap the number of records returned when an .Include() method is called on an ObjectQuery<>? Basically, if one of my entities is in a one-to-many relationship, such as a Band entity to a list of Fan entities (where a band can have any number of fans), how can I limit the number of fans returned?
In the example: var band = ctx.Bands.Include("Fans").SingleOrDefault(b => b.BandId == someBandId);
If I use the Include, it will return all fans. How can I query that Fans navigation property to return only a subset or max?
I've got a linq to sql query that pulls data from 2 different tables and contains an or statement:
[Code]....
The problem I've got is that some queries match both sides of the or statement so it returns the same record twice.
How can I eliminate these duplicates quickly and easily?
I am working on asp.net 3.5 and in MVC using Linq to SQL classes. In my MVC project i am calling stored procedure using linq to sql that conatin query joining two tables.Below is my code in Partial class
[
Function(Name="dbo.GetUserWiseThreadDetail_SP")]
[ResultType(typeof(Thread))]
[ResultType(typeof(Reply))]
public
IMultipleResults GetUserWiseThreadDetail_SP([Parameter(DbType="VarChar(30)")]
string userID)
{
ExecuteResult result = this.ExecuteMethodCall(this,
(MethodInfo)(MethodInfo.GetCurrentMethod())), userID);
return ((IMultipleResults)(result.ReturnValue));
}
In one of the controller i have made one more class
public class
MypostIndexData
{
public
IEnumerable<Thread> Thrds {
get;
set; }
public
IEnumerable<Reply> Repls {
get;
set; }
public MypostIndexData(IEnumerable<Thread>
thrds,IEnumerable<Reply> repls)
{
this.Thrds=thrds;this.Repls=repls;
}
}
finally coding of controller action method
ForumDataContext pmforum = new
PMForumDataContext();
public
ActionResult MyPosts(string userId)
{
IEnumerable<Thread>thrds;
IEnumerable<Reply>repls;
IMultipleResults result = pmforum.GetUserWiseThreadDetail_SP(userId); (this satement doesnot give any result,if i execute stored proc in
sql it give the results)
thrds = result.GetResult<Thread>();
List<Thread> thrdlist =
new
List<Thread>(thrds);
repls = result.GetResult<Reply>();
List<Reply> replylist;
if (repls !=
null)
{
replylist = new
List<Reply>(repls);
}
return View(new
MypostIndexData(thrds,repls));
I am unable to understand why i am not getting any results?
Is there a way to combine the LINQ queries together and have access to both of the results independently?
[Code]....
I am New to LINQ.Will you Please Provide me some Links or Guidence for Using LINQ.And Wats the advantage of Using LINQ?
View 3 RepliesI'm currently trying to work out the best way to build this web application, which will then be intergrated on other systems, such as WinForms, Intranets etc.
We hope to include the usual layers i.e. DAL, BLL, BOL and UI but I have been experimenting with Entity Framework 4 and WCF Data Services and managed to get something in place where I was using WCF as a gateway to EF4.
i.e. Adding a Service Reference to my project and then using the EF4 context and writing LINQ queries against the DB
e.g.[Code]....
Now with the current setup I would still need to write a DAL Class Library, that interacts with the Data Service, because as I said WCF Data Services only seems to be a gateway, I can't see where to put the code (above) in the Data Service and then how I could these methods.
My questions are: 1. How do I develop a WCF Data Service in such a way to allow this behaviour - I know how I could do it using ASMX web service, something like [Code]....
2. If I am to use WCF Data Services, how is serialization handled (if at all) - again I know how to do something in ASMX web services
3. Again, If I am to use WCF, how do I add Security and only allow my applications to access the web service - for obvious reasons
4. Would it be possible / logical to also include the Business Logic Layer into the web service?
I have a field name as a string and i want to find it in a linq query. so something like this
[Code]....
I have placed a textbox, dropdownlist and command button in a section of my master page. The textbox, named txtsearch, will be used to input a search string. The dropdownlist, named ddlsearch, will be used to specify in which field to search in the table, either part name or NSN.
Questions:
What VB code do I use to save the value entered into txtsearch as a search string? How do I pass that value to my entitydatasource? How do I tell entitydatasource to search in either the part name or NSN field based on the value of ddlsearch?
I need a book or two to get a good understanding of web services, starting from very basics, and going upto WCF. I've been using c# for 2 years and have intermediate level of experience with the language.
View 1 Replies