SQL Server :: What To Use To Do A Data Model?
Jan 24, 2011I wonder what you are using when you do the datamodel?Do you write it down on paper or do you use somethin else?Is there any tool I can use in SQL Server 2008?
View 1 RepliesI wonder what you are using when you do the datamodel?Do you write it down on paper or do you use somethin else?Is there any tool I can use in SQL Server 2008?
View 1 RepliesI've been used to decorating data model classes with data annotation attributes, but the purist in me baulks slightly at including purely presentational attributes such as display format here. I am, however, quite happy to keep validation centric attributes here. One good reason I have to continue keeping all annotations etc. in the data model is that my view model aggregates data model classes, e.g.
my ViewModelBase.DetailItem<TEntity> property in the view model is just a reference to an entity class in my data model. If I wanted to move presentational annotations to the view model, I would have to quite radically revise my design to one where I duplicate data model properties in my view model and use an object mapping tool to populate view model objects based on data model objects.
[code]....
I am a newbie in mvc3 and i'm wondering how to use attribute like [Display(Name="")] for model that comes from an entity data model that I provide im my "Model" folder in my mvc3 project.
I didn't provide a .cs class for each of my database tables .
other words, I want the controller class render a edit form for me like :
First Name:--- instead of : fName:---
Classic scenario - Categories, Subcategories and Products tables.
Subcategories belong to a corresponding main category
Products belong to a corresponding subcategory
The problem is that not all products do that. Some of them belong directly to a main category because that category has no subcategories. So if I wish to query those products I have to use a main category field in the products table.
And of course I need a subcategory field in the products table also for those products that do belong to a subcategory.
All that does not seem like a good normalized schema.
Now if I use the Adjacency list model the categories and subcategories tables become one (parentID column) and I only have to use a single CatId in my queries.
I am generating links for emails within a class in the model of my MVC site and need to obtain the URL address of the host server the site is running on.
How would I get this?
I'm building an MVC 2 RTM app, and I want to be able to share my model across applications. I'd *like* to be able to implement it like:ASP.NET MVC2 app (holds Views and Controllers)Class library to hold Model(s)WCF app to handle the data transactions with the models via different data stores across apps I had the MVC app working fine, but I wanted to abstract the data stuff and be able to work with the model across apps through the WCF site, so I created a class library project and moved all of the Models classes into that and set-up a WCF app, then added project references to the MVC and WCF apps that point at the class library. The idea was I can create services that take and return objects from the model via method calls across apps. It appears that everything's wired up correctly in the MVC project, so I'm passing the objects stored in the Models class library between controllers and views and everythig is compiling just fine, but for some reason the data is not being passed back from the views to the controller on POST -- all of the properties in the classes are null or empty.
When I debug the app, I can see that the values are stored in the model data dictionary but not the model object itself. What am I doing wrong? Am I on the wrong path, or missing something obvious (to some)?
Is it possible, inside a Custom Model Binder, to fire "something" that "says" the value is invalid so it gets handled by validation part?
Basically, I am getting an exception when the value for the property is invalid.
I made a few changes to the DB in SQL server management studio then right clicked on the .edmx doc to get it to update. That seemed to work fine but when i compiled the app everything that referenced the EF seems to be broken.The Error list now contains the below error for all classes that used it.
The type or namespace name '' could not be found (are you missing a using directive or an assembly reference?)
I have an issue of static variable in an asp.net application. Let's say I have a server with 8 CPUs running windows 2008 R2 hosting an asp.net webbsite, nothing fancy here, no funny configuration.
Is the following statement true? at any single time, there's one and only one process is running and accepting requests, even in the recycling stage. The reason I am asking is: I have a static field in my class, and I want to make that's the only static instance in the website. I've heard in some circumstances, IIS is recylcing your application, and it will start a new process, but the old process is still working, thus I will have 2 static instances in memory, which defeat the purpose of static field.
One step further, let's assume there might be 2 instances in memory, can I assume there are at most 2 instances at any single time? And can I assume once the second instance is up, the first instance will NEVER accept new requests?
Another question: Recently I have a problem with an applicationdomain concept. Looks like if an application domain causes a memory leak, unload the domain will not release the memory (Umanaged leak). So to what extent Application Domain is isolated?
window.href(fileDocmodel='~/../DocTokenPass.aspx?pageopen=DocTokenPass&');
it local open
but server side not open modal window
I am trying to make a post that should use the Default Model Binder functionality in ASP.NET MVC 2 but unfortunately I can't get through. When I click on the checkout button I populate a form dinamically using jQuery code and then submit this form to the server. This is the form that get submitted
<form action="/x/Order/Checkout" id="cartForm" method="post">
<input name="__RequestVerificationToken" type="hidden" value="UDjN9RdWheKyWK5Q71MvXAbbDNel6buJd5Pamp/jx39InuyYIQVptcEubIA2W8DMUzWwnZjSGkLspkmDPbsIxy8EVuLvfCSZJJnl/NrooreouptwM/PaBEz2v6ZjO3I26IKRGZPqLxGGfITYqlf8Ow==">
<input id="CustomerID" name="CustomerID" type="hidden" value="1">
<input id="FirmID" name="FirmID" type="hidden" value="2">
<input type="hidden" name="CartItems[0].ServiceTypeID" value="1">
<input type="hidden" name="CartItems[0].Quantity" value="1">
<input type="hidden" name="CartItems[1].ServiceTypeID" value="2">
<input type="hidden" name="CartItems[1].Quantity" value="1">
</form>
This is the jQuery code that handle the submit event for the form
$("#cartForm").submit(function (event) {
event.preventDefault(); var form = $("#cartForm");
var panel = form.parent(); panel.parent().block();
$.ajax({ type: "post", dataType: "html",
url: '<%: Url.Content("~/Order/Checkout") %>',
async: false, data: form.serialize(),
success: function (response, status, xml) { panel.parent().unblock(); },
error: function (response) { panel.parent().unblock(); } }); });
This is the controller action that should be get called
[HttpPost]
[ValidateAntiForgeryToken]
public virtual ActionResult Checkout( CartModel cart ) {
} And finally this is the CartModel class involved
public class CartModel : BaseModel{
public int CustomerID { get; set; }
public int FirmID { get; set; }
public List<CartItemModel> CartItems { get; set; }
public CartModel() { CartItems = new List<CartItemModel>();
} } public class CartItemModel : BaseModel
{ public int ServiceTypeID { get; set; }
public int Quantity { get; set; } }
But the default Model Binder does not bind the web form data to a CartModel class. Using Fiddler I have been able to see that the data sent to the server is correct as you can see from the following snapshot.
I am using Profile properties in my application... ASP.Net 2.0 , and SQL Server 2005 at my end... well DB production server is SQL Server 2000.. My friend said, 'aspnet_regsql A -p' won't work for SQL Server 2000... I can't check if will work or not...
View 1 RepliesASP.NET server controls has a few categories, for example, normal ones e.g. TextBox, Button which can be done in HTML/JS; Validation controls: can be done in JS; Login controls: I have seen them implemented in JS. Data bound controls: not sure, but maybe JS can work directly with databases, implementing controls like photo slider. So in the time span of next 5-10 years, will server-side web programming model fall out of mainstream and be replaced by JS/Ajax that interacts directly with databases?
View 2 Replieswhen I use Html.HiddenFor( model => model.OwnerId ) to create a hidden field, the value assigned to that field is zero. When I use <input type="hidden" value="<%: Model.OwnerId %>" /> to add the hidden field to the form, the value is assigned correctly.
Why would Html.HiddenFor( model => model.OwnerId ) not get the correct value from the Model object? Am I supposed to load model state somehow separate from returning the model object from the action method? Here is the view:
[Code]....
The Create action method is relatively straight forward.
public ActionResult Create( ... )
{
ViewStockItem item = new ViewStockItem();
item.ActionCode = ActionCode.Add;
if (item.OwnerId == 0)
item.OwnerId = 7;
BookOwner owner = db.BookOwners.Single(c => c.OwnerId == item.OwnerId);
item.OwnerName = owner.OwnerName;
return View(item);
}
Say I got a domain model as follows: (and my repository expect an instance of this object)
[Code]....
And a view model (which my views are based on)
[Code]....
At the moment I got it like this and have my controller action manually create a new Person object from the PersonModel object before passing it on to the repository, which does not feel right.
So I tried to have PersonModel inherit from Person and pass that to the repository (also tried casting the PersonModel to a Person object first), but that don't work out.
What's the right way to have PersonModel automatically cast to Person? I want to keep this logic as my current structure allow me to keep things really loosely coupled, with the repository layer not having a clue how it's being used.
I can't believe I'm having so much trouble finding this information. I'm endeavouring to learn about creating model classes with Linq to SQL. By default VS2010 wants to use SQL Express, but our organisation has several database servers for development so I'd rather use one of those. PLEASE can somebody tell me how I can configure VS2010 to do that, as all I get is 'A network-related or instance-specific error occurred while establishing a connection to SQL Server ... Verify that the instance name is correct'. Yeah, thanks Microsoft. Actually telling me how to verify the instance name would be a really good move here.
View 1 RepliesI need to get model data into a JavaScript variable and use it as an int to compare values. But I can only figure out how to get the model data as strings, otherwise the compiler complains.
So how can I get the max and taskBudgetHours as int variables in the Javascript?
[code]....
I have recently started working on ASP.NET with MVC 2 framework, and I am facing following difficulty in validating my data,
Scenario:
In my application the view (ASPX) is divided into tabs (jQuery) and each tab's content is ViewUserControl (ASCX). The main model for the view has collection of sub models for individual tabs. I use RenderPartial method to render view user control.
[Code]....
And the user control (Tab1.ascx) refers the specific model for it,
[Code]....
Now if in my Tab1Model if I put following validation
[Code]....
In the controller ModelState.IsValid is always indicates TRUE. How do I override the validation behavior such that it as well looks the items in the collection member (which holds sub models) as well.
<%= Html.ValidationMessage("FirstName") %>
I have developed a User Control in inline code model and convert this into dll and try to add it into Visual Studio ToolBox. It shows error "There is no component found in the object.". It is showing actually because i have not added ToolBoxData attribute just before the class declaration, because there is no class declaration in the inline code model. I don't know where i have to add ToolBoxData attribute.
View 1 RepliesI program in ASP.NET for a while now. My applications uses always the DataSet. Some told me that Entity Data Model is the DataSet for LINQ. Now I want to try to working with it I have some questions but can't find the answers. I hope someone can. When I build an application I use the 3-tier structure. So Presentation-layer, Business-layer and the Data-layer. Normally I had some classes in the Data layer with specific methods to interact with the DataSet. When I read the table or something I create an object for the business layer.
With the Entity Data Model it seems a little bit confusing. If I read a table (for example Company) the edmx has created an class already. So is the edmx a replacement for the Data-layer and also for the Business layer? Is the edmx also a good use for multi-user application or is a connected application better?
public ActionResult Index()
{
testEntities6 devicesEntities = new testEntities6();
DevicesModel> devicesModel = new List<DevicesModel>();
var device_query = from d in devicesEntities.device
join dt in devicesEntities.devicetype on d.DeviceTypeId equals dt.Id
[code]...
I have built a simple contact form in an MVC run website, and I got it to work .. Yay !! :D
Then I wanted to add Validation, and so did a google search and gotthis blog entry on Scott Gu's blog.
It turns out validation was a little bit more complex than I had imagined it to be. But still I wanted to do it. So I got working on changing my code to follow the logic of what Scott has said.
I get stuck on the step where I right click on the action and try and add the view. I'm suppose to choose { Create a strongly typed view } with an option to Create.
But the model which I've created called { Email } << a simple C# class does NOT show in the drop down list !!
Here's the code to my Email Model:
[Code]....
For VS 2010, I am trying to add new item of existing mdf file. By : Add new item -> Data -> ADO.NET Entity Data Model -> Generate from database.
When I reach the step of "Choose Your Data Connection", under the : "Which data connection should your application use to connect to database?" The combo-box is empty. How can I make that combo-box not be empty (some configurations?)
I have been reading about different model for development
model view control mvc
model view presenter MVP
Model view view model MVVM
i belive MVC has two big Advantage over webform 1) TDD 2) More control on HTML
MVP is bit variation in mvc model. rapid development as well as 1) TDD 2) More control on HTML (correct me if i m wrong) see the below link
[URL]
have been unable to find any explanation of this anywhere.I have an .ascx partial view that's pulling data from a given model.I want to populate a drop-down list in my partial view using data from a table
outside the model (it is in the same database and entity framework).I don't know the syntax (I'm pretty much just learning MVC2 and jquery), and don't even know where to start. I've gotten about as far as <% foreach step in [???] %>, but don't know what to do with it. What do I put in the "[???]"???